Hello,
I am running an excel with various cases (using a data validation list), with one of the cases saying that we will be able to deliver 'x' amount of revenue in year 'y', by flexing a third cell.
I know that the easiest way to do this would be to do a goal seek each time, however I want to be able to automatically recalculate it based on if the cell says 'Case 3' and on the new inputs that I put in for amount of revenue and number of years.
Is this possible? I've attached a dummy excel for reference.
Thanks in advance!!
Bookmarks