Hi

Try
=IF(AND(B2="AD1",E2-$D$23<$D$25),"<",IF(AND(B2="AD2",E2-$F$23<$F$25),"<",""))

Sorry, an extra "" had crept into my formula, and I didn't test it first.

Regards

Roger Govier



G_Chem wrote:

Roger Govier Wrote:


Hi

Try

=IF(AND(B2="AD1",E2-$D$23<$D$25),"<",IF(AND
(B2="AD2",E2-$F$23<$F$25),"<",""),"")


Regards

Roger Govier







Thanks for the reply Roger, this doesn't work (as written above) but it
looks along the right lines of what i'm trying to do.

I'll try playing around with it a bit and see if i can manipulate it.

thanks again.

G.



[/color]