In Excel, the FLOOR function is a mathematical function that rounds numbers down towards zero, to the nearest specified multiple. The syntax for the FLOOR function is as follows:
FLOOR(number, significance)
number: The numeric value you want to round down.
significance: The multiple to which you want to round down the number.
The FLOOR function rounds the given number down to the nearest multiple of the specified significance. It is particularly useful when you want to ensure that a number is rounded down to a specific interval or granularity.
Here's an example:
=FLOOR(12.75, 5)
In this example, the FLOOR function rounds down the number 12.75 to the nearest multiple of 5, which is 10. So, the result of the formula is 10.
Put Comment for quarry