ROUNDUP

ROUNDUP(number, num_digits)

Returns the number rounded away from zero to a certain number of decimal places.

number	The number you want to round (away from zero).
num_digits	The number of decimal places or digits: (= 0) no decimal places (> 0) the number of decimal places (< 0) the number of digits to the left of the decimal point

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive numbers are rounded up (away from zero).
* Negative numbers are rounded down (away from zero).
* If "number" is not numeric, then #VALUE! is returned.
* If "num_digits" = 2, the number will be rounded to the nearest 0.01.
* If "num_digits" = 1, the number will be rounded to the nearest 0.1.
* If "num_digits" = 0, the number will be rounded to the nearest integer.
* If "num_digits" = -1, the number will be rounded to the nearest 10.
* If "num_digits" = -2, the number will be rounded to the nearest 100.
* If "num_digits" is not numeric, then #VALUE! is returned.
* You can use the ROUND function to round to a certain number of decimal places.
* You can use the ROUNDDOWN function to round towards zero to a certain number of decimal places.
* You can use the MROUND function to round to a certain multiple.
* You can use the CEILING.MATH function to round up (by default) to the nearest integer or multiple.
* You can use the FLOOR.MATH function to round down (by default) 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 EVEN function to return the number rounded to the nearest even integer.
* You can use the ODD function to return the number rounded to the nearest odd integer.
* You can use the TRUNC function to round towards zero and truncated to a certain number of decimal places or digits.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ROUNDUP(12.344, 2) = 12.35
2	=ROUNDUP(12.345, 2) = 12.35
3	=ROUNDUP(12.345, 1) = 12.4
4	=ROUNDUP(12.345, 0) = 13
5	=ROUNDUP(0.9, 0) = 1
6	=ROUNDUP(1.1, 0) = 2
7	=ROUNDUP(1.5, 0) = 2
8	=ROUNDUP(-1.5, 0) = -2
9	=ROUNDUP(1234, 3) = 1234
10	=ROUNDUP(1234, -1) = 1240
11	=ROUNDUP(1234, -3) = 2000
12	=ROUNDUP(1234.567, 1) = 1234.6
13	=ROUNDUP(1234.567, -1) = 1240
14	=ROUNDUP(1234, -9) = 1000000000
15	=ROUNDUP("", 0) = #VALUE!
16	=ROUNDUP(1.1, "") = #VALUE!

1 - What is 12.344 rounded up to 2 decimal places.
2 - What is 12.345 rounded up to 2 decimal places.
3 - What is 12.345 rounded up to 1 decimal place.
4 - What is 12.345 rounded up to 0 decimal places.
5 - What is 0.9 rounded up to 0 decimal places.
6 - What is 1.1 rounded up to 0 decimal places.
7 - What is 1.5 rounded up to 0 decimal places.
8 - What is -1.5 rounded down to 0 decimal places.
9 - What is 1234 rounded up to 3 decimal places.
10 - What is 1234 rounded up to -1 digits.
11 - What is 1234 rounded up to -3 digits.
12 - What is 1234.567 rounded up to 1 decimal place.
13 - What is 1234.567 rounded up to -1 digits.
14 - What is 1234 rounded up to -9 digits. There are only 4 digits on the left of the decimal place.
15 - When number is not numeric.
16 - When num_digits is not numeric.