Kornilios Ampatzis/ April 19, 2019/ Functions

Returns the remainder after number is divided by divisor. The result has the same sign as the divisor.

The syntax of the function is the following:

MOD(number, divisor)

number: The number for which you want to find the remainder.
divisor: The number by which you want to divide the number.

If divisor is 0, it returns a #DIV/0! error.

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the MOD function:

In the cell Α4 calculate the modulo of the division of the cell A1 by the cell B1.

Share this Post