The Excel ROUNDDOWN function
returns a number rounded down to a given number of decimal places. Unlike
standard rounding, where only numbers less than 5 are rounded
down, ROUNDDOWN rounds all numbers 1-9 up.
Syntax
The syntax for the ROUNDDOWN
function in Microsoft Excel is:
=ROUNDDOWN( number, digits )
Parameters or Arguments
number
The number to round down.
digits
The number of digits to round
the number down to.
Rounddown Function Examples
Column B of following
spreadsheet shows several examples of the Excel Rounddown function:
Formulas:
|
|
A
|
B
|
|
1
|
99.999
|
=ROUNDDOWN(
A1, 1 )
|
|
2
|
99.999
|
=ROUNDDOWN(
A2, 2 )
|
|
3
|
99.999
|
=ROUNDDOWN(
A3, 0 )
|
|
4
|
99.999
|
=ROUNDDOWN(
A4, -1 )
|
|
5
|
-99.999
|
=ROUNDDOWN(
A5, 2 )
|
|
6
|
-99.999
|
=ROUNDDOWN(
A6, -1 )
|
Results:
|
|
A
|
B
|
|
1
|
99.999
|
99.9
|
|
2
|
99.999
|
99.99
|
|
3
|
99.999
|
99
|
|
4
|
99.999
|
90
|
|
5
|
-99.999
|
-99.99
|
|
6
|
-99.999
|
-90
|
The above examples show how
the Rounddown function always rounds down towards zero. I.e. a positive number
becomes less positive and a negative number becomes less negative.
Notes
Ø The
ROUNDDOWN function works like the ROUND function except when rounding, the
ROUNDDOWN function will always round the numbers 1-9 down.
Ø The
ROUNDDOWN function can round either to the left or right of the decimal point.
Ø If
num_digits > 0, number is rounded
down to the specified number of decimal places to the right of the decimal
point.
Ø If
num_digits < 0, number is rounded
down to the left of the decimal point (i.e. to the nearest 10, 100, 1000,
etc.).
Ø If
num_digits = 0, number is rounded down
to the nearest integer.
References
No comments:
Post a Comment