Forum Home
Press F1
Thread ID: 37131	2003-08-29 07:03:00	Excel Goal Seek	jestuart (1592)	Press F1

Post ID	Timestamp	Content	User
171555	2003-08-29 07:03:00	Hi I am wanting to write a spreadsheet that use the "Goal Seek" function, but have the formula that "Goal Seek" uses in the spreadsheet rather than using "Goal Seek". Where can I find the formula Can anyone help??? John	jestuart (1592)
171556	2003-08-29 13:16:00	> I am wanting to write a spreadsheet that use the > "Goal Seek" function, but have the formula that > "Goal Seek" uses in the spreadsheet rather than using > "Goal Seek" . Where can I find the formula Hi John, Ummm, you might want to try to reword this a little, as I'm somewhat confused as to what you've just said - I've read it through 3 times now and I don't really follow what you're wanting... maybe I'm tired I dunno. Any chance you could explain yourself a little clearer please? :) Mike.	Mike (15)
171557	2003-08-29 20:02:00	Are you saying that you want to use an interative formula? robo.	robo (205)
171558	2003-08-30 01:10:00	> Hi > I am wanting to write a spreadsheet that use the > "Goal Seek" function, OK > but have the formula that > "Goal Seek" uses in the spreadsheet rather than using > "Goal Seek" . Where can I find the formula This is where its confusing. So you mean you dont want to use the dialog box that pops up when you use goalseek, but use a formula instead. From my knowledge, Goal Seek isnt a formula per se but is a built in macro. Thats why a box comes up to ask you for the variables (which amount to seek, cell to change etc) rather than a normal formula. Macro's can be written that use this functionality however, but you will have to be very specific in what you want to achieve. This is quite an advanced Excel question (to me anyway) so you may have better luck posting on an Excel specific message board like Mr Excel (www.mrexcel.com) to get a wider range of answers. cheers Parry	parry (27)
1