Excel ROUNDDOWN Function

A built-in Math/ Trig function, ROUNDOWN function can be used as a worksheet function.

Purpose

To round a number down, toward zero

Syntax

=ROUNDDOWN(number, num_digits)

Arguments

• Number.REQUIRED.Any real number that you want to round down.
• Num_digits.REQUIRED. The number of digits to which you want to round down the number.

If Num_Digits is:

• Zero (0). The number is rounded down to the nearest integer.
• Greater Than Zero (>0). The number is rounded down to the specified number of places in the right of decimal point.
• Less than zero (<0). The number is rounded down to the specified number of places in left of the decimal point.

Return Type

Number

Remarks

ROUNDDOWN behaves like ROUND. The only different is ROUNDDOWN always rounds a number down.