Returns the remainder of the division of two numbers.
Sample Usage
MOD(11, 5)
MOD(C4,C5)
Syntax
MOD(number1, number2)
- number1 - The numerator or dividend.
- number2 - The denominator or divisor.
Examples
MOD(11, 5) returns a value of 1.
MOD(C4,C5) returns the remainder left when C4 is divided by C5.