IFNA

Returns value if not #N/A, otherwise alternate.

Excel: Verified match
Google Sheets: Verified match
Returns: Any value

Examples

=IFNA(VLOOKUP(E1, A1:B10, 2, FALSE), "missing")

	A	B
1	10	2
2	20	4
3	30	6
4	40	8
5	50	10

Result 0

Syntax

IFNA(value, value_if_na)

value: any required
value_if_na: any required

Errors

#ERROR!: =IFNA(1,2,3)

ANDReturns TRUE if all arguments are true. EQTrue when two values are equal. FALSEReturns the logical value FALSE. GTTrue when the first number is greater. GTETrue when the first number is greater or equal. IFReturns one value if condition is true, another if false.