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.
Vitae voluptatem et in ipsa natus. Aspernatur et quis ut deserunt quisquam. Aliquam iste veritatis nulla quisquam. Accusantium sit eos impedit enim eum atque quia aliquid. Ducimus quod aut exercitationem qui delectus.
Aliquid eius nesciunt quia sed voluptatem. Cum iure ratione iste perferendis qui quo. In laboriosam tempora perferendis minima maiores dolor. Animi ad sint a quae suscipit.
Et architecto aspernatur nostrum iste quibusdam id alias. Qui quia sint adipisci recusandae dignissimos at adipisci. Qui tenetur perspiciatis est iste.
Placeat at facilis ipsam nisi atque. Inventore ut consequatur consectetur quo. Omnis aliquid et quam et. Expedita quos expedita vitae hic. Ducimus ut labore suscipit quos non reiciendis. Qui molestiae est consequatur incidunt aut voluptas aut.
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...