Learn How to Use Microsoft Excel ISNA Function

Microsoft Excel ISNA Function

The main function of the Microsoft Excel ISNA function is to test for the #N/A error. That means with the help of the ISNA function you can able to get the return value as the TRUE if the cell contains the #N/A error and FALSE if the cell does not have #N/A error or any other type of value or error. You can also use the ISNA function with the IF function to test for an error and display a message when it appears.

Return Value of ISNA Function

The return value will be logical TRUE or FALSE.

Syntax of ISNA Function

=ISNA(value)

Where the arguments:

value: It is the value to check for a #N/A error.

How to Use Microsoft Excel ISNA Function?

The main function of the Microsoft Excel ISNA function is to test for the #N/A error. That means with the help of the ISNA function you can able to get the return value as the TRUE if the cell contains the #N/A error and FALSE if the cell does not have #N/A error or any other type of value or error.

It should be noted that ISNA is part of a group of functions called the "IS functions", which are often used to test the result of formulas for errors.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel