Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I put Goal Seek into a cell formula?
I'm working on a Sales bid template where I need to calculate a unit price
but that price must be equal to a certain profit %. Goal seek will do the job, but the template is to be used by beginning Excel-ers. The problem I have is that I need to have the formula calculate to a certain profit margin %, but I also need to allow for adjustment to that calculated price by the user in case they want to "tweek" the calculated price to see what happens to profit margin % if they move the price up or down. Therefore, my gross Sales dollars must be equal to Price X Units. I just need to calc the starting price in one cell (to equal desired margin %)(A), have a second cell for "adjustment" (B) and a third that is adjusted price (A+B). Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |