MOD

Definition: MOD is a function that returns the remainder of a division operation.

Syntax: =MOD(number, divisor)

Situation: This formula is appropriate when you need to find the remainder of a division operation.

Example: If you have a number 10 and want to find the remainder when divided by 3, the formula =MOD(10, 3) can be used, which returns 1.