# spreadsheet error values

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

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

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