G
Guest
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.
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.