# 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