IFNA()

Description

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.

Google Docs Help

3Better Sheets Tutorials

Creating A Dark Mode Theme | Announcing Dark Habits
IntermediateMost Popular
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Deep Inside Dark Habits Google Script
Create a Many to Many Database