# Formula instead of Goal Seek (is it possible?)

#### daniels012

##### Well-known Member
I have this:
Cell A2 has a value (Goal Seek would be "Set Cell")
Cell A1 is the desired value (Goal Seek would be "To Value")
Cell A3 has a percent (Goal Seek this would be the "By Changing")

So if I have
A2 = 3.27
A1 = 3.50
A3 = 10.23%
I can put the formula anywhere!!!
I want to change cell A2 to equal cell A1 by changing the percent in cell A3

I would really appreciate the help on this.

Michael D

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### DRSteele

##### Well-known Member
Nobody can help because we can't see how the numbers are related. Provide the formulas and some more information.

#### daniels012

##### Well-known Member
DRSteele,
Thanks for your reply.
I am trying to to create a formula to do what the "Goal Seek" tool does under the Data menu.
When you use the "Goal Seek" tool in Office you don't have formulas, it just figures it for you.
In words here is what I would like:
I have a value of \$3.27. I would like to make that value \$3.50 by changing the percent in cell A3

Hope that is clearer.
Thanks

#### shg

##### MrExcel MVP
For Goal Seek to work the "set cell" (A2) must contain a formula that includes the changing cell (A3) as a precedent. So what is the formula in A2?

Last edited:

#### daniels012

##### Well-known Member
ADVERTISEMENT
shg,
Thank you for your reply.
The formula in A2 is B4*B8

Michael

#### DRSteele

##### Well-known Member
You don't seem to understand. What's needed for us is to see the algorithm that produces all the figures, like your a2, b4, b8. Only then can we deduce a formula.

#### West Man

##### Well-known Member
The value in A2 is solely determined by the values in B4 and B8. Unless either b4 or B8 are dependent on A3 or dependent on cells that are dependent on A3 you are out of luck. If there is a dependency we need to know the formulas in those cells.

Replies
8
Views
388
Replies
5
Views
101
Replies
1
Views
198
Replies
1
Views
676
Replies
3
Views
365

Threads
1,195,942
Messages
6,012,428
Members
441,699
Latest member
tnlbado

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

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