## 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

- Click on an
**empty**cell (like F5 )

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

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

4. Select **math and trig** category

5. Select **MOD** function

6. Then select **ok**

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**

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

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

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:

**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?

**MOD**

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

## What is the Return value of **MOD** function?

**MOD**

It returns a number.

## How many arguments does **MOD** function have?

**MOD**

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?

**MOD**

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

## Errors in **MOD** function

**MOD**