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.
Examples
Student-teacher ratio
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
Percentage increase
If you have a Form with data that shows the yearly yields of certain products on different Farms. You can use a Calculated Field with the divide Formula to calculate the percentage difference between the yearly yields.
To do so, you would use a combination of the SUBTRACT (-
), DIVIDE (/
) and MULTIPLY (*
) Formulas along the logic of: (New value minus Old value) divided by the Old value, multiplied by 100).
((yield_2022 - yield_2021) / yield_2021) * 100