Tagged: ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • July 3, 2019 at 10:56 am #13557
    Anonymous
    Inactive

    Thanks for the tutorial on adding a circuit breaker to models with circular references. If I were to incorporate one into my own model, how would I know where to add the conditional formula IF(circuit breaker=”on”,1,…)? The video states that it needs to added to a couple different formulas to work properly but how do you know which formulas to apply it to if the whole sheet reads #VALUE/#REF?

    July 3, 2019 at 11:31 pm #13587
    Michael Belasco
    Moderator

    Thanks for the question and it’s a really good one. At a high level, the answer is you need to input the circuit breaker formula wherever there is a circular reference until they have all been eliminated when the circuit breaker turns on. Below is how I go about the process of finding these cells in a sea of cells with errors. I hope this is helpful and if any of the video is unclear, please let me know.

    Thanks,

    MB

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.