Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All:
I was wondering if someone could help me with this. I created a model that returns an output- the sum of the profits from 12 months. The profit for each month depends upon 2 variables which I keep in 2 cells which I have given names- churn and month_churn_begins. I would like to create a table which will have on the horizontal "Axis" different churn rates and on the vertical "axis" different month_churn_begins values. For each combination of churn rate and month_churn_begins value I would like to put in the sum of the profits. Is there any way I can plot a formula into the values of this table so that I don't have to manually change the 2 variables and copy each sumofprofits output by hand into the table? Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sensitivity analysis | New Users to Excel | |||
Sensitivity analysis | Excel Worksheet Functions |