Syntax. ISNA(value)
Definition. This function returns TRUE
if the value argument is evaluated to the #N/A error. Otherwise, the function returns FALSE
.
Arguments
value (required). The expression (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name) that you want to check.
Background. This function is one of the nine IS() functions that return a logical value depending on the argument. The argument of the IS() functions is not converted for evaluation. This means that a string consisting of a number is interpreted as a string (not as a number).
Example. If you use the VLOOKUP() or HLOOKUP() function, a search term might not be found in the first column (or row) of an array, and the #N/A
error is returned. To avoid this, use the following formula:
=IF(ISNA(VLOOKUP(B76,D76:E78,2,FALSE)),"not found",VLOOKUP(B76,D76:E78,2,FALSE))
This ensures that only the #N/A
error is replaced by a “not found
” message and all other errors are displayed as usual.
Sample Files
Use the IS-functions worksheet in the Information.xls or Information.xlsm sample file. The sample files are found in the Chapter11 folder. For more information about the sample files, see the section titled Using the Sample Files.
18.118.137.67