fx =ROUND(A1,2)ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

ROUND Formula for Math

Round a number to specified decimal places. Copy-paste ready for Excel, Google Sheets, and Airtable.

=ROUND(A1,2)
When you need this: When you need to round the calculated price (A1 = $19.9567) to 2 decimal places ($19.96) for display.

How it works

  1. 1ROUND takes a number (A1) and decimal places (2).
  2. 2Rounds mathematically (0.5+ rounds up, <0.5 rounds down).
  3. 3Returns clean currency with exactly 2 decimals.

Variations

Round to nearest 10
=ROUND(A1,-1)
Round to nearest 100
=ROUND(A1,-2)

Related Formulas

SUM — Add up a range of numbersMathSUMIF — Sum values that meet a single conditionMathSUMIFS — Sum values meeting multiple conditionsMathARRAYFORMULA — Apply a formula to an entire column (Google Sheets)Math

Need a formula that's not here?

Generate custom formula →