Goal seek whilst using circular reference

shaun111

New Member
Joined
May 12, 2008
Messages
30
Hi All,

I was wondering if you could assist. I am currently using a model which has an iterative circular reference in order to calculate a debt size.

I would like to use the model to goal seek a revenue price input in order to achieve a certain return. The goal seek will not solve because of the circular and keeps giving me the circular error box, despite iterative calculation being on.

Is there any way around this? Any recommendations will be very helpful.

Thanks,
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Hi,

I suppose you already read these:

link1.

link2.

also what version of Excel are you using, this may be helpful for the forum to assist you.

;)
 
Upvote 0
Hi,

Thanks for the response. I'm using 2007. Thanks for the links, but I'm not sure they can help me around this particular issue. I'm comfortable using the iterative process but I just can't seem to get the goal seek function to work when the model is set to iterate.

What I'm looking for is a way to use goal seek when iteration is on in order to solve for a specific output. Not sure if there is a VBA guru that can help?

Thanks gain.
 
Upvote 0

Forum statistics

Threads
1,212,096
Messages
6,105,942
Members
447,985
Latest member
gigi11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top