Please help - I am trying to enter a formula into a cell that compares the
contents of 3 other cells and then enters a result e.g.
if (A1 B1) and (A1 < C3) then value D1 = 1 else value D1 = 0
I have tried using a function but I want something that automaticaly updates
when the data is changed

Thanks

TAM