Excel IF formula circular reference

[thomas.tuzi]

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
500.
- If the value in B10 is changed to Ok, display Ok in B1 and B20 else
200.
- If the value in B20 is changed to Ok, display Ok in B1 and B10 else
200.

Should I be using a different function?

 

[DILipandey]

Dear Thomas,

Functions will not work on these type of problems. Instead you need to look
at the and analyze the query because if you are going to enter formulas in
both of the three cells, then where will the number appear. Think carefully
and then come up with little relaxation in your query. Thanks.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India