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:
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.