Microsoft Support
support.microsoft.com › en-us › office › floor-function-14bb497c-24f2-4e04-b327-b0b4de5a8886
FLOOR function - Microsoft Support
The FLOOR function in Excel rounds a specified number down to the nearest specified multiple of significance.
Exceljet
exceljet.net › floor function
Excel FLOOR function | Exceljet
September 13, 2021 - Round a number down to the nearest specified multiple · A rounded number. ... The Excel FLOOR function rounds a number down to a given multiple. The multiple to use for rounding is provided as the significance argument.
Floor function in VBA code
I found Round() but I can't find a Floor() math function within the VBA code side of the excel. For those not math inclined, Floor(5.65) = 5, whereas... More on mrexcel.com
9
0
August 14, 2006Unexpected results of FLOOR function with time values
I have a difficulties using the FLOOR function with time values. It mostly works, however if the first parameter is calculated, results are not always as expected. Example: When I round down a value "10:00" using a formula =FLOOR("10:00"-TIME(9;30;0); "0:30"), the result is "0:30" as expected... More on mrexcel.com
7
0
August 22, 2023What 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.
ajelix.com
ajelix.com › home › resources › formulas and functions › floor function ms excel
How To Use FLOOR Function in Excel Guide With Examples - Ajelix
How do I use the FLOOR function?
To use the FLOOR function, you need to provide two arguments (the number and significance value). For instance, =FLOOR(16.9, 5) will round 16.9 down to the nearest multiple of 5, resulting in 15.
wps.com
wps.com › home › blog › excel resources › how to use floor function in excel (simplest steps with examples)
How to Use Floor Function in Excel (Simplest Steps with Examples)
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.
ajelix.com
ajelix.com › home › resources › formulas and functions › floor function ms excel
How To Use FLOOR Function in Excel Guide With Examples - Ajelix
Videos
02:04
CEILING and FLOOR Excel Functions (with examples) - YouTube
Microsoft Excel - Using the CEILING and FLOOR functions
01:31
How to Use the FLOOR.MATH Function in Excel to Round Data to a ...
01:24
How to use FLOOR and CEILING Function of Excel | Excel Amazing ...
01:30
FLOOR Function | Quick Excel Tips - YouTube
03:35
CEILING, FLOOR, ROUND Functions in Microsoft Excel - YouTube
SpreadsheetWeb
spreadsheetweb.com › home › function: floor
Function: FLOOR
May 29, 2019 - The Excel FLOOR function is a Math formula that rounds a given number down to the nearest multiple of significance. This function is predecessor of the FLOOR.MATH function that was released in Excel 2013.
DataCamp
datacamp.com › tutorial › excel-floor
Excel FLOOR(): How to Round Down Numbers in Excel | DataCamp
July 1, 2025 - Round down with precision using Excel’s FLOOR() function.
MrExcel
mrexcel.com › forums › question forums › excel questions
Floor function in VBA code | MrExcel Message Board
August 14, 2006 - Sub test() Dim result As Long Dim starttime As Double Dim i As Long starttime = Timer For i = 1 To 3000000 'result = Int(5.65) - 1 * (Int(5.65) > i) result = Application.WorksheetFunction.Floor(5.65, 1) Next i Debug.Print Timer - starttime starttime = Timer For i = 1 To 3000000 result = Int(5.65) - 1 * (Int(5.65) > i) 'result = Application.WorksheetFunction.Floor(5.65, 1) Next i Debug.Print Timer - starttime End Sub
Microsoft Support
support.microsoft.com › en-us › office › floor-math-function-c302b599-fbdb-4177-ba19-2c2b1249a2f5
FLOOR.MATH function - Microsoft Support
Syntax: FLOOR.MATH(number, significance, mode)
MrExcel
mrexcel.com › forums › question forums › excel questions
Unexpected results of FLOOR function with time values | MrExcel Message Board
August 22, 2023 - I would like to understand why the FLOOR function does not work as expected sometimes. Click to expand... Hi, the problem is almost certainly caused by "floating point rounding errors" (an internet search will reveal lots of information on the subject) - the TIME() function appears to round these errors better so you could jump through a few hoops like this to get to the right answer. Excel Formula: =FLOOR(LET(t,TIME(8,0,0)-"07:30",TIME(HOUR(t),MINUTE(t),SECOND(t))),"00:30") Upvote 0 ·
MyExcelOnline
myexcelonline.com › home › the ultimate guide to floor function in excel
The Ultimate Guide to Floor Function in Excel | MyExcelOnline
December 22, 2024 - Zero or Non-Numeric Inputs: If ... avoid this issue. The FLOOR function is an Excel feature that rounds down a given number to the nearest specified multiple....
WPS Office
wps.com › home › blog › excel resources › how to use floor function in excel (simplest steps with examples)
How to Use Floor Function in Excel (Simplest Steps with Examples)
October 16, 2025 - The FLOOR function in Excel is a mathematical tool that is designed to round numbers down to a stated multiple or significance. It is used to confirm that a specified number is rounded to the nearest lower value depending upon a designated interval.
Ajelix
ajelix.com › home › resources › formulas and functions › floor function ms excel
How To Use FLOOR Function in Excel Guide With Examples - Ajelix
March 14, 2024 - The FLOOR function in Microsoft Excel is a mathematical function that can be used to round a number down to the nearest integer.
Formula Bot
formulabot.com › home › excel formulas › floor excel formula function
FLOOR Excel Formula Function in Excel
In simpler terms, the FLOOR function helps you control the precision of your data by rounding down to the nearest specified multiple, making it easier to manage and analyze numerical data.
Wall Street Mojo
wallstreetmojo.com › home › all blogs › excel resources › floor function in excel
FLOOR Function in Excel (Formula, Examples) | How to Use?
December 20, 2024 - This formula in Excel always takes two arguments: the number and the significance. Both are required. The significance means the factor that will help find a value, the nearest multiple of the number. Number: It is the number that we want to round. Significance: It is the multiple or factor we want to round the number. If the price of a given commodity is $6.42, and we want to round it down to the nearest value divisible by 5 cents, we can use the FLOOR function.
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › rounding in excel: round, roundup, rounddown, floor, ceiling functions
Rounding in Excel: ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING functions
May 3, 2023 - Microsoft Excel provides 3 functions that let you round numbers to nearest half, more precisely to the nearest multiple of 0.5. Which one to use depends on your rounding criteria. To round a number down to nearest 0.5, use the FLOOR function, ...
ExcelMojo
excelmojo.com › home › floor function in excel
FLOOR Function in Excel - Formula, Examples, How to Use?
June 24, 2025 - The FLOOR function round down the value towards zero. In simple words, the function returns the lower value to the nearest significant factor. The syntax of the FLOOR Excel Function is =FLOOR(number, significance) where both the arguments are ...
ExtendOffice
extendoffice.com › excel tips › excel functions › excel floor function
How to use the Excel FLOOR function
October 11, 2024 - Based on the values in table C3:G4, which contains the numbers and the corresponding specified significance, please use FLOOR function to round down and get the nearest multiples as this: =FLOOR(C3,C4) //or directly use a number in the formula =FLOOR(10,1) Press Enter key to get the first result, then drag autofill handle right to get other results. Excel FACT Function The FACT function eturns the factorial of a given number.
Excel Tip
exceltip.com › home › excel functions list
How to use the FLOOR function in Excel
October 20, 2021 - In this article, we will learn about how to use the FLOOR function in Excel. The FLOOR function rounds down the number to the nearest specified multiple. FLOOR rounds to the nearest integer, using a 1 as significance.
My Online Training Hub
myonlinetraininghub.com › home › blog › excel ceiling and floor functions
Excel CEILING and FLOOR Functions • My Online Training Hub
April 19, 2020 - Excel CEILING and FLOOR Functions allow you to round values up or down to the nearest value divisible by a specified number. e.g ending in 95 cents.
Top answer 1 of 3
3
This might help:
FLOOR function - Rounds a number down, toward zero
FLOOR.PRECISE function - Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.
=FLOOR(-3,-2) is -2
=FLOOR.PRECISE(-3,2) is -4
2 of 3
1
Using negative significance revert behavior.
From documentation:
If number is positive and significance is negative, FLOOR returns the #NUM! error value.
If the sign of number is positive, a value is rounded down and adjusted toward zero.
If the sign of number is negative, a value is rounded down and adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.
However, testing positive and negative number and significance I get following result:
- Significance > 0:
- Any number: Round down (toward negative infinity)
- Significance < 0:
- Number < 0: Round up (toward positive infinity)
- Number >= 0:
#NUM!
- Significance = 0:
- Number = 0:
0 - Number <> 0:
#DIV!
- Number = 0:
Spreadsheeto
spreadsheeto.com › home › blog › how to use the floor function in excel step-by-step
How to Use the FLOOR Function in Excel Step-by-Step
January 10, 2026 - 1. Select cell. 2. Enter the FLOOR formula. 3. Enter the cell reference with the decimal value. 4. Add the significance argument. Read more.
SimonsezIt
simonsezit.com › article › how-to-use-floor-function-in-excel
How to Use FLOOR Function in Excel? 2 Easy Ways
May 19, 2025 - The FLOOR function is very similar to the ROUNDDOWN function. Whereas, the ROUNDDOWN function rounds down the value to its nearest significant digits, the FLOOR function rounds down the number to its nearest multiple of significance. In previous versions of Excel, the syntax of the FLOOR function was: