Excel ROUNDUP Function

Related Functions:
ROUND
ROUNDDOWN
TRUNC

Basic Description

The Excel Roundup function rounds a supplied number up, away from zero, to a specified number of decimal places.

The syntax of the function is:

ROUNDUP( number, num_digits )

Where the arguments are listed in the following table:

number-The initial number.
num_digits-

The number of decimal places to round the supplied number to.

Note that:

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

Roundup Function Examples

The following spreadsheets show examples of the Excel Roundup function:

 Formulas:
 AB
111.111=ROUNDUP( A1, 1 )
211.111=ROUNDUP( A2, 2 )
311.111=ROUNDUP( A3, 0 )
411.111=ROUNDUP( A4, -1 )
5-11.111=ROUNDUP( A5, 2 )
6-11.111=ROUNDUP( A6, -1 )
 Results:
 AB
111.11111.2
211.11111.12
311.11112
411.11120
5-11.111-11.12
6-11.111-20

The above examples show how the Roundup function always rounds up, away from zero. I.e. a positive number becomes more positive and a negative number becomes more negative.


Further information on the Excel Roundup Function is provided on the Microsoft Office website. Also, a comparison of the Excel Rounding Functions is provided on the Excel Rounding Functions page.