Excel 2000 in a Nutshell

Name

ROUNDDOWN

Synopsis

You can use ROUNDDOWN to round a numeric value so that it has the specified number of decimal digits by rounding the number down (toward 0). For example, if you want to round the value 1.45673 to two digits, the function returns a value of 1.45; even though the thousandths place contains a value of 6, the hundredths place is rounded down to 5.

To Calculate

=ROUNDDOWN(Number, Num_Digits)

The Number and Num_Digits arguments are both required for this function.

Number

Specifies a numeric value that you want to round.

Num_Digits

An integer value that specifies the number of decimal places that you want to round the numeric value specified for the Number argument to. If this argument is the numeric value is rounded down to the closest integer value. If the Num_Digits argument is a negative value the value on the left side of the decimal is rounded down. For example, =ROUND(19.45, -2) returns a value of 17.

Example

Figure 14-15 illustrates the results when ROUNDDOWN is used to round numeric values down to one decimal place. The example allows you to compare these results to the ones achieved when you use ROUNDUP and ROUND.