If you need to divide two numbers then it is very easy to do in Excel but what if you need to get the remainder from a division operation in Excel?

**Previously In ****Excel Formulas****: ****RAND Formula to create a Random List in Excel**

Thanks to Excel’s MOD formula it will give you the remainder after dividing one number with another.

Here is the *MOD Formula breakdown:*

=MOD(number1, number2)

** Explanation **for this:

=MOD(a number, divided by this number)

Below are the steps given to know how to apply MOD formula in your Excel:

## Working With MOD Function

Firstly, you will need to **enter the ***MOD ***function **in a blank cell:

**=MOD(**

Now continue the formula with the MOD arguments:

*number1*

**at this place you need to write the first number that you had plan to divide.**

** ***Now mention the cell that contains the first number:*

**=MOD(A2,**

*number2*

*number2*

**Now mention the divisor at this point**

Also, you need to mention *the cell that contains the second number:*

**=MOD(A2, B2)**