Thursday, August 11, 2016

MOD Function(WS)

Description

The Microsoft Excel MOD function returns the remainder after a number is divided by a divisor.

Syntax

The syntax for the MOD function in Microsoft Excel is:
MOD( number, divisor )

Parameters or Arguments

number
A numeric value whose remainder you wish to find.
divisor
The number used to divide into the number parameter. If the divisor is 0, then it will return the #DIV/0! error.

Applies To

  • Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

  • Worksheet function (WS)

Example (as Worksheet 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:
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!