Excel Function

ISNA

Checks whether value is #N/A error.

ISNA(value)

Arguments

value

Required

Enter an expression such as comparison or calculation.

Practice Preview

show value type/status checks. Use ISNA to Checks whether value is #N/A error. use XLOOKUP(B2,B2:B8,D2:D8) for value. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=ISNA(XLOOKUP(B2,B2:B8,D2:D8))

Practice This Function

Practice in Sequential Mode Back to Function List