Add this poll to your website
(Copy and paste the code below where HTML is accepted)Comments (8)
49report spam
6 months ago
Is there actually a correct way to use it? I always thought it was an error in the formula.
reply
(1)
54report spam
6 months ago
Often times in excel you need to create a formula which uses Circular Reference, and solve for an outcome. Any formula which is dependent on one variable determined by another variable in the same equation will lead to a Circular Reference. And to solve these formulas all you need to do is to limit the Iterations under the Excel Options button, and then Formula section. Knowing how to solve Circular References can be quite handy.
reply
(1)
49report spam
6 months ago
Yeah, you're solving them, but not using them, like the question asks.
reply
(0)
54report spam
6 months ago
This is how to correctly use them. For any formula which requires variables to be determined by other variables in the same formula - you just limit the number of iterations for the equation to solve it.
reply
(0)
18report spam
6 months ago
Is that the definition of circular referencing though? I thought it was if slot A uses slot B in the calculation but Slot B uses slot A in the calculation - hence the circular property - would be circular referencing.
reply
(0)
18report spam
6 months ago
I have never used that feature in Excel but based on the words and the comments so far, it may seem that circular referencing is an error in logic since it will cause infinite calculation that never ends. At least that's how it is in programming when you use recursion without giving it an ending condition.
reply
(0)
3report spam
6 months ago
I don't even know what this question means! Thus...I voted no.
reply
(1)
54report spam
6 months ago
Does anyone else think excel is like the greatest thing ever? If this makes me a nerd; oh well, you've already seen me comment on Star Wars related matters.
reply
(0)
Login to comment.
131 votes
Direct Link