ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel MOD Function

Excel MOD Function

How to Use Excel MOD Function
Table of contents :
  • What is the MOD function?
  • MOD Function Syntax
  • How to Use MOD Function in Excel
  • Another Alternative How to MOD
  • MOD Example

Excel MOD Function

What is the MOD function?

What does mod stand for in math? MOD stands for modulus, an operation to find the remaining number after a division operation.

What is the MOD function in Excel? A function to calculate the remainder of the division.

MOD Function Syntax

MOD(number, divisor)

number, required, the number to be divided

divisor, required, the number that will divide the number argument

Usage Note:

  • If divisor value is 0, then returns an error #DIV/0!
  • MOD function result sign always the same as the divisor sign argument.

How to Use MOD Function in Excel

For example, there are data such as the image below. What is the result of the MOD function in column C?
What does MOD stand for

MOD Function #1

=MOD(A2,B2)

The MOD function returns an error #DIV/0! Because the divisor value is 0

MOD Function #2

=MOD(A3,B3)

There is no remainder for each number divided by 1

MOD Function #3

=MOD(A4,B4)

Three divides by two have one remaining; a minus sign appears because the divisor has a minus sign.

MOD Function #4

=MOD(A5,B5)

Not for integer number only, you can use the MOD function for a decimal number. No remainder for 3 divides by 1.5

MOD Function #5

=MOD(A6,B6)

Like the 5th MOD function, you can use decimal number both in number and divisor argument. Three divides by 2.5 return 1 for the remaining number.

Please see the image below for the results of the five functions above.

Excel MOD Function

Another Alternative How to MOD

Another way to do MOD is to use mathematical formulas. The formula below gives the same results as the MOD function.

MOD(n, d) = n - d*INT(n/d)

n is the number argument, d is the divisor argument, and INT is rounding down function to the nearest integer.

The results are as shown below.

MOD Formula in Excel

The MOD function or its alternatives gives the same results. For me, the Excel MOD function is better, than having to write a longer formula 🙂

MOD Example

Another article using or explain about MOD Function
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • How to Separate Date and Time in Excel
  • How to Determine If a Number is Even or Odd

Another Math Function

Another article about Math Function
  • Excel SUBTOTAL Function
  • Excel AGGREGATE Function
  • Excel PRODUCT Function
  • Excel CONVERT Function
  • Excel SUMIFS Function
  • Excel SUMIF Function
  • Excel SUM Function
  • Excel SUMPRODUCT Function
  • Excel QUOTIENT Function
  • Excel MOD Function
Usefull links
  • Microsoft MOD function documentation
Share
Tweet
Google+
Email
Next Article

Related Articles

Excel AVERAGEIFS Function
What is the Excel AVERAGEIFS Function? The Excel AVERAGEIFS function …

Excel AVERAGEIFS Function

Excel CONVERT Function
What is the Excel CONVERT Function? The excel CONVERT function …

Excel CONVERT Function

How to Use Excel IFS Function
What is the Excel IFS Function? Excel IFS Function is …

Excel IFS Function

Excel IFERROR Function
What is the Excel IFERROR Function? The Excel IFERROR function …

Excel IFERROR Function

Excel SUBSTITUTE Function
What is the Excel SUBSTITUTE Function? The excel SUBSTITUTE function …

Excel SUBSTITUTE Function

Tags:Excel MOD Excel MOD Function How to Find MOD How to MOD Math Function MOD Definition MOD Formula in Excel What Does MOD Mean What Does MOD Mean in Math What Does MOD Stand For What is MOD Whats a MOD

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh