The original round-up-to-a-multiple function, kept for compatibility. It rounds away from zero and requires the number and significance to share a sign. New work should use CEILING.MATH.

Syntax

=CEILING(number, significance)

• Price to nickels

  =CEILING(4.42,0.05) → 4.45

  Price up to the next 5 cents.

• Multiple of five

  =CEILING(23,5) → 25

  Up to a multiple of 5.

• Negative pair

  =CEILING(-2.5,-2) → -4

  Both negative: away from zero.

• Errors when number and significance have different signs. CEILING.MATH does not.
• CEILING.MATH does the same without the sign restriction and with a mode switch.
• Still fine for positive numbers, which is nearly every price and quantity.
• Significance of 1 rounds up to a whole number.

• #NUM! when the number is positive and significance negative.
• Behavior for a negative number with positive significance changed between Excel versions (2010 rounds toward zero); do not rely on it.