This function returns the remainder of a division operation.
MOD(dividend,divisor)
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 |
The remainder has the same sign as the divisor.
Accepts numeric data for both arguments. Returns numeric data.
MOD(B3,10)
MOD(C4,B2)
MOD(R1C2,12)
MOD(255,16) gives the result 15
MOD(-3,2) gives the result 1