Returns a specified value if a formula evaluates to an NA error; otherwise, it returns the result of the formula.
Sample Usage
IFNA(C1,"NA error in cell C1")
Syntax
IFNA(value, value_if_na_error)
- value - The argument that is checked for an NA error.
- value_if_na_error - The text to display in the cell as the link or a reference to a cell containing the label.
Examples
IFNA(C1,"NA error in cell C1") returns the value of C1 if there is no NA error. If there is an NA error, it returns the string: "NA error in cell C1".