Returns one number divided by another. Equivalent to the / operator.
Sample Usage
DIVIDE(4,2)
DIVIDE(A2,B2)
Syntax
DIVIDE(dividend, divisor)
-
dividend- The number to be divided. -
divisor- The number to divide by.divisorcannot equal0.
Notes
DIVIDEis equivalent toQUOTIENT.
See Also
SUM: Returns the sum of a series of numbers and/or cells.
PRODUCT: Returns the result of multiplying a series of numbers together.
QUOTIENT: Returns one number divided by another, without the remainder.
MULTIPLY: Returns the product of two numbers. Equivalent to the \* operator.
MINUS: Returns the difference of two numbers. Equivalent to the - operator.
ADD: Returns the sum of two numbers. Equivalent to the + operator.