CEILING.MATH

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

Returns the number rounded up to the nearest integer or multiple.

number	The number to be rounded up.
multiple	(significance)(Optional) The multiple you want the number rounded to (1).
mode	(Optional) A logical value indicating whether to round negative numbers up or down: False (or 0) = Negative numbers are rounded up towards zero (default) True (<> 0) = Negative numbers are rounded down away from zero

REMARKS

* The "significance" argument has been changed to "multiple".
* Positive decimal numbers are rounded up to the nearest integer.
* Negative decimal numbers are rounded up (when "mode" = False) and rounded down (when "mode" = True).
* This function is identical to the MROUND function, except that is always rounds a number up.
* If "number" is an exact multiple of "multiple", there will be no rounding.
* If "multiple" is left blank, then 1 is used.
* If "multiple" > 0, then "number" is rounded up to an exact multiple of "multiple".
* If "multiple" < 0, then the absolute value is taken.
* If "multiple" = 0, then 0 is returned.
* If "mode" is left blank, then False is used.
* The "mode" argument only affects negative numbers.
* Alternative formula is =INT(-number/multiple)*multiple
* You can use the FLOOR.MATH function to round down to the nearest integer or multiple.
* 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 certain multiple.
* 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 certain number of decimal places or digits.
* You can use the ROUNDDOWN to round down to a certain number of decimal places or digits.
* You can use the ROUNDUP function to round up to a certain number of decimal places or digits.
* You can use the TRUNC function to returns the number with any decimal places removed.
* This function was added in Excel 2013 to replace the CEILING.PRECISE and CEILING functions.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=CEILING.MATH(1.9) = 2
2	=CEILING.MATH(1.1) = 2
3	=CEILING.MATH(1.1, 1) = 2
4	=CEILING.MATH(3.1, 3) = 6
5	=CEILING.MATH(9.1, 9) = 18
6	=CEILING.MATH(15.1, 15) = 30
7	=CEILING.MATH(-1.1) = -1
8	=CEILING.MATH(-1.1, 1) = -1
9	=CEILING.MATH(-1.1, 1, FALSE) = -1
10	=CEILING.MATH(-1.1, 1, TRUE) = -2
11	=CEILING.MATH(-1.1, 3, FALSE) = 0
12	=CEILING.MATH(-1.1, 3, TRUE) = -3
13	=CEILING.MATH(-1.1, 9, TRUE) = -9
14	=CEILING.MATH(-1.1, 15, TRUE) = -15
15	=CEILING.MATH(13, 2) = 14
16	=CEILING.MATH(-13, 2) = -12
17	=CEILING.MATH(8.26, 0.05) = 8.30
18	=CEILING.MATH(0.234, 0.01) = 0.24
19	=CEILING.MATH(NOW(), "0:20") = 6:40:00 AM
20	=CEILING.MATH("") = #VALUE!

1 - What is 1.9 rounded up to a multiple of 1.
2 - What is 1.1 rounded up to a multiple of 1.
3 - What is 1.1 rounded up to a multiple of 1.
4 - What is 3.1 rounded up to a multiple of 3.
5 - What is 9.1 rounded up to a multiple of 9.
6 - What is 15.1 rounded up to a multiple of 15.
7 - What is -1.1 rounded up to a multiple of 1.
8 - What is -1.1 rounded up to a multiple of 1.
9 - What is -1.1 rounded up to a multiple of 1.
10 - What is -1.1 rounded down to a multiple of 1.
11 - What is -1.1 rounded up to a multiple of 3.
12 - What is -1.1 rounded down to a multiple of 3.
13 - What is -1.1 rounded down to a multiple of 9.
14 - What is -1.1 rounded down to a multiple of 15.
15 - What is 13 rounded up to a multiple of 2.
16 - What is -13 rounded up to a multiple of 2.
17 - What is 8.26 rounded up to a multiple of 0.05.
18 - What is 0.234 rounded up to a multiple of 0.01.
19 - What is the current time rounded up to the nearest 20 minutes.
20 - If any of the arguments are not numeric.