Excel IFNA Function
Syntax
=IFNA(value, value_if_na)
Description
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
Example Excel File
Enter your email to receive the example Excel file (link valid 24h).
Become a supporter
—
download instantly, no email