MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Problem With Cricular Reference

  Asked By: Ira    Date: Dec 17    Category: MS Office    Views: 600

I keep getting this annoying message from excel warning me that I've made a
circular reference.
as per help definition: it's "a formula that directly or indirectly refers back
to the cell that contains the formula."
The formula i'm using is a very simple if statement like =IF(D4="Key",B4,"")

It's supposed to check if Cell D4 has the word "Key" then it would grab the
value of B4 otherwise it would remain blank
The formula works fine and gives me the output I want, I'm just trying to figure
out how the reference is circular .... I'm not refering back
to the cell containing the forumla! Any Ideas?



3 Answers Found

Answer #1    Answered By: Myrtle Wilson     Answered On: Dec 17

What cell  is the formula  in??????

Answer #2    Answered By: Cain Smith     Answered On: Dec 17

And equally important, what is in cells D4 and B4 that get referred to
by the formula? Do they contain formulas also?

Answer #3    Answered By: Aaeedah Khan     Answered On: Dec 17

The formula  is not located in any of the cells being referenced (D4 or B4)...
lets say it's in E4.
One thing I forgot to mention... the cell  being checked by the if statement  is a
Data Validation Cell, I think
that was my problem, cause I tried the formula again on a static Cell with the
same value and it removed the Circular reference  warning.

Didn't find what you were looking for? Find more on Problem With Cricular Reference Or get search suggestion and latest updates.