IF statement error help.

Closed
jami - Feb 8, 2013 at 04:58 PM
Hello,

I am trying to understand how to remove the error from IF statements.

=IF(B34="DUP",((ABS(G33-G34))/((G33+G34/2)))*100)

How do I remove the FALSE value when I use this formula when the "DUP" does not apply. Either blank or "N/A" in its place.