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
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
When Significance value is negative and Number is Positive it results in #NUM! error so the result will be
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