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 #NUM!
error.
Example. For a price campaign, assume that you want to round all prices to 25 cents. Figure 16-15 shows a possible solution using the FLOOR() function.
CEILING(), CEILING.PRECISE(), EVEN(), FLOOR.PRECISE(), INT(), ODD(), ROUND(), ROUNDDOWN(), ROUNDUP(), TRUNC()
Sample Files
Use the FLOOR and ROUND worksheets in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.129.210.91