Excel CEILING.MATH function

Function              CEILING.MATH

Description        Excel CEILING.MATH function returns a provided number rounded up to a specified multiple. Provides control when rounding direction for negative numbers.

Syntax  CEILING.MATH(number, [significance], [mode])

number  The number that should be rounded.

significance [optional] Multiple to use when rounding. Default is 1.

mode  [optional] For rounding negative numbers toward or away from zero. Default is 0.

Example:

=CEILING.MATH(-233.4,5,4)= 235

=CEILING.MATH(67,5)= 70

=CEILING.MATH(-67.6,5,1)= -70

=CEILING.MATH(-67.6,5)= -65

Usage Notes:

• By default, significance is +1 for positive numbers and -1 for negative numbers.
• By default, positive numbers with fraction value are rounded up to the nearest higher integer. For example, 5.5 is rounded up to 6.
• By default, negative numbers with fraction value are rounded up to the nearest lower integer. For example, -5.5 is rounded up to -5.
• With the help of Significance and Mode, you can change the direction of the rounding for negative numbers. For example, rounding -5.5 to a significance of 1 with a mode of 1 rounds away from 0, to -6.
• The Mode has no effect on positive numbers.