#CALC!Excel error guide No upload

#CALC! in Excel — Calculation engine error

#CALC! is a modern Excel error that appears when a dynamic-array calculation cannot be completed — for example, an empty array, a nested array, or an unsupported calculation. Simplify the formula or handle the empty-result case.

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

The short answer

What it looks like

A dynamic-array formula returns #CALC!
The formula involves FILTER, LET, LAMBDA or nested arrays
The error appears only when the source data is empty

Why #CALC! happens

FILTER returns no rows and no if_empty argument was supplied.
A formula tries to create an array of arrays that Excel cannot display.
A LAMBDA or LET calculation returns an unsupported value.
A function receives an empty array where at least one value is required.
A workbook from another application uses a calculation construct Excel does not support.

How to fix #CALC!

1
Give FILTER a fallback
Add the if_empty argument so an empty result returns a readable message instead of #CALC!.
```
=FILTER($A$2:$C$500,$C$2:$C$500="North","No matching rows")
```
2
Simplify nested arrays
Break the formula into helper columns or use REDUCE/BYROW deliberately. If you are combining arrays, make sure the result is a single rectangular range.
3
Test the intermediate values
Use Evaluate Formula or put parts of the formula in separate cells. The first part that returns an empty or nested array is the cause.
4
Check the Excel version
#CALC! is produced by the modern calculation engine. Files that must work in older Excel versions should avoid dynamic-array formulas entirely.

A safer formula pattern

=FILTER($A$2:$C$500,$C$2:$C$500="North","No matching rows")

The if_empty argument prevents #CALC! when no rows match.

Check it in your own workbook

Paste the formula into the free browser tools to see the exact fix without uploading your file. The Error Fixer explains the code, the Formula Checker finds syntax problems, and the Formula Explainer breaks down nested logic.

Open the interactive Error Fixer Check a formula

Related functions

FILTER LET LAMBDA REDUCE BYROW

Frequently asked questions

What does #CALC! mean in Excel?

How do I fix #CALC! in Excel?

Give FILTER a fallback: Add the if_empty argument so an empty result returns a readable message instead of #CALC!. Simplify nested arrays: Break the formula into helper columns or use REDUCE/BYROW deliberately. If you are combining arrays, make sure the result is a single rectangular range.

Why does #CALC! appear only in some rows?

Usually because only some rows contain the trigger: FILTER returns no rows and no if_empty argument was supplied. A formula tries to create an array of arrays that Excel cannot display. A LAMBDA or LET calculation returns an unsupported value.

How can I stop #CALC! from appearing again?

The if_empty argument prevents #CALC! when no rows match. Use this pattern as a guard: =FILTER($A$2:$C$500,$C$2:$C$500="North","No matching rows")

Related Excel error guides

All error codes →

#VALUE!Wrong value type#VALUE! means Excel expected a number, date or logical value but found text, an empty cell or a value from another data type. The fix is to convert the input, remove hidden characters, or guard the calculation with IFERROR.#REF!Broken cell reference#REF! means a formula points to a cell, row, column or sheet that no longer exists. It usually appears after deleting rows or columns, moving a sheet, or pasting a formula into a workbook that does not contain the referenced sheet.#N/ALookup value not found#N/A means a lookup or match function could not find the value. The value may be missing, spelled differently, stored as text instead of a number, or surrounded by spaces. Use exact-match mode and return a clear fallback.#DIV/0!Division by zero#DIV/0! appears when a formula divides by zero or by an empty cell. Excel treats a blank denominator as zero. Check the denominator, exclude blank rows, or return a controlled blank with IFERROR.

Still stuck?

Send the workbook and get the formula fixed

A human Excel expert can repair the formula, explain the cause and return a tested workbook — usually within 24 hours. Fixed quote before work starts, from $15/hr.

Get a fixed quote Ask on WhatsApp

#CALC! in Excel — Calculation engine error

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

Why #CALC! happens

FILTER returns no rows and no if_empty argument was supplied.

A formula tries to create an array of arrays that Excel cannot display.

A LAMBDA or LET calculation returns an unsupported value.

A function receives an empty array where at least one value is required.

A workbook from another application uses a calculation construct Excel does not support.

How to fix #CALC!

Give FILTER a fallback

Add the if_empty argument so an empty result returns a readable message instead of #CALC!.

=FILTER($A$2:$C$500,$C$2:$C$500="North","No matching rows")

Simplify nested arrays

Break the formula into helper columns or use REDUCE/BYROW deliberately. If you are combining arrays, make sure the result is a single rectangular range.

Test the intermediate values

Use Evaluate Formula or put parts of the formula in separate cells. The first part that returns an empty or nested array is the cause.

Check the Excel version

#CALC! is produced by the modern calculation engine. Files that must work in older Excel versions should avoid dynamic-array formulas entirely.