H
hindsight
This is what I am trying to do...
I have two moving parts:
1) I have a given number of years for a particular market share %. i.e.
- 3 years at 4%. Both of these figures may change (i.e. - 5 years @
6%). The market share number isn't the issue, rather the number of
years is the problem.
2) After the last year of given market share, the market share begins
to decrease. Using the example above, in year 4 market share is 80% of
previous year, 60% the year after that, etc.
The problem is I want to make each year dynamic based upon the number
of given years, either using the given market share or the correct
decrease percentage. I have a couple of IF functions, but it is
limited.
Years 2004 2005 2006 2007
3 4% 4% 4% 3.2%
2 4% 4% 3.2% 2.4%
1 4% 3.2% 2.4% 1.6%
I want to incorporate the previous examples, all into one line instead
of the three.
Any ideas?
I have two moving parts:
1) I have a given number of years for a particular market share %. i.e.
- 3 years at 4%. Both of these figures may change (i.e. - 5 years @
6%). The market share number isn't the issue, rather the number of
years is the problem.
2) After the last year of given market share, the market share begins
to decrease. Using the example above, in year 4 market share is 80% of
previous year, 60% the year after that, etc.
The problem is I want to make each year dynamic based upon the number
of given years, either using the given market share or the correct
decrease percentage. I have a couple of IF functions, but it is
limited.
Years 2004 2005 2006 2007
3 4% 4% 4% 3.2%
2 4% 4% 3.2% 2.4%
1 4% 3.2% 2.4% 1.6%
I want to incorporate the previous examples, all into one line instead
of the three.
Any ideas?