Excel function

ROUNDDOWN in Excel: always round toward zero

ROUNDDOWN trims a number toward zero at a chosen digit position. It is useful when a rule says extra decimals or partial units should be ignored.

What ROUNDDOWN does

ROUNDDOWN rounds a number toward zero to a specified number of digits. The syntax is `=ROUNDDOWN(number, num_digits)`.

For example, `=ROUNDDOWN(12.349,2)` returns 12.34. It does not round to 12.35 because ROUNDDOWN ignores the extra digits and moves toward zero. For negative numbers, toward zero means less negative: `=ROUNDDOWN(-12.349,2)` returns -12.34.

ROUNDDOWN is useful when partial amounts should not count, such as completed units, conservative credits, or measurements reported without rounding up.

Arguments explained

`number` is the value to round. `num_digits` controls where rounding happens. Positive digits keep that many decimal places. Zero digits return a whole number toward zero. Negative digits round toward zero to tens, hundreds, or thousands.

`=ROUNDDOWN(A2,1)` keeps one decimal place. `=ROUNDDOWN(A2,0)` removes decimals toward zero. `=ROUNDDOWN(A2,-1)` rounds toward zero to the nearest ten position.

ROUNDDOWN differs from ROUND because ROUND uses nearest-value logic. It differs from INT because INT rounds down toward negative infinity. For positive numbers, INT and ROUNDDOWN with zero digits may look similar; for negative numbers, they can differ.

That nuance matters when spreadsheets include adjustments, refunds, or negative variances. A formula that works on positive examples can behave differently once negative values appear, so test both directions before reusing it.

Practical examples

A beginner example is keeping one decimal in a score without rounding up: `=ROUNDDOWN(B2,1)`. If B2 is 88.97, the result is 88.9.

A business example is calculating completed full units. If A2 contains total minutes and B2 contains minutes per batch, `=ROUNDDOWN(A2/B2,0)` returns only fully completed batches.

An engineering example is reporting a measured value to two decimals without overstating it: `=ROUNDDOWN(C2,2)`. This should be used only when the reporting rule actually says to truncate toward zero.

For practice, test values such as 12.99, 12.01, -12.99, and -12.01. Those examples make it clear that ROUNDDOWN moves toward zero rather than toward the smaller number on the number line.

When to use it

Use ROUNDDOWN when extra decimals or partial units should be ignored by rule. It is helpful for completed quantities, conservative reporting, and controlled calculations where upward rounding would overstate the result.

Do not use ROUNDDOWN for normal rounding. If the closest value should be used, use ROUND. Do not assume ROUNDDOWN and INT are identical, especially with negative values.

Practical examples

Keep two decimals without rounding up

=ROUNDDOWN(A2,2)

Returns A2 rounded toward zero to two decimal places.

Completed full batches

=ROUNDDOWN(A2/B2,0)

Divides total units by units per batch and keeps only the whole completed batches.

Recommended Excel functions

ROUNDDOWNROUNDROUNDUPINTTRUNC

Common mistakes

  • 01Using ROUNDDOWN when normal ROUND is required.
  • 02Assuming ROUNDDOWN and INT behave the same for negative numbers.
  • 03Using ROUNDDOWN to hide precision without a clear rule.
  • 04Forgetting that negative num_digits rounds toward zero at tens or hundreds positions.

Practice

Practice this skill with interactive exercises on Calcu.

Use Calcu to practice ROUNDDOWN in realistic spreadsheet exercises with instant feedback.

Open Calcu

FAQ

Does ROUNDDOWN always round down?

ROUNDDOWN always rounds toward zero, which is not the same as always rounding toward negative infinity.

How is ROUNDDOWN different from ROUND?

ROUND uses normal nearest-value rounding. ROUNDDOWN always moves toward zero.

Is ROUNDDOWN the same as INT?

Not always. They can differ with negative numbers because INT rounds toward negative infinity.