Hi

A B C
1 2 5 TRUE 2
2 7 6 False 8
3 3 8 False -3
4 1 4 True 1
5 8 9 False 6

** I want to know what to type in cell 1C then fill down to 5C.** I am looking for a "TRUE" or "FALSE" answer in C column. In the example above, in order for the result to be TRUE, the value in column D1 needs to be =0 and <=50 and also A1 is < B1. I use excel 97. Thank you very much for your help :-
Tina