DIVIDE (/)

Description

The DIVIDE (/) operator divides one number by another.

Usage

a / b

Remarks

Both a and b must be numbers. You can use the VALUE function to convert the arguments to numbers.

If both a and b are blank, then the result is also blank. However, if only one is blank, the blank value is treated as zero.

Dividing by zero results in a blank number.

Example

If you have a form with data about schools that contains two quantity fields, STUDENT_COUNT and TEACHER_COUNT and want to calculate the student-teacher ratio, you could use the formula:

STUDENT_COUNT / TEACHER_COUNT
Next item
FLOOR