ROUND Function in Excel, Google Sheets, Airtable & Notion
ROUND rounds a number to a given number of digits. Halves round away from zero, so 2.5 becomes 3 and −2.5 becomes −3.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | ROUND(number, num_digits) |
| Google Sheets | ✔ Built in | ROUND(value, [places])places is optional and defaults to 0. |
| Airtable | ✔ Built in | ROUND(value, precision) |
| Notion | ≈ Workaround | round(number * 100) / 100round() rounds to a whole number, so multiply and divide by a power of ten to keep decimals. Halves round up (−2.5 → −2), unlike Excel. |
| Excel | =ROUND(2.345, 2) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =ROUND(2.345, 2) | open sheets.new ↗ |
| Airtable | ROUND(2.345, 2) | |
| Notion workaround | round(2.345 * 100) / 100 |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The value to round. |
num_digits | How many decimal places to keep. 0 rounds to a whole number; negative values round to the left of the decimal point (−1 = nearest 10, −2 = nearest 100). |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=ROUND(2.345, 2) | 2.35 | Third decimal is 5, so round up. | |
=ROUND(2.5, 0) | 3 | Halves round away from zero. | |
=ROUND(-2.5, 0) | -3 | Also away from zero for negatives. | |
=ROUND(1234.5678, -2) | 1200 | Negative digits round to tens, hundreds… |
Examples use Excel / Google Sheets syntax unless noted.
How ROUND works
ROUND changes the stored value, not just how it looks. Formatting a cell to two decimals only hides digits; the full value is still used in later calculations, which is why invoices sometimes appear to be off by a cent. Rounding each line with =ROUND(B2*C2, 2) before totalling fixes that.
Excel, Google Sheets and Airtable all round halves away from zero. Notion's round() follows JavaScript and rounds halves up, so round(-2.5) is −2. Notion also only rounds to whole numbers, which is why the copy-ready Notion formula multiplies by 100 and divides back.
Floating-point arithmetic can make a value such as 2.675 actually stored as 2.67499999…, and some tools round it down. Excel and Google Sheets correct for this to 15 significant digits, and so does the tester on this page. For always-up or always-down rounding use ROUNDUP and ROUNDDOWN; to round to a multiple such as 0.25 or 5, use CEILING, FLOOR or MROUND.
Frequently Asked Questions
- How do I round to the nearest 10 or 100?
- Use a negative number of digits:
=ROUND(A2, -1)rounds to the nearest 10,=ROUND(A2, -2)to the nearest 100. - Does ROUND change the value or only the display?
- It changes the value. Number formatting only changes the display.