IFNA

IFNA(arg1, arg2) → { number | string | boolean }

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

Parameters:

Name Type Description
arg1 any

Is any value or expression or reference.

arg2 any

Is any value or expression or reference.

Returns:

Type
number | string | boolean