MOD
Returns the remainder from division.
Math & TrigonometryMath Basics
What it does
Calculates the remainder after dividing a number by a divisor.
Syntax
MOD(number, divisor)
Arguments
number(number) — Dividend.divisor(number) — Divisor.
Examples
Remainder
7 mod 3.
FORMULA
=MOD(7, 3)
RESULT
1
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val | Div |
| 2 | 7 | 3 |