Skip to main content

ROUNDUP

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)

ArgumentDescriptionPermitted values
valueNumber for roundingNumerical value or reference to a cell containing a number
placesNumber 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.