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!