Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the Green triangle error
Excel onlyWhat Green triangle means
Excel places a small green triangle in the top-left corner of a cell when its background error checker detects a potential issue. The triangle is a warning, not an error — the cell may still compute correctly. Clicking the cell reveals a yellow diamond icon with options to inspect or dismiss the warning.
Common causes
- A number is stored as text (the most common trigger) — the cell contains numeric characters but the stored type is a string.
- A formula in the cell differs from the pattern of adjacent formulas in the same column, suggesting it may be inconsistent (e.g., a range stops one row short).
- A formula omits cells from a contiguous range — for example, =SUM(A1:A8) in a column where data exists through A10.
- A date is stored as text rather than as a date serial number.
- A formula references empty cells that are likely unintentional, such as =SUM(A1:A1000) when only A1:A20 has data.
Example fix
Broken
=SUM(A1:A8)Fixed
=SUM(A1:A10)If data runs from A1 to A10 but the formula only sums A1:A8, Excel flags it with a green triangle as a 'formula omits adjacent cells' warning. Extending the range to A1:A10 matches the data and clears the warning.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Click the cell with the green triangle. Click the yellow warning diamond that appears to the left. Read the description of the issue.
- 2Choose 'Convert to Number' if the warning is about a number stored as text. This converts the cell value in-place.
- 3Choose 'Update formula to include cells' if the warning is about an omitted range, then verify the expanded range is correct before accepting.
- 4Choose 'Ignore Error' if you have intentionally entered the value that way (e.g., a product code like '007' that must stay as text). This removes the triangle without changing the value.
- 5To disable specific green-triangle checks globally: File > Options > Formulas > Error Checking Rules — uncheck the rules you do not need.
Got the same error in multiple cells? Upload your whole sheet and the Auditor will flag every Green triangle and broken formula at once — free. Pro plans (₹199/$4.99/mo) can apply the verified fixes and download the corrected file in one click.
Frequently asked
Does the green triangle affect the formula result?
No. It is a visual indicator only. The formula computes normally regardless of the triangle. However, the warning often points to a real mistake worth investigating.
How do I remove green triangles from an entire worksheet at once?
You can suppress them globally via File > Options > Formulas > Error Checking — uncheck 'Enable background error checking'. This hides all triangles but also removes the safety net. Alternatively, select all affected cells, click the warning diamond, and choose 'Ignore Error'.
Does Google Sheets have green triangles?
No. Google Sheets does not have an equivalent background error-checking indicator. It relies on explicit error values (#N/A, #VALUE!, etc.) instead.