The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance.

FLOOR takes 2 required arguments and no optional arguments:

Syntax: FLOOR(number, significance)

#1)
Using the FLOOR function:
#2)
The arguments for the FLOOR function are:
Argument Required? Description
number Required The value you want to round.
significance Required The multiple to which you want to round.
#3)
A few more things:
If either argument is nonnumeric, FLOOR returns the #VALUE! error value.
If number is positive and significance is negative, FLOOR returns the #NUM! error value.
If the sign of number is positive, a value is rounded down and adjusted toward zero. If the sign of number is negative, a value is rounded down and adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.

Summary

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance.
comments powered by Disqus