WorksheetFunction.IfNa (Excel)

Returns the value that you specify if the expression resolves to #N/A; otherwise, returns the result of the expression.

IfNa (Arg1, Arg2)

Dim varIfNa As Variant
varIfNa = WorksheetFunction.IfNa(Arg1:=, Arg2:=)

Arguments

Arg1 - value: Any value or expression or reference

Arg2 - value_if_na: Any value or expression or reference