ROUNDDOWN()

Syntax. ROUNDDOWN(number,num_digits)

Definition. This function rounds a number down to the number of digits specified in num_digits.

Arguments

• number (required) The real number to be rounded down

• num_digits (required) The number of decimal places to which you want to round the number down

Background. Unlike ROUND(), in which numbers less than five round down and greater than or equal to five round up, the ROUNDDOWN() function always rounds a number down. The number is truncated at the position specified in num_digits. If num_digits is a negative value, the number is rounded down to the specified number of digits before the decimal point.

If num_digits is:

• Greater than zero, the number is rounded down to the specified number of decimal places.

• Equal to zero, the number is rounded down to the nearest integer.

• Less than zero, the number is rounded down to the left of the decimal point.

Examples. For a price calculation, assume that you want to round the calculated final amounts of 15.482 and 83.2578 to two decimal places:

• =ROUNDDOWN(15.482,2) returns $15.48.

• =ROUNDDOWN(83.2578,2) returns $83.25.

A few more examples demonstrate this function further:

• =ROUNDDOWN(1.9,0) returns 1.

• =ROUNDDOWN(-2.846,2) returns -2.84.

• =ROUNDDOWN(18,-1) returns 10.

See Also

CEILING(), CEILING.PRECISE(), FLOOR(), FLOOR.PRECISE(), INT(), MOD(), MROUND(), ROUND(), ROUNDUP(), TRUNC()

Sample Files

Use the ROUND worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.