IFNA function

The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula

=IFNA(value, value_if_na)

Example
If the amount in cell “A2″ is divided by the quantity in cell”B2” it returns the #N/A, The IFNA function will return “0”, otherwise, it returns the result of the equation.
=IF(A2/B2,0)

• Type “IFNA(=”
• Click “fx” in the formula bar.
• In “value“, click on cell “A2”, type “/” then click on cell “B2”
• In “value_if_na”, type “0”
• Click on “OK”
• Drag from “C2 to C8”