FLOOR()
Syntax. FLOOR(number,significance)
Definition. This function rounds a number down to the nearest multiple of significance.
Arguments
number (required) The numeric value you want to round
significance (required) The multiple to which you want to round
Background. The sign of number is taken into consideration when a value is rounded; that is, for a number with a positive sign the value is rounded down, and for a number with a negative sign the value is rounded up. If number is an exact multiple of significance, no rounding occurs.
The FLOOR() function uses numeric values. If one of the arguments isn’t a numeric expression, the FLOOR() function returns the #VALUE!
error. If number and significance have different signs, the function returns the ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.