FLOOR Function
Rounds a number down to the nearest multiple of significance.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| number | The value you want to round. | Required |
| significance | The multiple to which you want to round. In classic FLOOR, number and significance should share the same sign. | Required |
Basic Example
Round 3.7 down to the nearest integer
=FLOOR(3.7, 1)3 is the largest multiple of 1 that is less than or equal to 3.7.
Advanced Examples
Example 1: Negative numbers round away from zero
Rounding -3.7.FLOOR rounds toward negative infinity, so negatives move away from zero.
=FLOOR(-3.7, 1)Example 2: Round to two decimal places
Trim a value to the nearest 0.01.Pass significance 0.01.
=FLOOR(123.456, 0.01)How FLOOR Works
FLOOR finds the greatest multiple of significance that is less than or equal to number (rounding toward negative infinity). In the classic version, if number is positive and significance is negative, Excel returns #NUM!; FLOOR.MATH lifts that restriction.
Important Notes & Limitations
If number is positive and significance is negative, classic FLOOR returns #NUM! (FLOOR.MATH does not).
FLOOR rounds toward negative infinity, so negative numbers move away from zero.
A significance of 0 returns 0.
Common Errors & Fixes
#NUM!Number is positive while significance is negative (classic FLOOR).Fix: Match the signs, or switch to FLOOR.MATH.
#VALUE!Non-numeric argument.Fix: Use numeric values or numeric references.
Download Practice File
FLOOR
floorPractice FLOOR with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the FLOOR function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps