Questions tagged [goalseek]
The goalseek tag has no usage guidance.
8
questions
3
votes
2
answers
48k
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....
0
votes
1
answer
744
views
Excel function goal seek
I have 2 questions about the Goal Seek function:
Can I set the "To value:" to equal the value of a specific cell such as U3?
How can I do this function for 5 cells at the same time?
0
votes
1
answer
4k
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
1
answer
683
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 ...
0
votes
0
answers
345
views
Excel Solver Not Finding a Feasible Solution and Goal Seek Not Solving Entirely
I am creating a weekly payment schedule to pay off a loan, and I am using Solver to determine the weekly payment I should make to pay off the loan by a certain date where the payment amount remains ...
0
votes
1
answer
684
views
Goal Seek says there are circular references, but there aren't
I have never used stack-overflow so I apologize if my question is formatted incorrectly.
Currently I am working on an excel workbook that is basically every single financial sheet in a company (...
0
votes
0
answers
477
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
1
answer
844
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....