The Excel ROUNDUP function
returns a number rounded up to a given number of decimal places. Unlike
standard rounding, where numbers less than 5 are rounded down, ROUNDUP
always rounds numbers 1-9 up.
Syntax
The syntax for the ROUNDUP
function in Microsoft Excel is:
=ROUNDUP( number, digits )
Parameters or Arguments
number
The number to round up.
digits
The number of digits to round
the number up to.
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.
Notes
Ø ROUNDUP
can round either to the left or right of the decimal point.
Ø If
num_digits > 0, number is rounded up
to the specified number of decimal places to the right of the decimal point.
Ø If
num_digits < 0, number is rounded up
to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).
Ø If
num_digits = 0, number is rounded up to
the nearest integer.
References
No comments:
Post a Comment