What's wrong with my formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It's giving me an error on the "10".

It only started giving me an error after I added the
if(abs(G3-E3)>10),"Text","")


=IF(D3<>F3,IF(SUM(E3,G3)>$AC$5,"Text",""),if(abs(G3-E3)>10),"Text","")
 
maybe...

=IF(D3<>F3,IF(SUM(E3,G3)>$AC$5,"Text",""),IF(ABS(G3-E3)>10,"Text",""))

(watch your ()'s)
 
Remove the closing parens just to the right of "10",
then accept Excel's correction offer. This yields:
=IF(D3<>F3,IF(SUM(E3,G3)>$AC$5,"Text",""),IF(ABS(G3-E3)>10,"Text",""))
 
Back
Top