# ROUNDUP

ROUNDUP(number, num_digits)

Returns the number rounded up to a specified number of 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
 * 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 ROUND function to round to a specified number of digits.* You can use the ROUNDDOWN function to round down to a specified number of digits.* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.* You can use the MROUND function to round to a desired 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* For the Google documentation refer to support.google.com

 A 1 =ROUNDUP(123.456, 4) = 123.4560 2 =ROUNDUP(123.456, 3) = 123.456 3 =ROUNDUP(123.456, 2) = 123.46 4 =ROUNDUP(123.456, 1) = 123.5 5 =ROUNDUP(123.456, 0) = 124 6 =ROUNDUP(123.456, -1) = 130 7 =ROUNDUP(123.456, -2) = 200 8 =ROUNDUP(123.456, -3) = 1000 9 =ROUNDUP(123.456, -4) = 10000

© 2024 Better Solutions Limited