Syntax: IFNA(Value, Value_if_na)

IF Value is not N/A, it is returned. If it is N/A, Value_if_na is returned.

Syntax: IFERROR(Value, Value_if_error)

This is similar to IFNA(). However, it is used for any kind of error. N/A is for lack of information. Dividing by zero is a error (not N/A).

For example, Price = Profit/Volume

If denominator is 0, you get DIV/0 error. IFERROR(E2/D2, “Incorrect Volume”). E2 and D2 are Profit and Volume.