FLOOR Excel Formula vs. ROUNDDOWN: Key Differences

In Excel, FLOOR rounds a number down to a chosen multiple, while ROUNDDOWN cuts off digits at a chosen decimal place and always moves toward zero. Use FLOOR for steps such as whole units, 0.25 increments, or pack sizes; use ROUNDDOWN when you need to limit decimal places without rounding up.

What the Two Functions Do

Both functions can make a value smaller, which is why they are easy to confuse. Their arguments describe different things, though. FLOOR takes a significance: the interval to which the result must be a multiple. ROUNDDOWN takes num_digits: the number of decimal places to retain. The best choice depends on whether you are rounding to an interval or truncating decimal digits.

For example, rounding a price down to the nearest quarter is an interval problem. Cutting a measurement to two decimal places is a decimal-place problem. A value can have the same result with both functions in some cases, but that does not make the functions interchangeable.

How FLOOR Works

FLOOR uses the syntax FLOOR(number, significance). The significance sets the size of each step: 1 means whole numbers, 0.5 means half-unit steps, and 10 means multiples of ten. For a positive number, Excel returns the greatest multiple of the significance that is no greater than the number.

Assume A2 contains 18.76. With that cell layout, this formula rounds down to a whole number and returns 18: =FLOOR(A2,1). If the significance is 0.25, the result is 18.75, because 18.75 is the largest quarter-step that does not exceed 18.76. With A2 still containing 18.76, use =FLOOR(A2,0.25).

The significance does not have to be a power of ten. That makes FLOOR useful for tasks such as pricing in quarter-unit increments, grouping quantities into batches, or converting elapsed time into fixed-size blocks. It also means that a significance of 0.25 is not the same instruction as “show two decimal places”: it requests quarter steps, not hundredths.

How ROUNDDOWN Works

ROUNDDOWN uses the syntax ROUNDDOWN(number, num_digits). A num_digits value of 0 keeps the integer portion; a positive value keeps that many places to the right of the decimal point; and a negative value drops places to the left of the decimal point. Unlike a display format, the function changes the value returned by the formula.

Assume A2 contains 18.76. To keep one decimal place without rounding up, enter =ROUNDDOWN(A2,1); the result is 18.7. To keep two decimal places, use =ROUNDDOWN(A2,2), which returns 18.76. If A2 contains 18.76 and you use =ROUNDDOWN(A2,-1), the result is 10, because the function truncates to the tens place.

ROUNDDOWN always moves toward zero. That detail matters for negative values: truncating -18.76 to an integer produces -18, not -19. The word “down” can sound like “toward a smaller number,” but for negative values, moving toward zero actually makes the result numerically greater.

Side-by-Side Examples

These examples use A2 for 18.76 and A3 for -18.76. Each formula is shown with the cell layout it assumes, so you can enter the values and compare the results in Excel.

With 18.76 in A2, =FLOOR(A2,1) returns 18; it goes to a whole-number multiple.
With 18.76 in A2, =ROUNDDOWN(A2,0) also returns 18; it drops the decimal portion.
With 18.76 in A2, =FLOOR(A2,0.1) returns 18.7; the result is a multiple of one tenth.
With 18.76 in A2, =ROUNDDOWN(A2,1) returns 18.7; the result is limited to one decimal place.
With -18.76 in A3, =FLOOR(A3,1) returns -19, the lower whole-number multiple.
With -18.76 in A3, =ROUNDDOWN(A3,0) returns -18, because ROUNDDOWN moves toward zero.

The positive examples show why people sometimes treat the functions as substitutes: FLOOR with a significance of 0.1 and ROUNDDOWN with one decimal place agree for this value. The negative examples expose a key difference. Also, the agreement is conditional: use a significance that corresponds to the desired decimal place, and check how negative values should behave before copying a formula down a column.

Choosing the Right Function

Start by describing the intended result in plain language. If you mean “the nearest lower multiple of this interval,” choose FLOOR. If you mean “keep this many decimal places and discard the rest,” choose ROUNDDOWN. This simple test avoids relying on a formula that only happens to produce the right answer for one sample value.

Choose FLOOR for intervals such as 5 items, 0.25 units, 15 minutes, or 10 currency units.
Choose ROUNDDOWN to truncate a calculation to a fixed number of decimal places.
For negative values, decide whether you want the result farther from zero or closer to zero. FLOOR and ROUNDDOWN can produce different answers.
If the goal is only to change what a cell looks like, use number formatting instead of either formula. Formatting can hide digits without changing the underlying value.

For instance, if a calculation returns 7.899 and the cell is formatted to show two decimal places, it may display as 7.90 while still holding 7.899. ROUNDDOWN with two decimal places would return 7.89. That difference can affect later calculations, so decide whether you need a display change or a changed result.

Negative Values and FLOOR.MATH

Negative numbers are the most common source of surprises. “Down” in FLOOR means toward the next lower multiple, which can take a negative value farther from zero. ROUNDDOWN instead consistently moves toward zero. For example, -18.76 is below -18 but above -19, so flooring it to a whole-number interval gives -19, while truncating to an integer gives -18.

In current Microsoft 365 Excel, FLOOR.MATH is another option when you want more explicit control over negative-number behavior. It accepts a number, an optional significance, and an optional mode. With -18.76 in A3, the formula =FLOOR.MATH(A3,1) returns -19 by default. With the same cell layout, =FLOOR.MATH(A3,1,1) returns -18 because mode 1 directs negative values toward zero. FLOOR.MATH is available in Excel 2013 and later, including Microsoft 365.

Do not assume that a formula intended for positive quantities will behave as desired when a dataset includes returns, adjustments, or negative balances. Test at least one negative example and confirm the intended direction. If your workbooks need to open in older Excel releases, consider whether all target versions support the function you choose.

Common Errors and Misconceptions

A frequent mistake is treating the significance as a number of decimal places. In FLOOR, 0.01 means “use hundredth-size intervals”; in ROUNDDOWN, 2 means “retain two decimal places.” The values happen to align for ordinary decimal-place rounding when the significance is the corresponding power of ten, but the arguments do not mean the same thing.

Another mistake is expecting a formula to control only the cell’s display. Both functions return a changed numeric result. If you only need fewer digits on screen, select the cells and use the number-format controls on the Home tab. The displayed value may be rounded for presentation, while calculations can continue using the stored value.

Check inputs when a formula returns an error. FLOOR needs a meaningful, nonzero significance; a zero significance can produce a division-by-zero error. Non-numeric inputs can also cause errors. A cell that looks numeric may actually contain text, especially if it was imported from another system. Confirm the underlying values and use a significance that makes sense for the data.

Finally, decimal fractions such as 0.1 and 0.25 are represented internally in binary floating-point arithmetic. A calculated value that appears to be exactly on a boundary can sometimes be stored just below or above it. If a boundary result looks unexpected, inspect the underlying precision and consider whether the source calculation needs a suitable rounding step. Do not add extra rounding automatically, however; it can change results further downstream.

Frequently Asked Questions

Is FLOOR the same as ROUNDDOWN in Excel?
No. FLOOR rounds to a multiple of a significance, while ROUNDDOWN truncates to a specified number of digits toward zero. They can match for certain positive numbers when the significance corresponds to the requested decimal place.

How do I round down to two decimal places?
Use ROUNDDOWN with num_digits set to 2. If you instead need the value to be a multiple of 0.01, FLOOR with a significance of 0.01 expresses that interval-based requirement.

Why does FLOOR give a different answer for a negative number?
FLOOR moves to a lower multiple, which can mean farther from zero. ROUNDDOWN moves toward zero. For -18.76 at whole-number precision, those directions produce -19 and -18 respectively.

Does ROUNDDOWN change the value or just the display?
It returns a truncated numeric value, so later calculations use that result. Number formatting changes the displayed appearance without necessarily changing the stored value.

What is the difference between FLOOR and FLOOR.MATH?
Both round down to multiples, but FLOOR.MATH provides an optional mode for controlling how negative numbers are rounded. Use it when that behavior needs to be explicit, and check compatibility if a workbook will be opened in older Excel versions.

Bottom Line

Choose FLOOR when the result must land on a defined step or multiple; choose ROUNDDOWN when you need to truncate decimal places toward zero. If negative values are possible, pay particular attention to direction. Matching the function to the actual rule—not just to one example—makes formulas easier to audit and safer to reuse.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.