The CEILING function rounds a given number up to the nearest specified multiple. CEILING works like the ROUND function, but CEILING always rounds up.
Purpose of Excel CEILING Function
When preparing financial models, CEILING helps us round up the numbers as per the requirement
Returns number rounded up, away from zero, to the nearest multiple of significance.
=CEILING (number, multiple)
|number||The number that should be rounded.||Mandatory|
|multiple||The multiple to use when rounding.||Mandatory|
- If either argument is non-numeric, CEILING returns the #VALUE! error value.
- Regardless of the sign of the number, a value is rounded up when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.
- If the number is negative, and the significance is negative, the value is rounded down, away from zero.
- If the number is negative, and the significance is positive, the value is rounded up towards zero.
Since 2007 for Windows.
Since 2011 for Mac.