## What is FLOOR.MATH Function in Excel?

The **FLOOR.MATH** function is one of the math functions of Excel.

It Rounds a number down, to the **nearest integer or to the nearest multiple **of significance.

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

## How to use FLOOR.MATH function in excel

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

2. Click on **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 **FLOOR.MATH** function

6. Then select **ok**

7. In the function arguments Tab you will see **FLOOR.MATH** function

8. Number is **the value you want to round**

9. Significance is **the multiple to which you want to round**

10. Mode is when **given and nonzero this function** will round towards zero

11. You will see **results **in the formula result section

## Examples of **FLOOR.MATH** function in Excel

**Example 1:**

**How to use FLOOR.MATH function in excel**

You can see examples of FLOOR.MATH function below:

**floor.math**(A2,B2) ----->>>>answer is 3
**floor.math**(A3,B3,C3) ----->>>>answer is -33
**floor.math**(A4,B4) ----->>>>answer is -6
**floor.math**(A5,B5,C5) ----->>>>answer is 6
**floor.math**(A6,B6,C6) ----->>>>answer is -4
**floor.math**(A7,B7,C7) ----->>>>answer is 0

## What is the purpose of **FLOOR.MATH** function?

**FLOOR.MATH**

It Rounds a number down, to the **nearest integer or to the nearest multiple **of significance.

## What is the Return value of **FLOOR.MATH** function?

**FLOOR.MATH**

It returns a number.

## How many arguments does **FLOOR.MATH** function have?

**FLOOR.MATH**

This function has just **3** Argument.

The **argument **of FLOOR.MATH function is **number**.

Number is **the value you want to round**.

Significance is **the multiple to which you want to round**.

Mode is when **given and nonzero this function** will round towards zero.

The argument of FLOOR.MATH function is **required **and not optional.

```
FLOOR.MATH(number) = number
```

## Which version of excel supports **FLOOR.MATH** function?

**FLOOR.MATH**

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

## Errors in **FLOOR.MATH** function

**FLOOR.MATH**

## FLOOR.MATH** related functions :**

- FLOOR function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- CEILING function
- CEILING.MATH function
- MROUND function
- EVEN function
- ODD function
- INT function
- TRUNC function