How to Use the IFNA Function in Excel
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
More information: support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461
Other functions
Returns TRUE if all of its arguments are TRUE
Returns the logical value FALSE
Specifies a logical test to perform
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
Reverses the logic of its argument
Returns TRUE if any argument is TRUE
Evaluates an expression against a list of values and returns the result corresponding to the first matching value If there is no match, an optional default value may be returned
Returns the logical value TRUE
Returns a logical exclusive OR of all arguments