What is MOD?
Returns the remainder after division. Essential for cyclic calculations, determining odd/even, and time conversions.
Syntax
=MOD(number, divisor)
Example
Formula: =MOD(17, 5)
Result: 2
How It Works
Returns remainder when 17 is divided by 5 (17 = 3×5 + 2, so remainder is 2). Useful for determining patterns and cycles.