What you will fix

You will intentionally create a formula parse error in H2, identify the missing closing parenthesis, repair the formula, and confirm the result is 24 without changing the source data.

Learning objectives

Open the practice workbook

HANDS-ON PRACTICE

Practice in your own copy

Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.

Make a Google Sheets copy (access required) ↗View original

Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.

Sample data

ItemQtyPrice
Pen212
Book335

The first data row is Pen in row 2, so B2=2 and C2=12. Keep A1:C3 unchanged while troubleshooting.

Google Sheets _result workbook showing the Item, Qty, and Price source table before reproducing the formula parse error.

Reproduce and diagnose the parse error

Step 1: Select H2 and enter =SUM(B2*C2 without the closing parenthesis. Press Enter. Google Sheets should reject the syntax with a formula parse error; do not change B2 or C2.

Google Sheets _result workbook with H2 selected after entering the deliberately incomplete =SUM(B2*C2 formula, showing the parse-error state for the current audit.

Step 2: Edit H2 and compare the opening and closing parentheses. The formula has one opening parenthesis after SUM but no matching closing parenthesis. If your own failing formula uses a multi-argument function, also check the argument separator required by the sheet locale.

Step 3: Replace the broken expression with =B2*C2 and press Enter. This removes the syntax problem while preserving the intended multiplication.

Correct formula

=B2*C2
Google Sheets _result workbook with H2 selected, the corrected =B2*C2 formula visible, result 24 displayed, and the source table still unchanged.

Checkpoint

CellExpected
B22
C212
H224

H2 must display 24 after the correction, while the source table A1:C3 remains unchanged.

Common mistakes and fixes

If the formula still fails, check unmatched parentheses, quotation marks, and function-argument separators. Fix one syntax issue, submit the formula again, and only then investigate source values if the formula parses but the result is unexpected.

Independent practice

In H3, intentionally enter =SUM(B3*C3 without the closing parenthesis, observe the parse error, then repair it as =B3*C3. The repaired result should be 105. Clear H3 afterward so the workbook returns to the checkpoint.

Key takeaways

  • ✓A parse error is a formula syntax problem, not automatically a source-data problem.
  • ✓Use a deliberately broken copy to identify the exact syntax issue.
  • ✓Check matching parentheses, quotation marks, and locale-dependent separators.
  • ✓Fix one syntax issue at a time instead of hiding the error with IFERROR.
  • ✓Verify the repaired H2 formula =B2*C2 returns 24.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. What causes the deliberate parse error in Step 1?
2. What should you inspect first when Sheets reports a formula parse error?
3. What is the corrected formula in H2?
4. What result should H2 display after the repair?

Next lesson

Continue with Fix circular dependency errors.