MOD Function in Excel

What is MOD Function in Excel?

The MOD function is one of the math functions of Excel.

It returns the remainder after a number is divided by a divisor.

We can find this function in Math & trig of insert function Tab.

How to use MOD function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on the fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select MOD function

6. Then select ok

 math and trig function category in excel

7. In the function Arguments Tab you will see MOD  function

8. Number section is the value for which you want to find the remainder after the division is performed

9. Divisor section is the number by which you want to divide a number

10. If you enter for example(100,10) result will be 0

 MOD function in excel

11. If you enter (100,9) result will be 1

How to use MOD function in excel

12. If you enter (-100,9) result will be 8

How to use MOD function in excel

13. You will see results in the formula result section

Things to Remember

  • The argument of this function is number
  • The argument of this function is required and not optional
  • This function is available for all excel versions (2007-2019)

Examples of MOD function in excel

Example 1:

How to use MOD function in excel

You can see examples of MOD function below:

Examples of MOD function in excel
mod(A2,B2) ----->>>>answer is  3.141

mod(A3,B3) ----->>>>answer is  2.094

mod(A4,B4) ----->>>>answer is   1.570

mod(A5,B5) ----->>>>answer is  1.047

mod(A6,B6) ----->>>>answer is   0

What is the purpose of MOD function?

It returns the remainder after a number is divided by a divisor.

What is the Return value of MOD function?

It returns a number.

How many arguments does MOD function have?

This function has just 1 Argument.

The argument of MOD function is number.

Number section is the value for which you want to find the remainder after the division is performed.

Divisor section is the number by which you want to divide a number.

The argument of MOD function is required and not optional.

MOD(number) = number

Which version of excel supports MOD function?

This function is available for all excel versions (2003-2019)

Errors in MOD function

MOD related functions :

Leave a Reply

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