ExcelFlux

ROUNDDOWN function

Rounding — a number down, toward zero.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Round toward zero. A negative number can become less negative.

A worked example from the workbook

RowA
6Raw amount
712.789
8-12.789
9128
Two decimals
=ROUNDDOWN(A7,2)

Expected result12.78

See the inputs and instructions for all 3 examples

Syntax

ROUNDDOWN(number, num_digits)

Copyable formulas

English Excel · en-US
=ROUNDDOWN(12.789,2)
Turkish Excel · tr-TR
=AŞAĞIYUVARLA(12,789;2)

Expected result

12.78

Worked examples

Round toward zero. A negative number can become less negative.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Raw amount
7 12.789
8 -12.789
9 128
Case Formula Expected result
Two decimals =ROUNDDOWN(A7,2) 12.78
Negative amount =ROUNDDOWN(A8,2) -12.78
Tens =ROUNDDOWN(A9,-1) 120
Microsoft Excel reference