Summary

The Excel ROUNDDOWN function always rounds a number toward zero. It does not apply standard rounding rules and does not inspect whether the discarded digits are above or below 5. It simply moves the result toward zero at the requested precision.

This makes ROUNDDOWN appropriate when the result should not overstate what is complete, available, or earned. It is commonly used in billing, inventory, and operational reporting where partial units should not be counted as full units.

Syntax

=ROUNDDOWN(number, num_digits)

The syntax matches ROUND and ROUNDUP, but the directional rule is different. Microsoft defines ROUNDDOWN as rounding a number down, toward zero.

Arguments

• number - [required] The value to round.
• num_digits - [required] The number of digits to retain.

ROUNDDOWN vs Related Functions

Using ROUNDDOWN

ROUNDDOWN is most useful when partial values should not be credited as complete values. If a process has produced 4.9 full units in theory, but only 4 complete units are actually usable, ROUNDDOWN expresses that rule directly. It is a function of policy as much as arithmetic.

The distinction between ROUNDDOWN and INT is especially important with negative numbers. For positive inputs they often agree, but for negative values they diverge because INT rounds toward negative infinity while ROUNDDOWN rounds toward zero. That makes ROUNDDOWN the more precise choice when direction relative to zero is the intended rule.

Like the other rounding functions, ROUNDDOWN can also operate left of the decimal point. Negative digit arguments allow the function to work at the tens, hundreds, or thousands level, which is useful in reporting and threshold-based planning.

Example 1 - Round Down to Two Decimal Places

This is the decimal-precision form of the rule.

=ROUNDDOWN(B1,2)

If B1 contains 3.14159, the result is 3.14. The discarded digits do not influence the direction. The result simply moves toward zero at the second decimal place.

Example 2 - Round Down to the Integer Level

With 0 digits, the function removes the fractional part by moving toward zero.

=ROUNDDOWN(B2,0)

If B2 contains 10.9, the result is 10. This is useful whenever the calculation should acknowledge only completed whole units.

Example 3 - Count Completed Full Hours

This is a standard billing and utilization pattern.

=ROUNDDOWN(B3,0)

If B3 contains 4.9, the result is 4. The partial hour is not counted as a full unit, which is the intended behavior in completed-unit logic.

Example 4 - Round Down to the Nearest Hundred

Negative digit values move the operation to larger place values.

=ROUNDDOWN(B4,-2)

If B4 contains 1289, the result is 1200. This can be useful when a summary should reflect a conservative lower approximation rather than a rounded midpoint result.

When the rule is step-based rather than digit-based, FLOOR.MATH is often a better fit than ROUNDDOWN. For example, "down to the nearest 15 minutes" is not the same type of problem as "down to zero decimal places."

• ROUNDDOWN moves toward zero, not toward negative infinity.
• That is why it differs from INT for negative numbers.
• Use FLOOR.MATH for downward rounding to a specific multiple.

Conclusion Recap

• Summary: ROUNDDOWN always rounds toward zero.
• Main use: Completed-unit and conservative downward calculations.
• Key distinction: It differs from INT when negative numbers are involved.
• Digit behavior: Negative digit values round at larger place values.
• Function choice: Use FLOOR.MATH when the rule is based on multiples rather than digit positions.