Math & Trig
All versions
◉ 19 views
=ROUNDDOWN()
Rounds a number down, toward zero.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=ROUNDDOWN(number, num_digits)
Hover argument names in the table for details.
Output typeNumber
Popularity55 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =ROUNDDOWN() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | Any real number that you want rounded down. |
num_digits |
Number | Required | The number of digits to which you want to round number. |
▣ Examples
Rounds 3.2 down to zero decimal places.
=ROUNDDOWN(3.2, 0)
Result:
3
Rounds 76.9 down to zero decimal places.
=ROUNDDOWN(76.9,0)
Result:
76
Rounds 3.14159 down to three decimal places.
=ROUNDDOWN(3.14159, 3)
Result:
3.141
Rounds -3.14159 down to one decimal place.
=ROUNDDOWN(-3.14159, 1)
Result:
-3.1
Rounds 31415.92654 down to 2 decimal places to the left of the decimal point.
=ROUNDDOWN(31415.92654, -2)
Result:
31400
§ Remarks
- ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
- If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
- If num_digits is 0, then number is rounded down to the nearest integer.
- If num_digits is less than 0, then number is rounded down to the left of the decimal point.
✦ Tips
- ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
- If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
- If num_digits is 0, then number is rounded down to the nearest integer.
- If num_digits is less than 0, then number is rounded down to the left of the decimal point.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!