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.

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
Next item
FLOOR