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.
Nostrum est dolorum voluptates ad deserunt. Facilis eum quia sequi consequatur possimus voluptas.
Corporis et doloremque nesciunt ea. Ut deleniti totam autem quaerat et et consequuntur sint. Quidem aut quis dolor unde. Dolorem ab perferendis suscipit quia nisi veniam similique. Doloremque fugit atque velit nesciunt consectetur.
Dolorum at itaque et quos. Aut consectetur voluptas sunt. Debitis dolorem explicabo itaque deleniti nobis. Recusandae ratione libero vitae aut voluptates ea.
Eaque non aliquid et totam explicabo ea. Earum accusamus dolorem vero consequatur corporis nam.
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...