Returns the remainder after a number is divided by a divisor.
Söz dizimi
MOD(number, divisor)Bağımsız değişkenler
numberzorunlu
The number for which you want to find the remainder.
divisorzorunlu
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.