TAM,

put the following formula into D1
=IF(AND(A1B1,A1<C3),1,0)

It should update automatically. If not make sure that the automatic is
selected in Tools - Options and under the Calculation tab

Dan E

"TAM" wrote in message ...
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