seek

I want to find the values of a,b,c,d and e if a*5+b*4+c*3+d*2+e*1 = 70 (or any other input value) and a+b+c+d+e = 20 (fixed). any solutions preferably a worksheet function or else a macro is also OK ravi

I am new in excel. I have a question-what is the difference between goal seek feature and iteration? Regards,

How to use Goal Seek to change the period of the loan to limit dollar amount?

Hello, I am working on a spreadsheet that I have a goal seek function to find the optimal number of units based on certain parameters. My problem is that I need to round these numbers up or down depending on which one it is. I found a solution that mostly works but sometimes it does not act...

Hello, I am currently working on a project and I am in need of excel assistance. I have a sheet that has a lot of client data (e.g. name, date of assistance, reasons for seeking help). In another sheet, I am gathering data with regards to all clients. For instance, I want to know how many...

I have the following code, but I would like to have the Goal Seek stop once P22 reaches a minimum of 0. Is this possible? Basically I have a model with two drivers of revenue. And the Goal Seek (aka breakeven) on one of them is 0.00 if the other revenue driver is sufficient. Thus, I do not need...

I am trying to run a breakeven analysis using a Goal Seek. The Goal Seek looks at the NPV, and should put in a new price to change the NPV to 0. However, I would like for the NPV cell to retain the formula rather than change to the hard-coded number 0 every time I run it. Is there something...

Hello,i am trying to do what i thought would be a simple macro but its frustrating me!the basic macro is Range("AI136").GoalSeek Goal:=0, ChangingCell:=Range("AI347")so that goal seek will be ran to change the number in row 347 to make 136=0 the problem is i need this donein each of columns AI:CC

Hello, I wonder if you could help me. (I'm using Excel 2007 on a Vista machine for reference). I have been given a value, which is the output. I have a list of 44 possible inputs. Is there a way where it shows me the combination of the sum of inputs (from the list of 44 inputs) that derive...