Forum Discussion
Excel - avoiding a circular calculation
I have a fixed budget to buy a property. That budget has to cover the purchase price, but also the costs of purchase such as finance and tax. What I want to know is how much do I have for the act...
Hello @ Funkgroover
I guess I can offer you these resources because I am not sure exactly how your worksheet is laid out:
https://support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123
https://spreadsheeto.com/circular-reference/
If you could show us the formula that would be a good starting point.
I guess I can offer you these resources because I am not sure exactly how your worksheet is laid out:
https://support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123
https://spreadsheeto.com/circular-reference/
If you could show us the formula that would be a good starting point.