ROUNDUP Function in Excel – Round up Values in Excel

ROUNDUP Function in Excel Rounds up the number to the specified decimal places.

Syntax of ROUNDUP function in Excel

ROUNDUP(number,num_digits)

number – The number to be rounded up

num_digits – The number of decimal places to which the number has to be rounded up.

  • A positive num_digits value specifies the number of digits to the right of the decimal point.
  • if num_digits value of 0 specifies rounding down to the nearest integer.
  • A negative num_digits value specifies the number of digits to the left of the decimal point.

 

Example of ROUNDUP Function in Excel

FORMULA

ROUNDUP Function in Excel 1

  • Row number 2 & 3 Rounds up to 1 and 2 decimal places respectively
  • Row number 4 Rounds up  to nearest integer
  • Row number 5 Rounds up to nearest 10
  • Row number 6 Rounds up to nearest 100

So the result will be

Result

ROUNDUP Function in Excel 2

previous-small ROUNDUP Function in Excel                                                                                                                next_small ROUNDUP Function in Excel