Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal seek on more than one cell
I am using Excel 2007, but I also email my spreadsheets to users that have
only 2003. I have set up a spreadsheet to calculate the highest price we can bid for foreclosed properties. I use a cash flow analysis in order to calculate the highest purchase price that will enable us to rent the properties at a break even. After I input the income and expenditures, I come down to a net cash flow figure. I use goal seek to calculate the purchase price that will yield a cash flow of zero. This process works perfectly in all cases. Problem is, each column represents one property, and I have a bunch of potential acquisitions. Goal seek works on only one cell at a time. Is there any way of making goal seek (or a functional equivalent) work for all my columns? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal seek on more than one cell
Yes, use Solver rather than Goal Seek
For problems other than max-min type, it can be set up to find multiple solutions best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "David Wess" wrote in message ... I am using Excel 2007, but I also email my spreadsheets to users that have only 2003. I have set up a spreadsheet to calculate the highest price we can bid for foreclosed properties. I use a cash flow analysis in order to calculate the highest purchase price that will enable us to rent the properties at a break even. After I input the income and expenditures, I come down to a net cash flow figure. I use goal seek to calculate the purchase price that will yield a cash flow of zero. This process works perfectly in all cases. Problem is, each column represents one property, and I have a bunch of potential acquisitions. Goal seek works on only one cell at a time. Is there any way of making goal seek (or a functional equivalent) work for all my columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I put Goal Seek into a cell formula? | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek - reference a cell for "To value" field? | Excel Worksheet Functions |