FLOOR, CEILING, ODD, and EVEN

Read this FLOOR, CEILING, ODD, and EVEN example

Start with the business need: Round an order quantity up to a complete carton. Read each argument, reference, field, or control in the example before copying it into a larger model.

=CEILING.MATH(B2,5)

The FLOOR, CEILING, ODD, and EVEN mistake to catch

Operational rounding can change cost or capacity. Document the significance and direction, especially for negative numbers.

FLOOR, CEILING, ODD, and EVEN: what Excel is actually doing

FLOOR rounds toward a lower multiple, CEILING toward a higher multiple, and ODD/EVEN move to the next integer of the specified parity away from zero.

Your desk challenge for lesson 58

Round demand up to full case sizes and compare that decision with normal decimal rounding.

• Identify whether the question concerns centre, spread, rank, or rounding.
• Exclude invalid records explicitly.
• Compare the result with a chart or a second summary measure.