The following article introduces you to the ISNA function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is an # N / A error value in Excel.
Syntax: ISNA (value)
Inside:
- value: The value you want to test is a # N / A error value , is a required parameter.
Attention:
- The function returns True if the value is an # N / A error value and vice versa returns a False value .
For example:
Determine where the values in the value are # N / A error values .
- In the cell to calculate enter the formula : = ISNA (C6)
- Press Enter -> return value is:
- Here, cell value C6 is not an # N / A error value, so the function returns False.
- Similarly copying the formula for the remaining values results:
- There is only error # N / A, the function returns True value , the rest of other error values return false.
Above are instructions and some specific examples when using the ISNA function in Excel.
Good luck!