Using Excel Circular References To Do Calculations
Вставка
- Опубліковано 3 лют 2021
- This video shows you how to use the Excel Circular References feature to perform iterative calculations. These are calculations where two or more cells are inputs to each other - e.g. cell C5 is an input to the formula in cell C9, and cell C9 is also an input into the formula in cell C5. This demo uses the example of a company's pre-tax and post-tax profit.
Thank you so much! This was incredibly clear and helpful
Solved my problem another video couldn't, thank!
Thank you. This solved my problem and was such a simple solution. So grateful.
very good mate. thanks for the contribution, its the first time i have encountered this method; however i confront this type of problem due to a mistake in my calculations at work so far its always good to know
Thanks, this is the first time I found circular reference useful, all this time I was wondering why Excel has this.
God Bless you my friend. This solved my problem.
Thank you so much , you just saved me hours of time!
God bless you. This was so helpful
THANK YOU!
So, fundamentally it's good to know how iterative calculations work.
Is it possible to apply the circuit breaker technique to one specific tab or even specific range on one worksheet ? The key is to avoid missing other potential circular loop error
Thx
thank you! you saved my ass
That's certainly a way to