The DIVIDE (/) operator divides a value by another and returns the quotient. It is essential for basic calculations: splitting a value into equal parts, calculating an average, or a percentage. It returns a number (whole or decimal).
Syntax
value1 / value2
Examples
Divide two numbers
20 divided by 4 gives an exact quotient.
20 / 4
Result: 5.
Decimal result
10 / 3 returns 3.333..., because the result is not a whole number.
Calculate a percentage
DIVIDE combined with a multiplication calculates a percentage: if part is 25 and total is 100, the result is 25.
part / total * 100
Go further
MULTIPLY
The inverse operation of DIVIDE.
Or continue with
Formula glossary
All available operators and functions, sorted by category.