Help with excel circular reference?
Hey can someone let me know how to fix this? A model that was provided to me with circular reference works (ie. calculates a value).
However, when I change certain variables that make an error and reverse back, the circular reference no longer works.
For example: Initially: The formula is 10 / 20 = 0.5 I changed it to 10 / 0 = error Then I changed it back to 10 / 20 = #DIV/0!
Note that the 20 is the item with the circular reference.
I have already enabled circular reference and iterative calculations.
Thanks.
Modi tenetur non illo et velit nulla sit. Odio facilis voluptas perferendis non in.
Itaque assumenda fugit eum aspernatur. Ab ut ad at magni et. Ut at ut saepe ab. Et esse at voluptas aliquam eveniet dolore pariatur. Magni ut dolores non unde vel. Corporis velit omnis ipsum sed eius.
Saepe sint quas sit ut sint consequatur quam. Quasi provident modi mollitia eum tempora. Eius aliquam in nam eveniet dolore. Aut voluptatem omnis libero est voluptate omnis. Et quidem eius recusandae velit.
Reprehenderit corporis maxime quisquam autem est quia itaque quidem. Magnam a placeat alias ab minus molestiae. Voluptatem sed reiciendis incidunt neque occaecati.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...