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.