How to Use the FLOOR Function in Excel Step-by-Step (2024)

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:

=FLOOR(number, significance)

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.

Sample data fir Excel Floor function template

We want to round off each numeric value using the FLOOR function in Excel.

To do that,

  1. Select cell B2.
Selecting cell B2 for exact multiple of Floor function Excel template
  1. Enter the FLOOR formula as:

=FLOOR(

Microsoft Excel floor function
  1. Enter the cell reference containing the decimal value in the Excel spreadsheet.

=FLOOR(A2,

Enter the cell reference
  1. Now add in the significance argument – in our case – 1.

=FLOOR(A2, 1)

Enter the positive significance argument - significant value with same arithmetic sign
  1. Press Enter.

The Excel floor function rounds the number to the nearest specified place and returns 15.

The result appears 15 of the number 15.8

Double-click the Fill Handle to copy the formula to the remaining cells.

Fill Handle copies the result to 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.

Kasper Langmann, Microsoft Office Specialist

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! 😃

Other resources

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.

Written by Kasper Langmann

Hi, I'm Kasper Langmann👋

I'm the co-founder of Spreadsheeto, a certified Microsoft Office Specialist, and a Microsoft MVP.

With over 10 years of experience, I’ve taught Excel to millions of people worldwide.

I spent over 6 hours researching and writing this tutorial.

Last updated on August 30th, 2024.

Before you go, sign up for my free Excel course (+100,000 students) ->