Cellwise Try it free

Math function

Excel ROUNDDOWN function

ROUNDDOWN cuts a number down to the digits you choose and drops the rest. Use it when only complete units count, like full packs you can fill or whole years of service.

=ROUNDDOWN(number, num_digits)

Arguments

number
The number or cell to round down.
num_digits
How many decimal places to keep. 0 gives a whole number, negative values round down to tens, hundreds and so on.

ROUNDDOWN examples

Every result below was calculated from this sample sheet by the same spreadsheet engine the Cellwise app uses.

ABCD
1ProductStockPack sizePrice
2AA batteries250127.489
3Tape rolls9863.996
4Zip ties14601005.25
  1. =ROUNDDOWN(B2/C2,0)

    Result: 20

    250 batteries fill 20 full 12-packs. The leftover 10 do not make a pack.

  2. =ROUNDDOWN(D3,2)

    Result: 3.99

    Keep two decimals with no rounding up: 3.996 becomes 3.99.

  3. =ROUNDDOWN(B4,-2)

    Result: 1400

    Negative digits round down to hundreds: 1460 becomes 1400.

  4. =ROUNDDOWN(-7.8,0)

    Result: -7

    ROUNDDOWN moves toward zero, so -7.8 becomes -7.

How to use ROUNDDOWN

  1. Click an empty cell.
  2. Type =ROUNDDOWN( and the number or calculation.
  3. Type a comma and the number of digits to keep.
  4. Close the bracket and press Enter.

Common ROUNDDOWN mistakes

Confusing it with INT on negatives

ROUNDDOWN(-7.8,0) is -7, but INT(-7.8) is -8. INT always goes to the lower number.

Thinking it is the same as formatting

Formatting a cell to 2 decimals rounds to the nearest. ROUNDDOWN actually changes the value and never rounds up.

Leaving out num_digits

Both arguments are required. Use 0 to drop all decimals.

ROUNDDOWN FAQ

How do I round down in Excel?

Use =ROUNDDOWN(A1,0) for a whole number, or set the second argument to keep decimals.

How do I remove decimals without rounding in Excel?

Use =ROUNDDOWN(A1,0) or =TRUNC(A1). Both chop off the decimals without rounding up.

What is the difference between ROUNDDOWN and INT?

They match for positive numbers. For negatives, ROUNDDOWN goes toward zero (-7) while INT goes down to the lower integer (-8).

Guides that use ROUNDDOWN

Related functions

Updated