Formula

  • Thread starter Thread starter TAM
  • Start date Start date
T

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
 
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
 
Back
Top