Buzz
Apart from ISNA Function in Excel, validating if a value is #N/A. Readers can explore additional articles on Mytour to gain a better understanding of other Excel functions such as FORECAST.ETS.SEASONALITY, and Round function in Excel.
ISNA Function in Excel
Excel Error #N/A
Excel Error #N/A occurs when the value is not available for your formula.
For example, if the VLOOKUP function is requested to look up the value 10 in a spreadsheet column, but no cell contains the value 10, then the function will return the #N/A error message.
Description of ISNA function in Excel, checking if a value is #N/A or not
The Excel ISNA function checks whether the provided expression (or value) returns the Excel #N/A error or not. If it does, the function returns TRUE; otherwise, it returns FALSE.
The syntax of the ISNA function in Excel is as follows:
ISNA( value )
Where the value argument is the value or expression to be checked.
Example of ISNA function in Excel, checking if a value is #N/A or not
The following spreadsheet illustrates the ISNA function in Excel, used to check various values and expressions.
Formula:
Result returned:
In the example above using arguments including:
- Values in cells B1 - B3.
- Expressions in cells B4 and B5.
- Cell references in cells B6 - B8.
Some notes in the example above:
Although the expression in cell A7 is an error, it is not #N/A error, so the ISNA function in cell B7 will return FALSE.
In cell B5, the VLOOKUP function cannot find the value 10 in column A in the spreadsheet, the function returns #N/A error. Hence, the Excel ISNA function will return TRUE.
This article by Mytour introduces you to the ISNA function in Excel, which checks if a value is #N/A or not. For more information and examples about the Excel ISNA function, readers can visit the Microsoft Office homepage. In the previous article, Mytour introduced you to the ISBLANK function in Excel, which checks if a cell value is blank or not. If you are interested, feel free to visit for reference.
