Excel errors are converted to Mathematica strings. | #N/A | "#N/A" | | #REF! | "#REF!" | | #VALUE! | "#VALUE!" | | #NULL! | "#NULL!" | | #NAME? | "#NAME?" | | #NUM! | "#NUM!" | | #DIV/0! | "#DIV/0!" |
Excel error mapping. Of these seven errors, four of them may be returned by Mathematica worksheet functions. In this case, the errors have the following meanings. #N/A | error or empty found in inputs | #REF! | connection error or invalid kernel path | #VALUE! | evaluation returned $Failed | #NULL! | evaluation aborted or link closed |
Mathematica worksheet function errors. Notes • In Mathematica worksheet functions, the #N/A error effectively suppresses evaluation when an error occurs upstream in a chain of dependent formulas or until all inputs have been provided. To allow a range containing empty cells or errors to be evaluated, you can use the DATA function. DATA(range) specifies range is a data range that may contain empty cells or errors. You can then handle the empty values and errors in your Mathematica code. |
