MOD function

Category: Mathematical functions

What does this function do?

Returns the remainder (residue) of the division of two numbers.

Syntax:

MOD(number,divisor)

• number (required): The number for which you want to find the remainder.
• divisor (required): The number by which you want to divide number.

Examples:

=MOD(11,2) = 1

If A1 = 11 

=MOD(A1,2) = 1