# #CALC!

the calculation engine cannot produce the requested array.

## what it means

The formula is valid but asks for something the array engine cannot represent — most often an empty array, or an array nested inside another array.

## common causes

- a filter that matched nothing and has no fallback
- a formula that would produce an array of arrays
- an array operation the engine does not support

## how to fix it

- give the filter an if-empty argument
- flatten the calculation so it returns one array, not nested ones
- compute the intermediate step in its own cell

## related

#SPILL! · #VALUE!

## navigate

- [all error values](https://deepcalc.com/errors.md)
- [function index](https://deepcalc.com/functions.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/errors/calc