Microsoft Office Tutorials and References
In Depth Information
IFERROR was introduced in Excel 2007. For compatibility with previous versions, use this formula:
The #N/A error occurs if any cell referenced by a formula displays #N/A.
Some users like to enter =NA() or #N/A explicitly for missing data (that is, Not Avail-
able). This method makes it perfectly clear that the data is not available and hasn't been
The #N/A error also occurs when a lookup function (HLOOKUP, LOOKUP, MATCH, or VLOOKUP) can't
find a match.
If you would like to display an empty string instead of #N/A, use the IFNA function in a formula like this:
The IFNA function is new to Excel 2013. For compatibility with previous versions, use a
formula like this:
The #NAME? error occurs under these conditions:
• The formula contains an undefined range or cell name.
• The formula contains text that Excel interprets as an undefined name. A misspelled function name, for ex-
ample, generates a #NAME? error.
• The formula contains text that isn't enclosed in quotation marks.
• The formula contains a range reference that omits the colon between the cell addresses.
• The formula uses a worksheet function that's defined in an add-in, and the add-in is not installed.