Excel IF formula circular reference

Giganews Newsgroups
Subject: Excel IF formula circular reference
Posted by:  thomas.tu…@gmail.com
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
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?

Replies