Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inROUND(number, num_digits)
Google Sheets✔ Built inROUND(value, [places])
places is optional and defaults to 0.
Airtable✔ Built inROUND(value, precision)
Notion≈ Workaroundround(number * 100) / 100
round() 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.
Try ROUND with your own values
Use −1 for the nearest 10, −2 for the nearest 100
Result (as Excel & Google Sheets return it)
2.35
Your formula, ready to paste
Excel=ROUND(2.345, 2) open excel.new ↗
Google Sheets=ROUND(2.345, 2) open sheets.new ↗
AirtableROUND(2.345, 2)
Notion
workaround
round(2.345 * 100) / 100

Arguments

ArgumentWhat it means
numberThe value to round.
num_digitsHow 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

FormulaResultWhyCopy
=ROUND(2.345, 2)2.35Third decimal is 5, so round up.
=ROUND(2.5, 0)3Halves round away from zero.
=ROUND(-2.5, 0)-3Also away from zero for negatives.
=ROUND(1234.5678, -2)1200Negative 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.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.