ISNA function - The function returns True if the value is an # N / A error value in Excel
The following article introduces you to the ISNA function - one of the functions in the information function group is very popular in Excel.
ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 1
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 .
ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 2
- In the cell to calculate enter the formula : = ISNA (C6)
ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 3
- Press Enter -> return value is:
ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 4
- 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:
ISNA function - The function returns True if the value is an # N / A error value in Excel Picture 5
- 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!
You should read it
- ISNA function in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- ISODD function - The function returns True if the value is an odd number in Excel
- ISERROR function - The function returns True if the value is any error in Excel
- ISERR function - Function returns True if the value is any error except # N / A error in Excel
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
- ISNONTEXT function - The function returns True if the value is not a text value in Excel
- ISTEXT function - Function returns True value if that value is text in Excel
- ISREF function - The function returns True if the value is a valid reference value in Excel
- How to use the SUM function to calculate totals in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
May be interested
ISNONTEXT function - The function returns True if the value is not a text value in Excel
ISNUMBER function - The function returns True if the value is numeric in Excel
ISODD function - The function returns True if the value is an odd number in Excel
ISREF function - The function returns True if the value is a valid reference value in Excel
ISTEXT function - Function returns True value if that value is text in Excel
N function - The function returns the numeric value converted from any value other than the error value in Excel