ROUNDUP(number, num_digits)

Returns the number rounded up to the nearest integer.

numberThe number you want to round up (away from zero).
num_digitsThe number of digits you want to round the number to.

Remarks

* This function is identical to the ROUND function, except that it always rounds a number up.
* 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" is left blank, 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.
* You can use the ROUNDDOWN 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(123.456,-4) = 10000
2=ROUNDUP(123.456,-3) = 1000
3=ROUNDUP(123.456,-2) = 200
4=ROUNDUP(123.456,-1) = 130
5=ROUNDUP(123.456,0) = 124
6=ROUNDUP(123.456,1) = 124
7=ROUNDUP(123.456,2) = 123
8=ROUNDUP(123.456,3) = 123
9=ROUNDUP(123.456,4) = 123
10=ROUNDUP(56.78,-4) = 10000
11=ROUNDUP(56.78,-3) = 1000
12=ROUNDUP(56.78,-2) = 100
13=ROUNDUP(56.78,-1) = 60
14=ROUNDUP(56.78,0) = 57
15=ROUNDUP(56.78,1) = 57
16=ROUNDUP(56.78,2) = 57
17=ROUNDUP(56.78,3) = 57
18=ROUNDUP(56.78,4) = 57

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