ROUNDDOWN Formula in Excel

 

What Does It Do ?

This function rounds a number down to a specified amount of decimal places.

If 0 is used the number is rounded down to the nearest whole number.

If a negative amount of rounding is used the figures to the left of the decimal point are rounded.

Syntax

=ROUNDDOWN(NumberToRound,DecimalPlacesToUse)

Formatting

No special formatting is needed.