FLOOR
The FLOOR function rounds a number down to the nearest specified multiple of significance. It is useful for truncating numbers to specific intervals or multiples. This function helps in calculations or formatting.
Syntax 🔗
=FLOOR(number, significance)
number | The number you want to round down to the nearest multiple of the significance. |
significance | The multiple to which you want to round down the number. |
About FLOOR 🔗
The FLOOR function in Excel helps you round numbers down to the nearest multiple of a specified value. Use it when you need your calculations to align with specific intervals, which can be useful for financial data, measurements, or any scenario where precise rounding is required.
Examples 🔗
Suppose you have a number 247 and you want to round it down to the nearest multiple of 10. You can use the FLOOR formula as follows: =FLOOR(247, 10). This will return 240, as it rounds 247 down to the nearest multiple of 10.
Consider you have a number 68.75 and you wish to round it down to the nearest multiple of 5. By utilizing the FLOOR function like so: =FLOOR(68.75, 5), you will receive the result 65, truncating the number to the closest multiple of 5.
Notes 🔗
Ensure that the significance value you provide is not zero, as this will result in a #DIV/0! error. The FLOOR function only rounds numbers down. If you need to round numbers to the nearest multiple in either direction, consider using the MROUND function.
Questions 🔗
The FLOOR function specifically rounds numbers down to the nearest specified multiple, while the ROUND function rounds numbers to the nearest whole number or specified decimal point. FLOOR truncates numbers towards negative infinity, whereas ROUND follows standard rounding rules.
Can the FLOOR function handle negative numbers?Yes, the FLOOR function can work with negative numbers. It will round the negative number towards negative infinity, maintaining the same behavior of rounding down to the nearest multiple as with positive numbers.
What happens if I provide a significance value of zero to the FLOOR function?If you input a significance value of zero in the FLOOR function, it will result in a #DIV/0! error. Make sure to use a non-zero value for the significance to avoid this error.