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. In this guide, we’re going to show you how to use the FLOOR function and also go over some tips and error handling methods.
Supported versions
Excel FLOOR Function Syntax
Arguments
|
number |
The number you want to round down. |
|
significance |
The multiple to which you want to round the number. |
Examples
Positive numbers
If the number argument is positive, the value is rounded down towards zero (0). In this case, the significance should also be a positive number.
Negative numbers
If the number argument is negative, the rounding direction is going to be determined by whether the significance argument is positive. If the significant value is positive, the function rounds the number down, away from zero (0). Otherwise, the rounding will be towards zero.
=FLOOR(-23.254,-0.04) returns -23.24
Summary and Tips
- Microsoft has released the MATH function to replace FLOOR. The support for FLOOR function continues for the sake of backwards compatibility.
- The CEILING function acts as the opposite of this function. However, we recommend using the MATH function to round numbers up to the nearest multiple.
- If you need to round to the nearest multiple, use MROUND.
- Use an integer as significance to round a number down to an integer.
Issues
- The function returns #NUM! error if number is positive, but significance is negative.
