Excel MOD Function

This post will guide you how to use Excel MOD function with syntax and examples in Microsoft excel.

Description

The Excel MOD function returns the remainder of two numbers after division. So you can use the MOD function to get the remainder after a number is divided by a divisor in Excel. And the returned result will have the same sign as divisor.

The MOD function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.

The MOD function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the MOD function is as below:

=MOD (number, divisor)

Where the MOD function arguments are:

  • number – This is a required argument.The number that you want to get the remainder.
  • divisor – This is a required argument. The number that you want to divide number.

Note:

  • If the divisor is 0, then the MOD function will return the #DIV/0! Error.
  • The MOD function returns a result in the same sign as the divisor.

Excel MOD Function Examples

The below examples will show you how to use Excel MOD Function to get the remainder after number is divided by divisor.

1# to get the remainder of 6/5, enter the following formula in Cell B1.

=MOD(6,5)

excel mod examples1 - Copy

2# 1# to get the remainder of -6/5, enter the following formula in Cell B1.

=MOD(-6,5)

excel mod examples2 - Copy

You will see that the sign is the same as divisor.


Related Functions

  • Excel INT Function
    The Excel INT function returns the integer portion of a given number. And it will rounds a given number down to the nearest integer. The syntax of the INT function is as below:= INT (number)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar