Learn how to use the Excel MOD function with syntax and examples.
The Microsoft Excel MOD function returns the remainder after a number is divided by a divisor.
The syntax for the Microsoft Excel MOD function is:
MOD( number, divisor )
number is a numeric value whose remainder you wish to find.
divisor is the number used to divide the number parameter. If the divisor is 0, then the MOD function will return the #DIV/0! error.
The MOD function can be used in the following versions of Microsoft Excel:
The MOD function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel MOD function examples and explore how to use the MOD function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel MOD examples would return:
=MOD(A1, A2) Result: 2 =MOD(A1, A3) Result: -7 =MOD(34, A2) Result: 0 =MOD(34, 0) Result: #DIV/0!
(scroll to see more)