What's wrong with my formula?
 

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(G 3-E3)10),"Text","")

What's wrong with my formula?
 

maybe...

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

(watch your ()'s)

J wrote:

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(G 3-E3)10),"Text","")

--

Dave Peterson

What's wrong with my formula?
 

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(G 3-E3)10,"Text",""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"J" wrote:
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(G 3-E3)10),"Text","")