Questions tagged [goalseek]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
28 views

How to do a reverse goal seek formula in order to solve this equation?

I have created a model whereby I've got the following: Cost (column P) Dealer price (Column S) Current List price (Column T) I've then done some market research and have adjusted List pricing (RRP) ...
0
votes
0answers
120 views

Formula equivalent of Goal Seek function. How to manipulate margins based on Pricing requirements?

I have a cost, two different sets of pricing and therefore two different margins. Thanks to @Jeorje help in my previous post I have been able to work out the percent change required in order to ...
0
votes
1answer
340 views

How to convert Goal Seek to formula?

I have the following formula for working out the profit margin: (Revenue - Cost) / Revenue I am now required to work backwards starting from Profit Margin. I have a column for Revenue change % where ...
0
votes
1answer
620 views

Automated Goal Seek - Excel

I have been using goal seek successfully to back into a known number. This works great with a handful of lines - now I need it for 100s (probably 1000s) of lines. Any help would be greatly appreciated....
0
votes
1answer
593 views

Linear interpolation in Excel 2007

I want to know how I can programmatic use my linear interpolate equation without having the user or myself to use the Goal Seek function in the data menu, well I could use the function but I want it ...
3
votes
2answers
39k views

Is there a way to automate goal seeking formulas in Excel?

I have to use the following formula: =POWER(b,(d+1))-N*(b-1)-1 I need to find b, so every time I run this I have to select the values for d and N, and then goal seek to make b the calculated value....