Returns the reminder of the division of the specified number.
Syntax
 Copy Code
|
|---|
MOD( Number number, Number divisor ) → Number |
Parameters
- number
- Required. The number to divide.
- divisor
- Required. The number to divide by.
Remarks
If divisor is zero, the function returns #DIV/0!.
Example
| Formula
Copy Code
|
|---|
=MOD(5,2) |
See Also
Function Reference
INT Function
ROUND Function
ROUNDDOWN Function
ROUNDUP Function
TRUNC Function
QUOTIENT Function