Hi -- I'm having a problem with a nested if/then formula and have attached a spreadsheet.
I'm trying to develop a financial forecasting model with three scenarios, named 10, 50 and 90 respectively.
The user should be able to enter into the green cell on the spreadsheet a 10, 50 or 90 to indicate the scenario they want to see.
Then below that is a list of stores along with the scenarios each belongs to. There is a slight trick here. All the stores with scenario 10 also belong to scenario 50 and 90. All of the stores with scenario 50 also belong to 90. But, scenario 90 only includes those stores that have a 90.
I'm trying to fill in the yellow shaded column next to each store. If the store is active then there should be a 1, otherwise a 0. I'm going to use this yellow column to multiply against budgeted sales that I have for each store (not included in spreadsheet). I think it's a nested if/then statement but I can't get it to work.
Thanks!
Bookmarks