CEILING.MATH(number [,significance] [,mode])

Returns the number rounded up to the nearest integer or significant figure (including negative).

numberThe number to be rounded up.
significance(Optional) The multiple you want the number rounded to.
mode(Optional) Whether to round negative numbers up or down:
False (default) = Negative numbers are rounded up towards zero.
True = Negative numbers are rounded down away from zero.

Remarks

* Added in Excel 2013.
* This function replaces the CEILING.PRECISE function.
* This function replaces the CEILING function.
* If "significance" is left blank, then 1 is used.
* If "mode" is left blank, then False is used.
* If "number" < 0 and "significance" < 0, this function rounds down.
* If "number" < 0 and "significance" > 0, this function rounds up towards zero.
* If "number" is an exact multiple of "significance", there will be no rounding.
* The "mode" argument only affects negative numbers.
* The "mode" argument can also take numerical values. 0 is equivalent to False. Any other number is equivalent to True.
* Alternative formula is =INT(-number/significance)*significance
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the MROUND function to round to a desired multiple of.
* You can use the ROUND function to round to a specified number of digits.
* You can use the TRUNC function to returns the number with any decimal places removed.
* For the Microsoft documentation refer to support.office.com

 A
1=CEILING.MATH(1.1,1) = 2
2=CEILING.MATH(1.5,1) = 2
3=CEILING.MATH(1.9,1) = 2
4=CEILING.MATH(-1.1,-1) = -1
5=CEILING.MATH(-1.5,-1) = -1
6=CEILING.MATH(-1.9,-1) = -1
7=CEILING.MATH(2.5,2) = 4
8=CEILING.MATH(-2.5,-2) = -2
9=CEILING.MATH(8,1.5) = 9
10=CEILING.MATH(8.26,0.05) = 8.3
11=CEILING.MATH(0.234,0.01) = 0.24
12=CEILING.MATH(4.2,1) = 5
13=CEILING.MATH(4.2,-1) = 5
14=CEILING.MATH(4.2,2) = 6
15=CEILING.MATH(4.2,-2) = 6
16=CEILING.MATH(-4.2,1) = -4
17=CEILING.MATH(-4.2,-1) = -4
18=CEILING.MATH(-4.2,2) = -4
19=CEILING.MATH(-4.2,-2) = -4
20=CEILING.MATH(4,-2) = 4
21=CEILING.MATH(-2.5,2) = -2
22=CEILING.MATH(-4.2,1,TRUE) = -5
23=CEILING.MATH(-4.2,-1,TRUE) = -5
24=CEILING.MATH(-4.2,2,TRUE) = -6
25=CEILING.MATH(-4.2,-2,TRUE) = -6


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