Understanding Spreadsheet Calculation Errors
When a formula breaks, isolate the root cause instead of masking with IFERROR. Check data types, spill corridors, and lookup keys carefully.
Diagnostic checklist
- Trace precedents and dependents
- Clear non-empty cells in dynamic array spill ranges
- Coerce text numbers with VALUE or -- before math/lookups