goal seek

1. Goal Seek not working properly

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...
2. Solving for Future Value Given XIRR Target: .GoaSeek VBA; perhaps =LOG()?

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...
3. VBA goalseek range

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?
4. Multi Value Solver update weekly - for KRA measures - What can I acheive

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...
5. UDF to solve or invert formula

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...
6. Age of Queue each day based on 1 assumption

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...
7. RATE function for non annuity cash flows

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...
8. Goal Seek Macro using Function() for Amazon Pricing

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...
9. Iterative Calculations

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...
10. Running A 'Goal Seek' on evnet for specfic cells (range)

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)...
11. Goal Seek, Daily goals to meet weekly targets

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%...
12. New to VBA! Goal seek macro with a variable cell reference

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...
13. Goal Seek Issue

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...
14. Goal Seek Macro - ignore blank cells in ranges

I have been using the following Macro to set prices for a given Profit on Return. (sounds somewhat unnecessary as I could use a formula the other way around - however it is necessary and this is the favored way of doing things) However with a list of products there is inevitably a subheading...
15. VBA macro for goalseek entire column

I'm trying to use a macro to produce a value in a column of cells, based on 2 other cells in the same row. I'm obviously missing something as I keep getting a 1004 error "reference not valid." Code: Sub Macro1() Dim i As Integer For i = 2 To 23 Cells(i, 18).GoalSeek Goal:=Cells(i, 2).Value...
16. Automatic goal seek for certain cells

Hi I couldn't find a similar topic for this question, so sorry if one already exists. I am trying to do a goal seek 100 times if a certain condition is true. The first goal seek is on cell R104, where the target value is R103 and the variable cell is Q104. The next goal seek is cell R110...
17. Goal seek VBA with IF statements

I am trying to run an automatic goal seek via a button and am not sure what the Macro <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250...
18. Goal seek VBA with embedded IF statements

I am trying to run an automatic goal seek via a button and am not sure what the Macro VBA code should be. The forumla should ideally auto calculate (without having to press the button if possible). The calculation is to determine an initial loan repayment amount (cell I10). Depending on the...
19. Solver, Goal Seek, Multi Goal seek or VBA

Hi All, I have a financial model that I use to report and forecast past and future results. It is set up over multiple pages, starting with an inputs page where all model inputs are input and an actuals page for all actual results to be input as they occur. Other pages provide information...
20. Solver isn't quite enough..

Hello members of this great forum. First time post but longtime viewer :p As you could get; I have a problem.. I have 300 lines of products, i'll take MILK as an example. I need 13,3 liters of milk, and they sell them in 2 quantities; 5 liters and 1 liters. As you could guess i should buy...

This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...