What you will build
You will diagnose a formula-separator problem without assuming that commas or semicolons are always correct. In the verified practice workbook, the locale is United States, C2 keeps a semicolon formula as a literal text example, and D2 uses the working formula =SUM(A2,B2).
Learning objectives
Open the practice workbook
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.
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
| Qty | Price | Wrong separator example | Correct result |
|---|---|---|---|
| 3 | 5 | =SUM(A2;B2) | 8 |
C2 is intentionally stored as text for comparison. D2 is calculated by the working formula.
Hands-on practice
Step 1: Open File > Settings and check Locale. In the verified workbook it is United States, so formulas use commas between arguments.
Step 2: Keep C2 as the literal text example =SUM(A2;B2). Enter =SUM(A2,B2) in D2. Do not overwrite C2, because it is the broken syntax example you are comparing against.
=SUM(A2,B2)Step 3: Select D2 and confirm the formula bar shows =SUM(A2,B2) and the calculated result is 8.
Recalculation check: temporarily change A2 from 3 to 4. D2 should update from 8 to 9. Restore A2 to 3 and confirm D2 returns to 8.
Checkpoint
| Qty | Price | Wrong separator example | Correct result |
|---|---|---|---|
| 3 | 5 | =SUM(A2;B2) | 8 |
The final sample keeps the semicolon version as text in C2 and calculates D2 with =SUM(A2,B2).
Common mistakes and fixes
If C2 evaluates instead of staying visible as an example, store it as text by entering a leading apostrophe before the equals sign. If D2 shows a formula parse error, re-check the locale and use that locale’s argument separator.
Independent practice
Add a temporary row with two numeric inputs, write the SUM formula using the separator required by your workbook locale, verify the result, then remove the test row so the sample returns to its original state.
Key takeaways
- ✓Check File > Settings > Locale before changing formula separators.
- ✓Commas and semicolons are locale-dependent; neither is universally correct.
- ✓Keep the broken syntax visible as text so you can compare it with the working formula.
- ✓In the verified United States locale workbook, D2 uses =SUM(A2,B2) and returns 8 for 3 and 5.
- ✓Change one input to confirm the formula recalculates, then restore the original sample.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue the troubleshooting sequence by fixing numbers that look numeric but are stored as text.
Comments
No comments yet. Be the first to join the discussion.