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.

Summary

Function Definition
About Function
Syntax
How to use FLOOR Function in your workbook
Frequently Asked Questions
More similar formulas

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.

Struggling with your Excel formulas?
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.

Try for free

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

FLOOR function ms excel - excel formula explained - ajelix - floor function example

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

Floor function ms excel - excel formula explained - floor formula - ajelix - result

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

Bonus Example

FLOOR function MS Excel - floor excel function example - ajelix - excel formulas and functions

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:

Open Microsoft Excel on your computer.
Enter the data you want to use the floor function on in the cells of your spreadsheet.
Select the cell that contains the number you want to use the floor function on.
Click the “Formulas” tab at the top of the page.
Select “Math & Trig” from the list of categories on the left side of the page.
Click “FLOOR” from the list of functions.
Enter the number of decimal places you want to round down to in the “Number” box.
Enter the number you want to use the floor function on in the “Number” box.
Click “OK” to execute the function and display the result in the cell.
Copy and paste the result into other cells as needed.

Back to Excel Formula Cheat Sheet

Frequently Asked Questions

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.