Formula Error Troubleshooting Hub
Quickly diagnose and fix formula errors in Excel and Google Sheets with step-by-step debugging guides.
How to Find and Fix Circular References in Excel & Google Sheets
Locate circular dependency loops, resolve calculation freezes, and enable iterative calculations when intentional in spreadsheets.
How to Fix the #NAME? Error in Excel & Google Sheets (Formula Typos)
Fix misspelled function names, unquoted text strings, missing named ranges, and formula syntax typos causing the #NAME? error.
How to Fix the #NUM! Error in Excel & Google Sheets (Calculation Range)
Fix calculation overflow, negative square roots, IRR convergence failures, and DATEDIF invalid start/end dates causing #NUM! errors.
How to Fix the #N/A Error in Excel & Google Sheets (VLOOKUP & XLOOKUP)
Diagnose and resolve the #N/A 'Value Not Available' error in VLOOKUP, XLOOKUP, MATCH, and INDEX formulas.
How to Fix the #DIV/0! Error in Excel & Google Sheets (Division by Zero)
Trap and suppress #DIV/0! division by zero errors in financial ratios, percentage calculations, and averages using IF and IFERROR.
How to Fix the #REF! Error in Excel & Google Sheets (Invalid Cell Reference)
Recover from deleted rows/columns, broken VLOOKUP column index references, and circular cut-and-paste actions causing #REF! errors.
How to Fix the #SPILL! Error in Excel (Dynamic Array Spill Range Blocked)
Resolve the #SPILL! error in Excel dynamic arrays (UNIQUE, FILTER, SORT, SEQUENCE, XLOOKUP) by clearing blocking cells and merged ranges.
How to Fix the #VALUE! Error in Excel & Google Sheets
Fix data type mismatches, mathematical operations on text strings, and syntax errors causing the #VALUE! error in spreadsheets.