Excel ROUNDUP Function

Related Functions:

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.

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:

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 )

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.