From data to report in one minute or less. Ajelix BI is launched! đźš€ Get started for free.

# How To Use FLOOR function in Excel With Examples

### What is FLOOR function in Excel?

The FLOOR function in Microsoft Excel is a mathematical function that can be used to round a number down to the nearest integer. It is useful for finding the largest integer that is less than or equal to a given number.

### Description

The FLOOR function rounds a number down to the nearest multiple of a specified value. This function is commonly used to round down a number to the nearest integer, which can be used to apply standard rounding rules or to round down a number to the nearest multiple of a given value.

For example, the function can be used to round down an amount to the nearest multiple of 5 or 10. This is useful for creating a discount table or performing calculations involving multiples of a certain number.

Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

### Syntax

=FLOOR(number, significance)

number argument: is the number to round down

significance argument: is the multiple to which you want to round down a number.

#### FLOOR Function Example in Excel

In example we can see that we want to round down the numbers to 100. You can change the significance to whatever number you want 1000, 10, 0.1, etc.

#### Function Example Result in Excel

In this screenshot you can see that function rounded to the lowest whole number in our case to 100.

#### Bonus Example

We added bonus example to show that you can change significance number to round value to the lowest number. Here you can see that the same data as in the picture above is rounded to 10.

### How to use FLOOR function MS Excel in your workbook:

1. Open Microsoft Excel on your computer.
2. Enter the data you want to use the floor function on in the cells of your spreadsheet.
3. Select the cell that contains the number you want to use the floor function on.
4. Click the â€śFormulasâ€ť tab at the top of the page.
5. Select â€śMath & Trigâ€ť from the list of categories on the left side of the page.
6. Click â€śFLOORâ€ť from the list of functions.
7. Enter the number of decimal places you want to round down to in the â€śNumberâ€ť box.
8. Enter the number you want to use the floor function on in the â€śNumberâ€ť box.
9. Click â€śOKâ€ť to execute the function and display the result in the cell.
10. Copy and paste the result into other cells as needed.

How does FLOOR function work?

The function rounds a number down to the nearest multiple of a specified value. It takes two arguments, the number and the multiple. For example, if you use the function FLOOR(10,2) it will return 8. This is because 8 is the nearest multiple of 2 to 10.Â

What is FLOOR example in Excel?

=FLOOR(A1,5) where A1 is the cell containing the original number. This formula will round the number down to the nearest multiple of 5. For example, if A1 contains the number 7.3, the formula would return the value 5.

Can FLOOR handle negative numbers?

Yes, FLOOR rounds down regardless of the sign.

### More similar functions and formulas

WEEKLY BLOG ARTICLES WITH INDUSTRY NEWS AND HELPFUL GUIDES

### How To Add Checkboxes In Excel

#### Business Intelligence platform meets AI

Trusted by 150'000 customers around the globe since 2018.

Â© 2018 - 2024 AJELIX, SIA