Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

Figure 11.12.

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.