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