ISNA

Formulas / ISNA
Test for the #N/A error.
ISNA(value)
  • value - required, the value to test

Examples

  • =ISNA(B2)

    This returns TRUE if B2 contains an #N/A error. This is because ISNA is used to test for #N/A errors in a cell.

  • =ISNA(A1)

    If you want to test for an error in a cell that contains a formula, you can use the ISNA function. For example, if you entered =B2+C2 in cell A1, you can use the ISNA function to test for any #N/A errors in the result. You would enter the preceding formula in another cell, which would return TRUE if A1 contains an #N/A error.

  • =ISNA(A1:A10)

    The ISNA function can also be used to test for #N/A errors in an array formula. For example, if you have a range of cells that contains a formula, you can use the ISNA function to test for #N/A errors in the entire range. The formula would return TRUE if any of the cells in the range contain an #N/A error.

  • =ISNA(A1)

    You can also use the ISNA function to test for #N/A errors in a lookup function. For example, if you have a VLOOKUP formula in cell A1, you can use the ISNA function to test for any #N/A errors in the result. This would return TRUE if A1 contains an #N/A error.

Summary

The ISNA function is an information function used to check if a cell contains an #N/A! error, which indicates that the data is not available. It can be used with the IF function to test the cell and display a customized message.

  • The ISNA function takes one argument, 'value', and returns TRUE if the cell contains an #N/A error.
  • ISNA will return FALSE for any other value other than #N/A.


Frequently Asked Questions

What is the ISNA function?
The ISNA function is a function in Sourcetable which returns the #N/A error when it fails to find a value it is asked for.
What does the ISNA function look like?
The ISNA function has the syntax: ISNA(value). The ‘value’ is a required argument which is the value that you want to check for errors.
What does the ISNA function return?
The ISNA function returns the #N/A error when it fails to find a value it is asked for.
When would I use the ISNA function?
You would use the ISNA function when you want to check a value for errors. For example, you could use the ISNA function to check a cell for errors before performing calculations.
Are there any other uses of the ISNA function?
Yes, the ISNA function can be used in combination with other functions. For example, the IFERROR function can be used with the ISNA function to replace errors with another value.

Related Functions

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.