- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2009 March
- Excel IF formula circular reference

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?

- RE: Excel IF formula circular reference posted by DILipandey on Mon, 23 Mar 2009