CEILING Function in Excel

The CEILING function in Excel rounds a supplied number away from zero, to the nearest multiple of a given number. CEILING Function takes up two arguments the Number to be rounded off and significance to which the level of rounding has to be done.

Syntax of CEILING Function in Excel

CEILING( number, significance )

number – The Number to be rounded

significance– Multiple of Significance to which the number has to be rounded to

 

Example of CEILING Function in Excel

Formula

CEILING Function in Excel 1

When Significance value is negative and Number is Positive it results in #NUM! error so the result will be

Result

CEILING Function in Excel 2

Note: #VALUE! Error occurs if the supplied arguments are non-numeric.

#DIV/0! Error occurs if the significance argument is Zero

#NUM! Error occurs when Number is Positive and significance value is negative

 previous CEILING Function in Excel                                                                                                               next CEILING Function in Excel