ExcelFunctions.net

Excel ROUNDUP Function

Related Functions:
Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Roundup-Function

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 as follows:

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

The above arguments can be supplied to the Roundup function as either simple numbers, references to cells containing numbers, or as values returned from other functions or formulas.


Roundup Function Examples

The following spreadsheet shows the Excel Roundup function used with different argument values:

 Formulas:
  A B
1   =ROUNDUP( 11.111, 1 )
2 11.111 =ROUNDUP( A2, 2 )
3 11.111 =ROUNDUP( A3, 0 )
4 11.111 =ROUNDUP( A4, -1 )
5 -11.111 =ROUNDUP( A5, 2 )
6 -11.111 =ROUNDUP( A6, -1 )
 Results:
  A B
1   11.2
2 11.111 11.12
3 11.111 12
4 11.111 20
5 -11.111 -11.12
6 -11.111 -20

The above examples show how the Roundup function always rounds up, away from zero - ie. 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.