Using the Excel ISNA Function
SummaryThe Excel ISNA function will return TRUE when a cell contains the #N/A error. FALSE is returned for any other value or error type. ISNA can be used with the IF function to test for errors and return a custom message.
Required. A value that will be tested for the #N/A error. Typically supplied as a reference.
Usage NotesISNA will check if a cell contains the #N/A error. If a cell does contain the #N/A error, the function returns TRUE. In all other cases, the function returns FALSE.
ISNA is considered one of Excel's IS functions, which are used to test for errors.
If you have Windows 2013+, use the IFNA function to identify and handle #N/A errors.
ISNA With IF
Use the ISNA function with the IF function to identify errors and return a custom message.