deepcalc
DocsErrors

Errors

View as markdown/docs/errors.md Ask Claude about this pageOpens Claude with this page's address

Every error a formula can return, what causes it, and the fix: the same error set Excel and Google Sheets use, evaluated the same way by the deepcalc engine.

#DIV/0!A formula divides by zero or by an empty cell. #N/AA value is not available, usually a lookup that found no match. #NAME?The formula contains text the engine does not recognise. #NULL!Two ranges were intersected but do not overlap. #NUM!A number is invalid or the result is impossible to represent. #REF!A formula points at a cell that no longer exists. #VALUE!An argument or operand has the wrong type. #SPILL!A formula returns multiple values but cannot write them out. #CALC!The calculation engine cannot produce the requested array.