IFNA google sheets; How to Use IFNA function in Google Sheets?

IFNA function:

The IFNA function evaluates a value. If the value is an #N/A error, return the specified value.

If the evaluated value statement is a #N/A error, the IFNA function in Google Sheets will return a given value. It is the primary intention of this logical function.

Parts of an IFNA function

IFNA(value, value_if_na)


Required. The value to check if it is a #N/A error.

Required. The value to return if the first argument is an #N/A error.

Sample formulas

=IFNA(205, “Na error”)

=IFNA(#N/A, “Na error”)


If value or value_if_na is an empty cell, IFNA treats the cell’s value as an empty string (“”).
If the value is a range reference, IFNA returns an array formula result with one entry for in-the-range reference.


Related functions

IFERROR: Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.