Formula error guides
Beginner-friendly fixes for the errors you see most often. Open a guide, then try Fix mode in the app.
- How to fix #DIV/0! in Excel and Google Sheets
Learn what #DIV/0! means and how to fix divide-by-zero errors with simple formulas for beginners.
- How to fix #N/A in Excel and Google Sheets
Understand #N/A errors and fix lookup formulas that cannot find a match.
- How to fix #REF! in Excel and Google Sheets
Fix #REF! errors when formulas point to deleted cells or invalid ranges.
- How to fix #VALUE! in Excel and Google Sheets
Fix #VALUE! when Excel or Sheets cannot understand text where it expected a number.
- VLOOKUP returns #N/A — how to fix it
Step-by-step help when VLOOKUP cannot find your lookup value.
- SUM formula returns 0 but numbers look correct
Why SUM shows zero and how to fix numbers stored as text.
- How to fix #NAME? in Excel and Google Sheets
Fix #NAME? when the spreadsheet does not recognize a function or range name.
- How to fix #NUM! in Excel and Google Sheets
Understand #NUM! errors from invalid numeric operations.
- Circular reference warning — what to do
Fix formulas that refer to themselves and cause circular reference errors.
- How to fix #SPILL! in Excel
Fix #SPILL! when a dynamic array formula does not have room to expand.