Please see attached pic.
I've inserted notes in the workbook to make it easier to understand but I'll write out what I'm trying to do here as well.
I have a number of stores and rents. A number of these have a chance of closing down this year. Some have a 50% chance, some 60%, etc. Some will close in Sept, some will close in Oct etc.
I want to take the rents given on the left hand side of this worksheet, look at the chance of closing down, look at when it would close down, and use this to populate the right side of my worksheet.
So for example if the rent for store A is $1000 and it has a 60% chance of closing in Oct, I'd want the new rent section to show $1000 in rent for the months from now til Sept, and then in Oct - Dec I'd want the rent to show as $600.
How would I do this?
Bookmarks