153 votes
Comments (8)
51report spam
2 years ago
Is there actually a correct way to use it? I always thought it was an error in the formula.
reply
(1)
59report spam
2 years 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)
51report spam
2 years ago
Yeah, you're solving them, but not using them, like the question asks.
reply
(0)
59report spam
2 years 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)
21report spam
2 years 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)
21report spam
2 years 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
2 years ago
I don't even know what this question means! Thus...I voted no.
reply
(1)
59report spam
2 years 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.
Direct Link
Add this poll to your website
(Copy and paste the code below where HTML is accepted)(0) Users Liked This Question
Similar Polls
24 votes