It returns a number rounded down, toward zero, to the nearest multiple of significance .
The syntax of the function is the following:
FLOOR(number, significance)
number: The number we need to round down.
significance: the multiple of significance we wish to round down to.
if number is negative and significance positive the value is rounded down away from zero.
if numbers is negative and significance negative the value is rounded up towards zero.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the FLOOR function:
In the third row, round down the numbers of the respective cells of the first row, using the instructions found in the second row.