FLOOR

The FLOOR function returns a number rounded down to the nearest multiple of significance. It is commonly used in scenarios where you need to truncate numbers to specific intervals or multiples for calculations or formatting purposes.

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

When you find yourself in a situation where precision matters, and you need to adjust numbers to fit a particular criteria or scale, look no further than the FLOOR function in Excel. It's a handy tool for ensuring that your calculations align with specific intervals or multiples, providing a structured approach to number manipulation within your spreadsheets. Whether you're dealing with financial data, measurements, or any scenario that requires tailored rounding, FLOOR stands as a reliable option to simplify your workflow.

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.

Questions

How does the FLOOR function differ from the ROUND function in Excel?

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.

Related functions

CEILING
MROUND
ROUND
TRUNC