Thanks for replying

... was . . IF(AND(T(C1)<C1,C10),"yes","no")
... will leave it to Glen to follow through further with you

Btw, just curious why my suggestion didn't work (it was lightly tested ok
here). Which values in col C over at your end failed to return the desired
outcome when you tried it? Could you paste some of these in reply here?
Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---