English Español Deutsch 日本語 Français Português Русский Italiano Nederlands Polski

Quick Navigation

FLOOR Function

Excel 2007+, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365

Summary

The FLOOR function rounds a number down to the nearest multiple of a specified significance value. It always rounds toward negative infinity, making it ideal for precise downward rounding in financial calculations, pricing, and data analysis.

Syntax

FLOOR(number, significance)

Parameters

Parameter Type Required Description
number Number Yes Numeric value you want to round down to nearest multiple
significance Number Yes Multiple to which the number is rounded (must match sign with number for positive values)

Using the FLOOR Function

FLOOR is perfect for applications requiring consistent downward rounding, such as pricing products to end in .99, calculating time intervals, or standardizing measurements. Unlike standard ROUND which rounds to nearest, FLOOR always rounds down.

Common FLOOR Examples

Basic Downward Rounding

=FLOOR(3.7,2)

Rounds 3.7 down to nearest multiple of 2, result: 2

Negative Number Rounding

=FLOOR(-2.5,-2)

Rounds -2.5 down to nearest multiple of -2, result: -2

Decimal Precision Rounding

=FLOOR(1.58,0.1)

Rounds 1.58 down to nearest multiple of 0.1, result: 1.5

Pricing to Cents

=FLOOR(12.347,0.01)

Rounds price down to nearest cent, result: 12.34

Frequently Asked Questions

#NUM! error occurs if positive number paired with negative significance

Using 0 as significance will return #NUM! error

Negative numbers round down (more negative), away from zero

Common Errors and Solutions

#VALUE!

Cause: Either argument is non-numeric

Solution: Ensure both number and significance contain valid numbers

#NUM!

Cause: Positive number with negative significance

Solution: Use matching signs for positive numbers

#NUM!

Cause: Significance is zero

Solution: Provide non-zero significance value

Notes

  • Rounds toward negative infinity (always down)
  • For Excel 2013+, consider FLOOR.MATH for away-from-zero rounding
  • Use with INT for integer-only results
  • Perfect for currency rounding to avoid overcharging

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365