Valued Forum Contributor
Workaround for a circular reference required
I have a spreadsheet which should balance but doesn’t so therefore I want to lose the balance as the difference is insignificant.
The problem I have is that this creates a circular reference which I need to find a solution to.
What is the best way to achieve this? I am open to any ideas but it needs to be automated as much as possible.
Currently the spreadsheet totals the budget and target rows – if there is a difference between the two I need to lose this in cell G28
I have attached an example
Re: Workaround for a circular reference required
Have you tested using "Goal Seek"?
Goto tab "Data"-> "What if Analysis" and click "Goal Seek"
Based on your uploaded file
Set cell: G49
To value: 0
By changing: G28
Click "ok" twice
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1