I have 3 scenarios but they can happen in any order, but I do not know how to re-arrange them based on the orders.
For example
Scenario 1 -> 2 -> 3
starting value
1000
Scenario 1 action 1 add 200
= 1000 + 200 = 1200
action 2 multiply by 2
= 1200 * 2 = 2400
Scenario 2 action 1 multiply by 2
= 2400 * 2 = 4800
action 2 subtract by 200
= 4800 - 200 = 4600
Scenario 3 action 1 divide by 2
= 4600 / 2 = 2300
action 2 add 400
= 2300 + 400 = 2700
However, it can also change order:
Scenario 2 -> 1 -> 3
starting value
1000
Scenario 2 action 1 multiply by 2
= 1000 * 2 = 2000
action 2 subtract 200
= 2000 - 200 = 1800
Scenario 1 action 1 add 200
= 1800 + 200 = 2000
action 2 multiply by 2
= 2000 * 2 = 4000
Scenario 3 action 1 divide by 2
= 4000 / 2 = 2000
action 2 add 400
= 2000 + 400 = 2400
How do I construct an excel spreadsheet which I can change the order of the scenarios and the formulas can still calculate starting from the starting value?
Bookmarks