% Formula return N/A instead of #DIV/0!

[pattih]

Hi!

I have this formula to calculate a percentage
=IF(ABS(G29/C29-1)>3,"n/m",IFERROR(G29/C29-1,0))

But it is returning #DIV/0 when one or both columns have no value. How do I ret it to return N/A and still keep the first part of the formula. Thank you.

 

[Joe4]

You need to add an IFERROR on the first part of the formula, not the second. You have it on the second division, but not the first.

 

[Scott Huish]

=IF(C29,IF(ABS(G9/C29-1)>3,"n/m",G29/C29-1),"N/A")