|Subject:||Excel IF formula circular reference|
|Date:||Sun, 22 Mar 2009|
In cell B1 I have a formula like this: =IF(B10="Ok","Ok",IF
(B20="Ok","Ok",500)) This works fine however, I would like to have a
formula in cell B10 and B20 like this: =IF(B1="Ok",Ok",200). When I
type out this formula, it displays a zero (0) in the field. If I open
the formula function screen it displays the right answer, but not onm
the spread sheet.
Bottom Line, what I am looking for are these results. Currently the
values are B1=500, B10=200, B20=200
- If the value in B1 is changed to Ok, display Ok in B10 and B20 else
- If the value in B10 is changed to Ok, display Ok in B1 and B20 else
- If the value in B20 is changed to Ok, display Ok in B1 and B10 else
Should I be using a different function?