Evaluates a value. If the value is an #N/A error, returns the specified value..
Description
How To Use in Sheets
IFNA(value, value_if_na)
External Links
Google Sheets - The #NA! Error and How to Fix It
If you get the #NA! error when you're using a formula in Google Sheets, this video will help you to understand what it is and how to fix it.
3Better Sheets Tutorials