# Questions tagged [goalseek]

The goalseek tag has no usage guidance.

6
questions

**0**

votes

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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....