Formula

[TAM]

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

 

[Dan E]

TAM,

put the following formula into D1
=IF(AND(A1>B1,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