Site icon ExcelNotes

How to Use IFNA Function

The IFNA function returns the value you specified when a formula evaluates to the #N/A error, otherwise, the function returns the results of the formula.

Formula:

= IFNA(value, value_if_na)

Explanation:

– Value is required, the argument to check whether it is #N/A error.

– Value_if_na is required, the value to return when the formula evaluates to the #N/A error.

Example 1: Checks for the #N/A error in the cell A2, which is 50. The function returns 50.

Example 2: Checks for the #N/A error in the cell A3. When A3 is #N/A error, the function returns "ERROR".

Download: IFNA Function

Exit mobile version