Nearest Multiple Smaller Than or Equal To X (FLOOR)
Syntax: FLOOR(Number; Significance; Mode)
The FLOOR function rounds the given number down to the nearest multiple of significance. It is similar to CEILING, but instead of “padding” the given numbers, it will “shave a little off their top.” For example, in the section on the CEILING functions you read about looking for the number of boxes needed to pack 18 USB drives given the total number of those drives and the fact that the boxes are sold in dozens. As you recall, one box will have less than 18 drives in it. You can use the FLOOR function to find out how many boxes you would need to buy if you wanted to have exactly 18 drives in each and keep the remainder unboxed. Here's the formula you ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting 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.
