# spreadsheet error values

what each excel/sheets error means, why it happens and how to fix it.

- [#DIV/0!](https://deepcalc.com/errors/div-0.md) — a formula divides by zero or by an empty cell.
- [#N/A](https://deepcalc.com/errors/na.md) — a value is not available — usually a lookup that found no match.
- [#NAME?](https://deepcalc.com/errors/name.md) — the formula contains text the engine does not recognise.
- [#NULL!](https://deepcalc.com/errors/null.md) — two ranges were intersected but do not overlap.
- [#NUM!](https://deepcalc.com/errors/num.md) — a number is invalid or the result is impossible to represent.
- [#REF!](https://deepcalc.com/errors/ref.md) — a formula points at a cell that no longer exists.
- [#VALUE!](https://deepcalc.com/errors/value.md) — an argument or operand has the wrong type.
- [#SPILL!](https://deepcalc.com/errors/spill.md) — a formula returns multiple values but cannot write them out.
- [#CALC!](https://deepcalc.com/errors/calc.md) — the calculation engine cannot produce the requested array.

source: https://deepcalc.com/errors