Evaluates a value. If the value is an #N/A error, returns the specified value..

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