Excel is a spreadsheet developed by Microsoft. We can perform various mathematical calculations on it. The Excel FLOOR function can round a given number down to the nearest specified multiple. For example, providing the number **10 **and its **significance value as 3** will give the **output as 9**. This built-in function is categorized as a Math Function in Excel.

Here, we will learn the usage of the **Excel FLOOR Function** with its basic syntax, explanation, and examples. Get an official version of** **MS **Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## What is the Floor Function?

Floor is one of the **built-in functions** in Microsoft Excel. It comes under **Math **functions. We can use this function in our spreadsheet whenever we want to **round a given number to the nearest specified multiple**.

### 1) Syntax

- This is the basic syntax of the Excel Floor Function.

**=FLOOR(number, significance)**

### 2) Arguments

**Number –**The input value that you want to round.**Significance –**The multiple which is used to round the given number.

### 3) Motive

- This function helps to
**round the given number****to the nearest specified multiple**.

### 4) Return Value

- It returns the
**rounded number**.

**Note:**

1) If either a number or significance is non-numeric (letters, symbols), it returns the **#VALUE! Error**.

2) When you use a **positive input number** and a **negative significant number**, it shows **#NUM! Error **value.

3) If the number is an exact multiple of significance, no rounding occurs.

## What Will Floor Function Do?

As we said earlier, the Floor function will return a **rounded number** based on the nearest specified multiple. This function is categorized as “**Math**” in Excel. For example, if you give the **FLOOR(23, 4)**, it returns the output as **20**. Let’s see an example scenario to make you understand it easily.

**Step 1:** For example, we have a **set of integer values** in the range **B3:C7**. and we want to round those values with the help of the Floor Function.

**Step 2: **Now, we need to **apply **the **following formula** in any cell where we want to get the result.

**=FLOOR(B3,C3)**

**Step 3:** Now, **click **on the **Enter button** to get the result.

**Step 4:** In order to **fill down the remaining cells**, you just need to drag the first cell. It will auto-fill the remaining values, as shown in the below image.

We hope that the given scenario helped you to understand the Floor function. Move to the below section if you have any confusion related to the working nature of this function.

## Alternate Example

Here we will see how to apply the FLOOR function in the spreadsheet with simple examples.

**1)** Suppose you want to round the integer values on your spreadsheet, then you can directly apply the formula in the cell.

**2)** For example, we want to **round the integer** 322 by 72. We can apply the following formula in a cell where we want the result.

**=FLOOR(322,72)**

**3)** **Hit **the **Enter button** to get the result, as shown in the below image.

By doing so, you can quickly round the integers using the FLOOR function.

## Source for the Errors

- If either a number or significance is non-numeric (letters, symbols), it returns the
**#VALUE!**Error.

- When you use a
**positive input number**and a**negative significant number**, it shows**#NUM!**Error value.

## Citations

To understand the usage of the FLOOR function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: Excel FLOOR function^{[1]}, and What is FLOOR function?** ^{[2]}**.

- https://www.javatpoint.com/excel-floor-function
- https://en.wikipedia.org/wiki/Floor_and_ceiling_functions

## Wind-Up

With the help of the given scenarios and examples, you can easily understand the **purpose of the FLOOR function** **in Excel** and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your **feedback **in the below comment section. Thanks for visiting **AawExcel**. Keep Learning!!

If you want to know what people think about this FLOOR Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel FLOOR function. Here, we have provided the link to Quora’s official website.

## Video Tutorial

The following video will show you how to use the Excel FLOOR function in the spreadsheet with proper examples.

**Read Also:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?