## What is FLOOR Function in Excel?

The **FLOOR** 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 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 **FLOOR** function

6. Then select **ok**

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

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

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

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

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

**Example 1:**

**How to use FLOOR function in excel**

You can see examples of FLOOR function below:

**floor**(A2,B2) ----->>>>answer is 9
**floor**(A3,B3) ----->>>>answer is 8
**floor**(A4,B4) ----->>>>answer is 15
**floor**(A5,B5) ----->>>>answer is -15
**floor**(A6,B6) ----->>>>answer is -14

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

**FLOOR**

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

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

**FLOOR**

It returns a number.

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

**FLOOR**

This function has just **2** Argument.

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

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

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

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

```
FLOOR(number) = number
```

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

**FLOOR**

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

## Errors in **FLOOR** function

**FLOOR**

## FLOOR** related functions :**

- MROUND function
- CEILING function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- INT function
- TRUNC function