Excel ROUNDUP Function

Related Functions:

ROUND
ROUNDDOWN
TRUNC

Function 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 number that is to be rounded.

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

Column B of the following spreadsheet shows several examples of the Excel Roundup function:

Formulas:

	A	B
1	11.111	=ROUNDUP( A1, 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.111	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. I.e. a positive number becomes more positive and a negative number becomes more negative.

If you require different rounding rules, check out our comparison of Excel Rounding Functions.

See the Microsoft Office website for further details and examples of the Excel Roundup Function.

Return to the Excel Math Functions Page
Return to the List of All Built-In Excel Functions