Excel #CALC! error

A plain-words explanation of this Excel message: what it means, the usual causes, and the steps that fix it.

The message#CALC!

Make the error yourself

Typed into Microsoft Excel 16.0 build 20326. This is the smallest example we could find that shows it.

The cell looked at: C1.

Excel shows: #CALC!

Why it happens

#CALC! is the error of dynamic array formulas. The most frequent cause is FILTER (or another function that returns a list) finding nothing: the result is an empty array, and Excel cannot show an empty array in a cell. In the example no number is above 100. It can also appear when a LAMBDA or a calculation inside an array formula fails in a way that Excel cannot describe with another error type.

How to fix it

1. Give FILTER a third argument: the text or value to show when nothing matches, as in FILTER(range,condition,"none").
2. Check the condition by testing it in a spare cell, to see whether it is ever true.
3. Make sure the filter condition has the same size as the range.

The corrected version

The cell looked at: C1.

Excel shows: none

How to avoid it

Always give a third argument to FILTER. Nobody can tell in advance that there will be at least one match.

Questions

This is an independent guide. It is not connected with Python, Microsoft, Google, GitHub or the Git project. Product names belong to their owners. Examples were run on 13 November 2026 in a practice folder or a blank workbook; your version may word a message slightly differently.