Formula guide · Excel · Updated May 13, 2026
How to Fix #CALC! in Excel
Fix #CALC! errors in Excel dynamic array formulas such as FILTER, MAP, and LAMBDA.
Quick Answer
#CALC! often appears when a dynamic array formula has no result, unsupported nested arrays, or a LAMBDA-style calculation issue.
Copyable Formula
=FILTER(A2:D100,C2:C100="Paid","No matches")Syntax
=FILTER(range, condition, "No matches")Excel
Worked Example
| Symptom | Fix |
|---|---|
| Empty FILTER result | Add if_empty argument |
| Array issue | Check dimensions |
| LAMBDA issue | Test one step at a time |
Result: Adding a valid empty result or fixing array dimensions removes the #CALC! error.
Steps
- Check whether FILTER has no matching rows.
- Add the if_empty argument to FILTER.
- Check whether arrays have compatible dimensions.
- Break complex formulas into smaller helper steps.
Common Mistakes
- Confusing #CALC! with #SPILL! even though the causes differ.
- Leaving FILTER without an empty-result fallback.
- Debugging a large dynamic formula without testing smaller parts.
Excel vs Google Sheets Notes
This page is focused on Excel. If you need Google Sheets compatibility, check whether your Sheets account supports the same function or use one of the related alternatives.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.