Excel: IFNA & IFERROR Functions

IFNA

IFNA function is a simple way to handle #N/A errors specifically without catching other errors. You can use the IFNA function to trap and handle #N/A errors that may occur in formulas that perform lookups with MATCH, VLOOKUP, HLOOKUP, XLOOKUP, etc. The IFNA function returns a custom result when a formula generates the #N/A error, and a normal result when no error is detected. IFNA will only handle #N/A errors –other errors will still display. 

Arguments of IFNA Function:

• value - The value, reference, or formula to check for an error.
• value_if_na - The value to return if #N/A error is found.
• IFERROR: IFERROR function in excel returns a custom result when a formula generates an error, and a standard result when no error is detected.

IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements. IFERROR function is used to catch errors and return a more friendly result or message when an error is detected. When a formula returns a normal result, the IFERROR function returns that result. When a formula returns an error, IFERROR returns an alternative result. IFERROR is an elegant way to trap and manage errors. The IFERROR function is a modern alternative to the ISERROR function. Use the IFERROR function to trap and handle errors produced by other formulas or functions. Like #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Arguments of IFERROR function are:

• value - The value, reference, or formula to check for an error.
• value_if_error - The value to return if an error is found.