What's wrong with my formula?

J

J

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","")
 
D

Dave Peterson

maybe...

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

(watch your ()'s)
 
M

Max

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",""))
 
Top