Excel MOD Function to get remainder

This Excel tutorial explains how to use Excel MOD Function to get remainder in division.

Excel MOD Function to get remainder

In Excel worksheet, you can calculate quotient by a division using operator / .  However chances are you need to calculate the quotient as well as reminder. Excel MOD Function calculate the remainder.

Syntax of Excel MOD Function

MOD(number, divisor)
Number The number for which you want to find the remainder
Divisor The number by which you want to divide number

Example of Excel MOD Function

Formula Result Explanation
=MOD(10,3) 1 Remainder of 10/3 = 1
=MOD(-10,3) 2 Note that negative number does not work as expected because of how the function handles negative number
=MOD(ABS(-10),3) 1 To handle negative number, use ABS Function on the negative number before using MOD Function

You can get the quotient using INT Function.

For example

Formula Result
=INT(10/3) 3

 

Outbound References

https://www.techonthenet.com/excel/formulas/mod.php

https://support.office.com/en-us/article/MOD-function-9B6CD169-B6EE-406A-A97B-EDF2A9DC24F3

Wyman W
Wyman is a Human Resources professional based in Hong Kong, specialized in business analysis, project management, data transformation with Access and Excel.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

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