How to use ROUNDDOWN in Excel
Rounds down, toward zero.
Syntax
numberThe numbernum_digitsHow many decimal placesExample
Here’s ROUNDDOWN on a small table of orders. The highlighted cells are the ones the formula reads.
=ROUNDDOWN(AVERAGE(E2:E9),0)Edit this formula live Change the ranges and watch the answer update. Free, no sign-up.
Common mistakes with ROUNDDOWN
It always rounds toward zero
=ROUNDDOWN(2.99,0) is 2, and =ROUNDDOWN(-2.99,0) is -2.
Not the same as INT for negatives
INT(-2.5) is -3, but ROUNDDOWN(-2.5,0) is -2.
What the error messages mean
Type these slips into Gridwise and this is the feedback you get:
Leaving off the closing bracket
=ROUNDDOWN(AVERAGE(E2:E9),0
Parentheses don’t match. You have 2 opening and 1 closing parentheses. Every ( needs a ).
Questions
What does the ROUNDDOWN function do in Excel?
Rounds down, toward zero. The syntax is ROUNDDOWN(number, num_digits).
Why is my ROUNDDOWN formula giving the wrong answer?
It always rounds toward zero: =ROUNDDOWN(2.99,0) is 2, and =ROUNDDOWN(-2.99,0) is -2. Not the same as INT for negatives: INT(-2.5) is -3, but ROUNDDOWN(-2.5,0) is -2.
Does ROUNDDOWN work in Google Sheets?
Most Excel functions, including the core ones on this page, work the same way in Google Sheets. A few newer functions arrived in Sheets later or behave slightly differently, so test it on your own data.