CEILING.MATH

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) A logical value indicating whether to round negative numbers up or down:
True = Negative numbers are rounded down away from zero
False = Negative numbers are rounded up towards zero (default)

REMARKS
* Added in Excel 2013.
* This function replaces the CEILING.PRECISE function.
* This function replaces the CEILING function.
* Positive decimal numbers are rounded up to the nearest integer.
* Negative decimal numbers are rounded up to the nearest integer.
* If "number" is an exact multiple of "significance", there will be no rounding.
* If "number" is divided by a significance of 2 or greater, results in a remainder, the result is rounded down.
* The "significance" argument will determine how the "number" is rounded up.
* If "significance" is left blank, then 1 is used.
* If "significance" > 0, then "number" is rounded up to an exact multiple of "significance".
* If "significance" < 0, then the absolute value is taken.
* If "mode" is left blank, then False is used.
* 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 NOW function to return the serial number of the current system date and time.
* You can use the ROUND function to round to a specified number of digits.
* You can use the ROUNDUP function if you always want the number rounded up to the nearest integer.
* You can use the TRUNC function to returns the number with any decimal places removed.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=CEILING.MATH(3.1,1) = 4
2=CEILING.MATH(3.5,1) = 4
3=CEILING.MATH(3.9,1) = 4
4=CEILING.MATH(3.2,1) = 4
5=CEILING.MATH(3.2,1,FALSE) = 4
6=CEILING.MATH(3.2,1,TRUE) = 4
7=CEILING.MATH(-3.1,-1) = -3
8=CEILING.MATH(-3.5,-1) = -3
9=CEILING.MATH(-3.9,-1) = -3
10=CEILING.MATH(-3.2,1) = -3
11=CEILING.MATH(-3.2,1,FALSE) = -3
12=CEILING.MATH(-3.2,1,TRUE) = -4
13=CEILING.MATH(2.123,2) = 4
14=CEILING.MATH(-2.123,-2) = -2
15=CEILING.MATH(8.26,0.05) = 8.3
16=CEILING.MATH(0.234,0.01) = 0.24
17=CEILING.MATH(NOW(),"0:20") = 5:00:00 PM

1 - What is 3.1 rounded up to the nearest integer.
2 - What is 3.5 rounded up to the nearest integer.
3 - What is 3.9 rounded up to the nearest integer.
4 - What is 3.2 rounded up to the nearest integer.
5 - What is 3.2 rounded up to the nearest integer. The mode only affects negative numbers.
6 - What is 3.2 rounded up to the nearest integer. The mode only affects negative numbers.
7 - What is -3.1 rounded up to the nearest integer.
8 - What is -3.5 rounded up to the nearest integer.
9 - What is -3.9 rounded up to the nearest integer.
10 - What is -3.2 rounded up to the nearest integer.
11 - What is -3.2 rounded up to the nearest integer.
12 - What is -3.2 rounded up to the nearest integer. The mode affects negative number.
13 - What is 2.123 rounded up to the nearest multiple of 2.
13 - What is -2.123 rounded up to the nearest multiple of 2.
15 - What is 8.26 rounded up to the nearest multiple of 0.05
16 - What is 0.234 rounded up to the nearest multiple of 0.01.
17 - What is the current time rounded up to the nearest 20 minutes.

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