circular reference question

  • Thread starter Thread starter Georgeh
  • Start date Start date
G

Georgeh

I am trying to calculate answers that use the answers from other
calculations. Is there a way to do that without getting errors?
 
Please give details: formulas, values and results.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I am trying to calculate answers that use the answers from other
| calculations. Is there a way to do that without getting errors?
 
As Niek has asked, it's probably a good thing to see the formulas you're using.

You CAN turn off the checks for circular references via:
Tools | Options | [Calculation] tab and check the Iterations option
This is rather dangerous thing to do because it will completely hide any
unintentional circular references you may either already have set up or may
set up in the future.

Quite often there is a solution that can be worked out that doesn't involve
a circular reference, and that is definitely more desirable - but to begin to
figure out such a solution, the formulas in use would have to be seen.
 
Back
Top