What is ISNA function in Excel?
The ISNA function is one of the Information functions of Excel.
It Checks whether a value is=N/A and returns TRUE or FALSE.
We can find this function in Information of insert function Tab.
How to use ISNA function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ISNA function
6. Then select ok.
7. In the function arguments Tab you will see ISNA function.
8. Value is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.
9. You will see the results in the formula result section.
Examples of ISNA function in Excel
ISLOGICAL related functions
- Use ISERROR function to check whether a value is an error, and returns TRUE or FALSE.
- Use ISFORMULA function to check whether a reference is to a cell containing a formula.
- Use ISLOGICAL function to check whether a value is a logical value, and return TRUE or FALSE.
- Use ISNUMBER function to check whether a value is a number, and return TRUE or FALSE.
