ROUNDUP

ROUNDUP(number, num_digits)

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

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 decimal numbers are rounded up (away from zero).
* Negative decimal numbers are rounded down (away from zero).
* If "number" is not numeric, then #VALUE! is returned.
* 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 or digits.
* You can use the ROUNDDOWN function to round towards zero to a certain number of decimal places or digits.
* 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 a certain multiple.
* You can use the FLOOR.MATH function to round down by default to a certain multiple.
* You can use the INT function to round down to the nearest integer.
* You can use the EVEN function to round up to the nearest even integer.
* You can use the ODD function to round up to the nearest odd integer.
* For the Microsoft documentation refer to support.microsoft.com

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

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