- Home
- Data Visualization
- Tools
- Excel Formula Generator
- Excel Formula Explainer
- Google Apps Script Generator
- Excel VBA Script Explainer
- Excel VBA Script Generator
- Excel VBA Code Optimizer
- Excel VBA Code Debugger
- Google Sheets Formula Generator
- Google Apps Script Explainer
- Google Sheets Formula Explainer
- Google Apps Script Optimizer
- Google Apps Script Debugger
- Excel File Translator
- Excel Template Generator
- Excel Add-in
- Your Virtual AI Assistant For Excel Spreadsheets
- AI Answer Generator
- AI Math Solver
- AI Graph Generator
- AI SQL Generator

- Pricing
- Resources

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

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.

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.

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

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.

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

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.

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

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.

WEEKLY BLOG ARTICLES WITH INDUSTRY NEWS AND HELPFUL GUIDES