CEILING(number, significance)

Returns the number rounded up to the nearest integer or significant figure.

numberThe number to be rounded up.
significanceThe multiple you want the number rounded to.

Remarks

* CEILING.MATH was added in Excel 2013 to replace this function.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If "significance" < 0, then the absolute value is taken.
* If "significance" = 0, then 0 is returned.
* If "number"is positive and "significance" is negative, then #NUM! is returned.
* If "number" is negative and "significance" is positive then the direction of the rounding is reversed. Examples 17 and 19.
* Positive decimal numbers are rounded up to the nearest integer.
* Negative decimal numbers are rounded up to the nearest integer (away from zero). Example 5.
* For the Microsoft documentation refer to support.office.com

 A
1=CEILING(1.1,1) = 2
2=CEILING(1.5,1) = 2
3=CEILING(1.9,1) = 2
4=CEILING(-1.1,-1) = -2
5=CEILING(-1.5,-1) = -2
6=CEILING(-1.9,-1) = -2
7=CEILING(2.5,2) = 4
8=CEILING(-2.5,-2) = -4
9=CEILING(8,1.5) = 9
10=CEILING(8.26,0.05) = 8.3
11=CEILING(0.234,0.01) = 0.24
12=CEILING(4.2,1) = 5
13=CEILING(4.2,-1) = #NUM!
14=CEILING(4.2,2) = 6
15=CEILING(4.2,-2) = #NUM!
16=CEILING(-4.2,1) = -4
17=CEILING(-4.2,-1) = -5
18=CEILING(-4.2,2) = -4
19=CEILING(-4.2,-2) = -6
20=CEILING(4,-2) = #NUM!
21=CEILING(-2.5,2) = -2

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top