MOD
Name
Mod
Description
Returns the remainder after the Number argument (dividend) is divided by the Divisor argument.
Syntax
MOD(Number, Divisor)
Remarks
Arguments are as follows:
Argument | Description |
---|---|
Number | Number for which you want to find the remainder (dividend) |
Divisor | Number by which you want to divide the Number argument |
The remainder has the same sign as the Divisor argument.
Data Type
Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
MOD(R1C2,12)
MOD(B3,10)
MOD(C4,B2)
MOD(255,16)=15
MOD(-3,2)=1