ROUNDUP

ROUNDUP(number, num_digits)

Returns the number rounded up to a certain number of decimal places or digits.

number	The number you want to round up (away from zero).
num_digits	The number of decimal places you want to round the number to.

REMARKS

* Positive decimal numbers are rounded up to the nearest integer.
* Negative decimal numbers are rounded up to the nearest integer.
* This function is identical to the ROUND function, except that it always rounds a number up.
* If "number" is not numeric, then #VALUE! is returned.
* If "num_digits" > 0, then "number" is rounded up to the specified number of decimal places.
* If "num_digits" = 0, then "number" is rounded up to the nearest integer.
* If "num_digits" < 0, then "number" is rounded up to the left of the decimal point.
* 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 down to a certain number of decimal places or digits.
* You can use the FLOOR.MATH function to round down to the nearest integer or multiple.
* You can use the CEILING.MATH function to round up 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 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(1.1, 0) = 2
2	=ROUNDUP(1.5, 0) = 2
3	=ROUNDUP(1.9, 0) = 2
4	=ROUNDUP(-1.1, 0) = -2
5	=ROUNDUP(-1.5, 0) = -2
6	=ROUNDUP(-1.9, 0) = -2
7	=ROUNDUP(123.456, 0) = 124
8	=ROUNDUP(123.567, 0) = 124
9	=ROUNDUP(-123.456, 0) = -124
10	=ROUNDUP(-123.567, 0) = -124
11	=ROUNDUP(123.456, 4) = 123.4560
12	=ROUNDUP(123.456, 3) = 123.456
13	=ROUNDUP(123.456, 2) = 123.46
14	=ROUNDUP(123.456, 1) = 123.50
15	=ROUNDUP(123.456, -1) = 130
16	=ROUNDUP(123.456, -2) = 200
17	=ROUNDUP(123.456, -3) = 1000
18	=ROUNDUP(123.456, -4) = 10000
19	=ROUNDUP("", 0) = #VALUE!
20	=ROUNDUP(1.1, "") = #VALUE!

1 - What is the number 1.1 rounded up to 0 decimal places.
2 - What is the number 1.5 rounded up to 0 decimal places.
3 - What is the number 1.9 rounded up to 0 decimal places.
4 - What is the number -1.1 rounded up to 0 decimal places.
5 - What is the number -1.5 rounded up to 0 decimal places.
6 - What is the number -1.9 rounded up to 0 decimal places.
7 - What is the number 123.456 rounded up to 0 decimal places.
8 - What is the number 123.567 rounded up to 0 decimal places.
9 - What is the number -123.456 rounded up to 0 decimal places.
10 - What is the number -123.567 rounded up to 0 decimal places.
11 - What is the number 123.456 rounded up to 4 decimal places.
12 - What is the number 123.456 rounded up to 3 decimal places.
13 - What is the number 123.456 rounded up to 2 decimal places.
14 - What is the number 123.456 rounded up to 1 decimal place.
15 - What is the number 123.456 rounded up to -1 decimal places.
16 - What is the number 123.456 rounded up to -2 decimal places.
17 - What is the number 123.456 rounded up to -3 decimal places. There are only 3 digits on the left of the decimal place.
18 - What is the number 123.456 rounded up to -4 decimal places. There are only 3 digits on the left of the decimal place.