Microsoft Office Tutorials and References
In Depth Information
Figure 11.12. For negative numbers,
For negative numbers, ISO.CEILING
ISO.CEILING rounds toward zero.
rounds toward zero.
The FLOOR function rounds a number to the next lowest multiple. Suppose
that you employ several student workers who do piecework. They assemble
products and then pack them six to a case. Your contract with the workers
states that you pay only for complete cases. Column B in Figure 11.13
shows the total number of units assembled. You use =FLOOR(B6,6) to round
this quantity down to the nearest multiple of six. Note that if the value is
already a multiple of six, as in cell B10, FLOOR does not change the number.