Math & Trig
All versions
◉ 26 views
=ROUND()
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function is 23.78.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=ROUND(number, num_digits)
Hover argument names in the table for details.
Output typeNumber
Popularity85 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =ROUND() 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 | The number that you want to round. |
num_digits |
Number | Required | The number of digits to which you want to round the number argument. |
▣ Examples
Rounds 2.15 to one decimal place
=ROUND(2.15, 1)
Result:
2.2
Rounds 2.149 to one decimal place
=ROUND(2.149, 1)
Result:
2.1
Rounds -1.475 to two decimal places
=ROUND(-1.475, 2)
Result:
-1.48
Rounds 21.5 to one decimal place to the left of the decimal point
=ROUND(21.5, -1)
Result:
20
Rounds 626.3 to the nearest multiple of 1000
=ROUND(626.3,-3)
Result:
1000
Rounds 1.98 to the nearest multiple of 10
=ROUND(1.98,-1)
Result:
0
Rounds -50.55 to the nearest multiple of 100
=ROUND(-50.55,-2)
Result:
-100
§ Remarks
- If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
- If num_digits is 0, the number is rounded to the nearest integer.
- If num_digits is less than 0, the number is rounded to the left of the decimal point.
- To always round up (away from zero), use the ROUNDUP function.
- To always round down (toward zero), use the ROUNDDOWN function.
- To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
✦ Tips
- If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
- If num_digits is 0, the number is rounded to the nearest integer.
- If num_digits is less than 0, the number is rounded to the left of the decimal point.
- To always round up (away from zero), use the ROUNDUP function.
- To always round down (toward zero), use the ROUNDDOWN function.
- To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
💬 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!