The MOD function
Returns the remainder after division. The result has the same sign as the divisor.
Syntax
MOD(number, divisor)- number
- The number to divide.
- divisor
- The number to divide by.
Examples
B1
=MOD(110,23)| A | B | |
|---|---|---|
| 1 | 1 |
In plain words: The remainder when 110 is divided by 23.
B1=MOD(-3,4)
| A | B | |
|---|---|---|
| 1 | 1 |