Microsoft Office Tutorials and References
In Depth Information
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