Rounding Numbers with the CEILING Function

The CEILING function in Excel is similar to the ROUNDUP Function in that they both round the last digit upwards.

How they differ is that while the ROUNDUP function only ever rounds that last digit up by one number, the CEILING function can round up by multiples of the last digit.

Rounding by multiples allows you to set the level of significance for the remaining digits.

To find out all the details on using this function, read this short tutorial on Excel's CEILING Function.

• Excel ROUND Function
• Excel ROUNDDOWN Function
• Excel TRUNC Function