The MOD function in Excel returns the remainder of the division i.e. modulus value, when number and divisor is passed as input.
Syntax of MOD Function in Excel
number – The Number to be divided
divisor – The Number that divides.
Example of MOD Function in Excel
- In row number 2 and 3, both Number and Divisor have positive values
- In row number 4 Number is negative and Divisor have positive value
- In row number 5 Number is positive and Divisor have negative value
- Row number 6 Numerator and Denominator are passed as values rather than cell reference
Note: #VALUE! Error occurs if the supplied number argument is non-numeric.
#DIV/0! Error occurs if the divisor argument is Zero