This function returns the remainder of a division operation.
Syntax
MOD(dividend,divisor)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| dividend | Number for which you want to find the remainder by dividing the divisor into it |
| divisor | Number by which you want to divide the dividend argument |
Remarks
The remainder has the same sign as the divisor.
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
MOD(B3,10)
MOD(C4,B2)
MOD(R1C2,12)
MOD(255,16) gives the result 15
MOD(-3,2) gives the result 1
Version Available
This function is available in product version 1.0 or later.
See Also
PRODUCT | QUOTIENT | Math and Trigonometry Functions