How to Use CEILING Function

The CEILING function returns the number rounded up, away from zero, to the nearest multiple of significance.

Formula:

=CEILING(number, significance)

Explanations:

– The number is required, which is the number that you want to round.

– The significance is required, which is the multiple to which you want to round.

Cautions:

– When the number and significance are both negative, the value is rounded down, away from zero;

– When the number is negative, and significance is positive, the value is rounded up towards zero;

– When the number is positive, and significance is negative, the value returns to #NUM!.

Download: CEILING Function

Leave a Reply