This Excel tutorial explains 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 )
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 Excel spreadsheet above, the following 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)