Returns the remainder after a number is divided by a divisor.
Cú pháp
MOD(number, divisor)Đối số
numberbắt buộc
The number for which you want to find the remainder.
divisorbắt buộc
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.