Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |