Continuing equation a set number of times

T

Tim

I want to have an equation continue a set number of times defined by a cell
that I have above it in the worksheet. The cell defines the number of years
that I will be forcasting for, and I want to have a few lines down the years
counted out in a row 1,2,3 etc to the eventual number entered earlier. In
the end I want an excel sheet that I can use multiple times for different
numbers of years be they 5 or 8 and then use the year numbers to put actual
years etc etc.

Thanks for your help!
 
T

Tim

After thinking about it for some time I have found my answer. It involves
three IF Statements together. Though Im sure there is an easier way here is
what I am doing and it works quite well.

Have an imput for Starting Date
Have an imput for Period to extend

For Year Number Start with a key intered 1, ad for year have the first year
referenced to starting year.

Where year number would be 2 enter an equation:

IF(previous cell='','',if period to extend cell - previous cell >=1,previous
cell+1,""))

when you have this entered you can extend it out accross the row as long as
you would like. What it does is count up numbers to whatever number the
period to extend cell has.

Below that if you want (as I did) to have the years then match it you can
enter an equation similar to this:

If(the cell above="","",IF(cell to left of above+1<=period to extend
cell,(starting Date+above cell-1),""))

This probably is a bit confusing. Ill include what I had just to give you a
legend.
K5 was my start date
K6 was the period to extend to

my year number equation was:
=IF(D14="","",IF($K$6-D14>=1,D14+1,""))

My Year equation was
=IF(E14="","",IF(D14+1<=$K$6,($D$15+E14-1),""))

Hope that works for you! I found it really neat, but if there is any easier
way to do it please tell me!!!

~Tim
 
Top