goal seek

Hi there, Hoping one of you geniuses can help me out here. What I need to find is "x" in the equation: .1 = [b + (x*c)]/[a+x] where "a", "b" & "c" are all numbers based on other formulas that happen in the sheet, so they are always changing but fixed at the time of finding "x". To put that...

Hello everyone! I need a goal seek to run every single time the value in cell F1 does not equal zero. When this cell equals zero, that means my numbers tie, if it does not then I need to create a "plug value" to make that value in F1 equal zero. The cell that needs to change is cell D21. When...

I need a goal seek to run every single time the value in cell F1 does not equal zero. When this cell equals zero, that means my numbers tie, if it does not then I need to create a "plug value" to make that value in F1 equal zero. The cell that needs to change is cell D21. When doing a manual...

Hello everyone, first time poster here. I have been trying to figure out how to write a VBA code that will tell Excel to run a goal seek in the background every time a value on my template I created changes. Please bare with the "random" cell locations as this is a custom template. I need a...

Hello -- I am trying to set up a goal seek macro with the following specs: individual goal seeks needed, for each column I need to set cell c13 to 0 by changing cell c14, and then set d13 to 0 by changing d14, etc. through to column GE. Can you help? Thank you!

So I have a file here where I want to do something. http://www.egr.msu.edu/~lira/computer/EXCEL/PREOS.XLS If we fix P (Cell B8) and want to find where the fugacity ratio (cell H12) is 1 (i.e. system at equilibrium), I need to use solver/goalseek to vary the T (Cell B7) until H12 = 1. The...

Hi All, I am quite new to VBA and currently trying to create a Goal Seek Loop 11 row, skip 50 rows, and then run for another 11 row and so forth until last active cell. For e.g. run goal seek row 20 to 30, skip row 31-84, run goal seek again row 85 to 95, and so forth. I got a code that runs...

I am getting very anomalous results with Goal Seek and suspect that there is a setting wrong somewhere. FWIW, I am getting identical results with two different computers and two different versions of Excel. Here is a simple example of the problem. <tbody> Mean 12.05 StdDev .03 Cutoff...

Hi, clever people. I am building a financial table to find the payoff value for a financial instrument that solves for the cash flow needed in each future period, on a discrete basis, such that an XIRR target is satisfied. Basically, I want to know what the dollar hurdle is to fully pay-off...

I am new to VBA and using Excel 2010. I need to apply a goalseek to each row in range T2:T19698, set to value 0.4, by changing each value in range S2:S19698 Can anyone help please?

Hi Can I please ask for a little help regarding solver as I cannot figure how to use it in this scenario. I have these people and each week their results will update, for example I have filled in wk1 and wk2. Person wk1 wk2 wk3 wk4 wk5 wk6 Bill 48.4 62.3 Mary 71.4 55.3 If I have...

Hello, I have a simple formula, p = (a+b)^n - b^n, but need to find n in terms of a, b and p. Problem is there isn't an exact algebraic solution (at least not according to WolframAlpha), so I need to create a fully automatic user defined function (UDF) that effectively acts a bit like goal...

I am trying to figure out how to automate or simplify a manual report. I was to track the age of queue of items from one day to the next based on an assumption of how many items we can get through. So for example I have 100 items currently at 58, and then 350 at day 57 and so forth. The...

Thank you in advance for your time/help! I have a series of cash flows that take place over the next 40 years (in different amounts and not an annuity) for which I am trying to determine what discount rates will output specific NPVs ($150, $200, $250, and $300). Currently I just run a bunch of...

Hi guys I have made a macro to calculate the sale Price on Amazon Dim seller As Integer seller = Range("c9") Range("C26").GoalSeek Goal:=seller, ChangingCell:=Range("C12") End Sub Where the nett amount payable to vendor is cell c9 than there are calculations which determine the Final...

Hi all, I have a set value in cell B1 that will be changed constantly. Cell B7 has a formula written based on the values of cells B3, B4, and B5. The values in cell B3 and B5 do not change, meaning they are constant and will always be 4 and 10, respectively. Is it possible for Excel to...

To all I have written a simple macro which loops through a range of cell and executes a goal seek (so I do have to do it manually!) Any change to the values in the cells in that range (the 'Set cell' range) is flagged to the user and he must re-run the macro (the set cell must always be =1.0)...

ok I've been trawling through google to find the solution to no avail. id like to find a formula to tell me what i need over the next few days to achieve a target. so.. Target Labour 20% Day Monday Tuesday Wednesday Actual Labour % 25% Target needed%...

Hi, I'm trying to write a relatively basic macro to run a goal seek function: Range(G24).GoalSeek Goal:=0, ChangingCell:=Range("E17") The only complexity is that I would like the "G24" to be variable. So the row which the range() of the goal seek references (row 24 in this case) should be...

I'm about to pull my hair out over this one step in my homework. I've read my assigned textbook chapter on Goal Seek, Scenario Manager, etc... but trying to plug the problem from my instructions into goal seek isn't proving successful. Here's the exact wording: "Use Goal Seek to determine the...