floating point calculations in Excel can sometimes produce incorrect results.
I would say "unexpected" results, not "incorrect". In fact, they are precisely correct.
The point is: most decimal fractions cannot be represented exactly in binary "floating-point", which is what Excel uses internally to represent numeric values and perform arithmetic.
And the binary approximation of some decimal fractions might vary depending on the magnitude of the number. That is why, for example, 10.01 - 10 = 0.01 returns FALSE(!). (Hint: Format the result of 10.01 - 10 to display 17 decimal places.)
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.
Microsoft Support
support.microsoft.com › en-us › office › floor-math-function-c302b599-fbdb-4177-ba19-2c2b1249a2f5
FLOOR.MATH function - Microsoft Support
The FLOOR.MATH function syntax has the following arguments. Number Required. The number to be rounded down. Significance Optional. The multiple to which you want to round. Mode Optional. The direction (toward or away from 0) to round negative numbers. By default, positive numbers with decimal portions are rounded down to the nearest integer.
Excel FLOOR() function
Microsoft 365 and Office | Excel | For home | Windows · A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data. ... Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. ... I would say "unexpected" results, not "incorrect... More on learn.microsoft.com
6
0
May 4, 2022Floor 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, 2023Shared Excel spreadsheet- Floor Formula not correctly rounding down
This: =FLOOR(F2, 15/24/60) Or, =FLOOR(F2, TIME(, 15, )) More on reddit.com
10
15
July 30, 2025Videos
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 ...
02:04
CEILING and FLOOR Excel Functions (with examples) - YouTube
03:35
CEILING, FLOOR, ROUND Functions in Microsoft Excel - YouTube
01:30
FLOOR Function | Quick Excel Tips - YouTube
Exceljet
exceljet.net › floor function
Excel FLOOR function | Exceljet
September 13, 2021 - The Excel FLOOR function rounds a number down to a given multiple. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned.
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. Perfect for pricing, scheduling, and more. ... Get your team access to the full DataCamp for business platform. If you're someone who spends time managing budgets or if you work with prices in some other way, you'll find Excel's FLOOR() ...
Formula Bot
formulabot.com › excel › floor-function
FLOOR Excel Formula - Function, Examples, How to Use
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.
LiveFlow
liveflow.com › product-guides › floor-math-function-in-excel-explained
FLOOR.MATH Function in Excel: Explained
In this article, you will learn how to use the FLOOR.MATH formula in Excel. ... The FLOOR.MATH function in Excel is used to round a number down to the nearest specified multiple. It is an updated version of the FLOOR function, introduced in ...
TutorialsPoint
tutorialspoint.com › advanced_excel_functions › advanced_excel_compatibility_floor_function.htm
Excel - FLOOR Function
The Excel FLOOR function rounds numeric values downwards, near zero, close to the multiple defined in the second parameter, Significance. Researchers and business analysts generally use the FLOOR and CEILING functions to ensure consistency and ...
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 - The Excel FLOOR function performs rounding based on the following rules: If the number and significance arguments are positive, the number is rounded down, toward zero, as in rows 2 and 10 in the screenshot below.
Oreate AI
oreateai.com › blog › understanding-the-floor-function-in-excel-a-practical-guide › 79ae0f49b05286627f1f260ed86908cd
Understanding the FLOOR Function in Excel: A Practical Guide - Oreate AI Blog
January 15, 2026 - At its core, the syntax of the FLOOR function is straightforward: FLOOR(number, significance). Here’s what each part means: Number: This is the value you want to round down. It could be anything from 3.7 to -2.5. Significance: This represents ...
Top answer 1 of 5
1
floating point calculations in Excel can sometimes produce incorrect results.
I would say "unexpected" results, not "incorrect". In fact, they are precisely correct.
The point is: most decimal fractions cannot be represented exactly in binary "floating-point", which is what Excel uses internally to represent numeric values and perform arithmetic.
And the binary approximation of some decimal fractions might vary depending on the magnitude of the number. That is why, for example, 10.01 - 10 = 0.01 returns FALSE(!). (Hint: Format the result of 10.01 - 10 to display 17 decimal places.)
2 of 5
0
This is what I get:
But floating point calculations in Excel can sometimes produce incorrect results. Joeu2004 will explain (I hope).
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
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.
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 - In essence, FLOOR assists in turning fluid time into quantifiable, manageable intervals, dramatically simplifying planning, and reducing administrative overhead. Whether it’s about ensuring resource availability or aligning with payroll cut-offs, ...
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.
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 - It throws #DIV/0! Error when the significant value is 0 because the function iterates the value by dividing the multiple until it gets the lowest value which is 0. Divisibility by 0 means error. The Excel FLOOR function also throws an error when either of the arguments is not numeric. In the previous version of Excel (2003 and 2007), the number and the significant values must have the same sign.
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:
Indeed
indeed.com › career guide › career development › how to use excel floor function in 7 steps (with examples)
How To Use Excel Floor Function in 7 Steps (With Examples) | Indeed.com
June 6, 2025 - The Excel FLOOR function is a math formula that rounds a specific number down to the nearest specified multiple. The number is the value that you want to round down. The significance is the multiple to which you want to round the number.
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 ...