Help on using scenarios in Excel

[tjthomps23]

Hey guys,



Need some help with a scenario situation in excel. I’ll try to give an easy example below. The first 3 lines are a simplified cashflow. I want to use a single cell to change the values from scenario 1 to scenario 2, and etc. for as many scenarios I want to test. So if the scenario 1 values together can represent “1”, I want to type “1” into a cell in the sheet and have all the values update in the CashFlow Example appropriately.



Please HELP! Thanks



CashFlow Example

Income 1 – X

Income 2 – Y

Expenses – Z



scenario 1: income 1=10000, income 2=2000, expenses=2000

scenario 2: income 1=20000, income 2=4000, expenses=3000

By: Teej