How to Use the FLOOR Function in Excel Step-by-Step (2023)
Are you tired of manually rounding down your numbers in Excel?
Say hello to the FLOOR function!
It allows you to quickly round numbers down to the nearest specified multiple.
In this guide, we’ll see how to use the FLOOR function in Excel. And learn how to quickly streamline our calculations and save time.
Let’s get started! 🚀
You can also download our sample workbook here to practice the FLOOR function in Excel.
Table of Contents
What to use the FLOOR function for
The FLOOR function in Excel rounds numbers down to the nearest specified multiple. It’s useful for financial, time, and unit conversion calculations.
For finance, you can use the Excel FLOOR function to round numbers to the nearest multiple. For time values, you can use it to round down the time to the nearest hour or second ⌚
It can also be used for data analysis by grouping data into categories. Overall, it’s a versatile tool that makes calculations more efficient and accurate.
The syntax of the FLOOR Function is given as:
where “number” is the value you want to round down and “significance” is the multiple you want to round down to.
How to use the FLOOR function
Let’s now see a quick example of how to use the FLOOR function in Excel.
Say, we have the following sample data.
We want to round off each numeric value using the FLOOR function in Excel.
To do that,
- Select cell B2.
- Enter the FLOOR formula as:
- Enter the cell reference containing the decimal value in the Excel spreadsheet.
- Now add in the significance argument – in our case – 1.
- Press Enter.
The Excel floor function rounds the number to the nearest specified place and returns 15.
Double-click the Fill Handle to copy the formula to the remaining cells.
And it’s done! 🥇
Note that rounding occurs for the negative value as well as the positive value. The floor function returns the number with a negative sign after rounding it off.
For instance, -99.9 in cell A5 was rounded off to -100.
Pretty easy, no? Try it yourself using the sample workbook provided above.
That’s it – Now what?
In this article, we saw what the use of the FLOOR Function in Excel is. We also saw how to use the FLOOR function for calculations and rounding off decimals.
All in all, the FLOOR function in Excel is a powerful tool for quickly rounding off numbers.
By following the guide we provided, you should be able to use and master the FLOOR function in no time ⌚
No matter you’re an Excel expert or a beginner, knowing how to use the FLOOR function is a must. So give the FLOOR function a try and see how it can benefit your work today!
And if you need additional rounding functions, Excel has a variety of options to choose from. Apart from that, you can try the IF, SUMIF, and VLOOKUP functions.
You can learn them for free in my 30-minute free email course that teaches this and more. So sign up now! 😃
Did you enjoy reading this article? If yes, then you’d love to know more.
Try similar topics: Roundup in Excel, Excel Truncate, Create Formula, and more.