I stumbled across the forum while looking for an answer for this issue.

Thanks in advance, and looks like I will be spending alot of time on this forum!

I want to use the if Then function, for:

I cell A1< A10 and A1< A15 and A1< A20 then, 1 for true and 0 for false.

Seems like it should be possible but can't get it to work.

Thanks