Returns the remainder after a number is divided by a divisor.
Syntaxe
MOD(number, divisor)Arguments
numberobligatoire
The number for which you want to find the remainder.
divisorobligatoire
The number by which you want to divide.
The MOD function calculates the remainder of a division operation. The result has the same sign as the divisor.
=MOD(10, 3)→110 divided by 3 is 3 with a remainder of 1.
=MOD(15, 4)→315 divided by 4 is 3 with a remainder of 3.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =MOD(number, divisor) and replace the arguments with your specific values or cell references.
Press Enter
Press Enter to calculate the remainder.
The MOD function will return a #DIV/0! error.