From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

# FLOOR function in Excel

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

### 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. You can also use this function with negative numbers, in which case it will round the number up to the nearest multiple.
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.