Microsoft Office Tutorials and References

In Depth Information

**Syntax:**

Figure 11.13.

Figure 11.13.
FLOOR

FLOOR rounds a number down to the next multiple.

rounds a number down to the next multiple.

Similar to the problems with CEILING, the scientific community does not agree

that FLOOR should round toward zero for negative numbers. In cell B14 of

–
3. You can use FLOOR.MATH to match the ISO standard. As shown in B15,

the FLOOR.MATH of
–
2.5 is
–
3.

All the functions for rounding can be replaced with a clever combination

of INT and ROUND functions. If you receive a spreadsheet from an old-time

Lotus 1-2-3 user, you might see formulas like the ones in
Figure 11.14
:

•
Cell B13 is equivalent to using MROUND with a multiple of 20. The

formula divides 135 by 20, giving 6.75. ROUND rounds this to 7. Fin-

ally, outside the parentheses, the formula multiplies by 20 to arrive

at the answer of 140.

•
Cell C13 is equivalent to using FLOOR with a significance of 20. The

formula divides 135 by 20, giving 6.75. The INT removes the decimal