If there is an error in a formula, the App or Excel returns an appropriate error, depending on the nature of the problem. Commonly occurring errors are:
If these errors appear in your app, they must be corrected in the data source. A different behaviour between app and data source can be caused by the fact that a function is not supported in our framework. Helpful articles on this topic are Incompatible formulas between Google Sheets and Microsoft Excel and Do's and Don'ts for your Excel Spreadsheet
#N/A
The error #NV stands for "no value available" or "not available". This can occur, for example, with reference functions if the value searched for is not available in the data. The error is also output if the error #NV in is used for further calculations.
=#N/A+A3 -> #N/A
#NULL!
The error #NULL! indicates errors with the references in a formula. For example, if a space is used instead of a colon to indicate a range, Excel interprets this as a space and calculates the intersection. If there are no overlapping ranges, Excel returns #NULL!
#DIV/0!
#DIV/0! indicates that the formula is divided by 0.
#VALUE!
The error #VALUE! is issued if an argument of an incorrect variable type is passed. However, not all functions return this error, some functions ignore the unsuitable arguments. For example, the formula =SUM("text") returns the error #VALUE! However, if "Text" is in cell A1, =SUM(A1) returns 0.
#REF!
If cells are deleted in Excel, references to this cell are replaced by the error #REF! This error can also occur when entire worksheets are deleted or the reference was calculated but does not exist.
#NUM!
Excel displays this error if a formula or function contains invalid numeric values.
#NAME?
The error #NAME? indicates, among other things, that Excel cannot find a reference to a named range. This usually happens if you mistyped a function name. Excel will then find neither a function nor a named range "SUM" and output this error accordingly.
Comments
0 comments
Please sign in to leave a comment.