NEED TO GET RID OF "N/A" FROM FORMULA RESULT.

[garyt153]

I have several other formulas that rely on the result of this formula. =IF(SUM(AC49-AD49=0),"",(SUM(AC49-AD49)))

Everything works fine, except when the cell "AC49" is N/A - then this formula returns #VALUE and then subsequent formulas dont work.

Is there a way to modify the above formula so that when cell AC49 shows N/A - this formula can return a blank cell - not #VALUE and nor N/A.

Many thanks

 

[RobOrBob]

Cubist is right. If any doubt about either cell you could test both:
=IF(OR(NOT(ISNUMBER(AC49)),NOT(ISNUMBER(AD49))),"",IF(AC49-AD49=0,"",AC49-AD49))

 

[Peter_SSs]

Is there a way to modify the above formula so that when cell AC49 shows N/A - this formula can return a blank cell - not #VALUE and nor N/A.

If the only problem is the #N/A in AC49 What about this?

=IF(IFNA(AC49-AD49,0)=0,"",AC49-AD49)

If AD49 (or AC49) contains a formula that could return "", then

=IFERROR(IF(AC49-AD49=0,"",AC49-AD49),"")