MOD Function Reminder of a Division

So far we discussed about how to get the INTEGER portion from a division.

To get the INTEGER portion from a division this, we used QUOTIENT function and INTEGER function.

In this article, we will discuss How to get the reminder part of a division in Excel.

Microsoft Excel provides MOD Function. MOD function is very simple and very easy to use.

Let’s discuss it.

Description

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

Note : The basic mathematics says that if we try to divide any number by 0 (zero), the result will be an indeterminate form.

Therefore, if the divisor is 0, then the MOD function will return the #DIV/0! error.

The MOD function is categorized as a Math/Trig Function and can be entered as part of a formula in a cell of a worksheet, i.e., as nested function.

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.

Returns

The MOD function returns a numeric value.

If the divisor is 0, then the MOD function will return the #DIV/0! error.

Example :

Suppose we need to get the reminder part of a division, the divisor is 5 and the dividend is 17.

The formula will be =MOD(17,5) or you can give cell reference as the below image shows.

Please look at the below image, which displays how to use MOD function.

How to use MOD Function in Excel

Please note :

1.   QUOTIENT Function is used to get the Integer portion of a division.

2.   Whereas MOD Function is used to get the Reminder part of a division.

3.   The division result without reminder is simply use a ‘/’, without quotes in a formula.

I hope you have enjoyed this small article. Take care…

Thank you for reading…