The Solver function can probably do it if you set your limits and costs, then
choose how you want it to calculate.
It's been a while, but I wrote one to change the formula for ice cream based
on least cost while maintaining the right amount of fat solids, non-fat
solids, and other critical items while varying the use of powdered milk (with
each posible fat content and cost) fresh milk (with each posibility and
associated cost), cream, butter, etc.
Solver is powerfull, but you need to plan the variables carefully.
"Scott" wrote:

I have a spreadsheet where I am running different financial scenarios to see
how they impact returns. I also want to be able to say for each scenario
what price I would have to charge for my product to get the base case return.
What would be the best way to get Excel to solve for the price that the
product would be sold for and then output it into a predetermined cell?
Thanks!