View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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