thank you. that works much better then the nested if statments i used. It
will be a huge help.
Mike

"John Michl" wrote:

You can use the AND function. Try =AND(B2100,B2<400) in cell C2 of
your example. Then copy it down.

- John