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