The ROUNDUP function rounds a value up to a specified number of places before or after the decimal point.
This can be useful when you need to ensure that the result is not less than a certain value, for example, in financial calculations or planning.
Syntax
ROUNDUP(value, places)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Number for rounding |
Numerical value or reference to a cell containing a number |
places |
Number of decimal places to which a given number is rounded (up) |
Integer (can be negative) or a reference to a cell containing a number |
Examples of use
Rounding a number up to the nearest whole number
=ROUNDUP(3.2, 0)
Result: 4.
Rounding a number up to one decimal place
=ROUNDUP(5.67, 1)
Result: 5.7.
Rounding a number up to the nearest hundred with a negative value
=ROUNDUP(12345, -2)
Result: 12,400.
Notes
–The ROUNDUP function always rounds numbers up.
–If the value of the places argument is positive, the number is rounded up to that number of decimal places.
–If the value of the places argument is negative, the number is rounded up to the nearest whole number, tens, hundreds, and so forth.