It returns a number rounded up, away from zero, to the nearest multiple of significance .
The syntax of the function is the following:
CEILING(number, significance)
number: The number we need to round up.
significance: the multiple of significance we wish to round up to.
if number is negative and significance negative the value is rounded down away from zero.
if numbers is negative and significance positive the value is rounded up towards zero.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the CEILING function:
In the third row, round up the numbers of the respective cells of the first row, using the instructions found in the second row.