IFNA

LogicalExcel 2016

Return a fallback only for #N/A, letting other errors through.

Syntax

IFNA(value, value_if_na)

Examples

=IFNA(MATCH(A2, list, 0), "New")

→

Related functions

IFERROR ISNA

More Logical functions

AND FALSE IF IFERROR IFS LAMBDA LET NOT OR SWITCH TRUE XOR

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.