IFNA

  • Updated

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