View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steve-o steve-o is offline
external usenet poster
 
Posts: 9
Default Sensitivity Analysis to 2 variables

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.