CEILING
Rounds the number up, to the nearest integer or to the nearest multiple of significance. For example, if you wish to use cents in your transactions, and the price of an item is 9$ 36 cents, use the =CEILING(936; 10) to round the prices to the next dime.
Syntax
CEILING(number,significance)
Number is the value you wish to round.
Significance is the multiple based on which you wish the rounding to be performed. Comment
If one of the entries is not numeral, the CEILING function returns the error value #VALUE!.
Regardless of the number’s sign, a value is rounded up when it is adjusted away from zero. If the number is an exact multiple of the Significance entry, then the value is not rounded.
If the entries Number and Significance have different signs, the CEILING function returns the error value #NUM!.