errors
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.
| error | what it means |
|---|---|
| #DIV/0! | a formula divides by zero or by an empty cell. |
| #N/A | a 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. |