FLOOR:
Rounds a number down, toward zero, to the nearest multiple of significance
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)
Using the FLOOR function:
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. 
• 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. 
The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance.