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")


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.


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".