1. Computing
Ted French

Rounding Numbers with the CEILING Function

By October 28, 2013

Follow me on:

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.

More Rounding Number Functions
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.