The function IFNA returns the value you specify if the nested formula resolves to #N/A, otherwise returns the result of the formula.

Syntax:

=Ifna(expression, value if NA)

Expression. Is the function, formula or expression to the be evaluated.

Value if NA. this is the value that will be return in case the expression resulted in NA.