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!.