ISNA function - The function returns True if the value is an # N / A error value in Excel

ISNA function: The function returns True if the value is an # N / A error value in Excel. Syntax: ISNA (value)

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 1ISNA 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 2ISNA 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 3ISNA 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 4ISNA 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 5ISNA 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!

5 ★ | 2 Vote