J
jharvey
I have a spreadsheet at the moment that looks like this
yr1 0.97
yr2 2.04 0.08
yr3 2.18 0.16 0.05
yr4 2.23 0.17 0.11 0.10
yr5 2.29 0.18 0.11 0.22
yr6 2.35 0.18 0.12 0.23
yr7 2.41 0.19 0.12 0.24
yr8 2.48 0.19 0.12 0.24
yr9 2.55 0.20 0.13 0.25
yr10 2.62 0.20 0.13 0.25
yr11 2.69 0.21 0.13 0.26
yr12 0.97 0.21 0.14 0.27
yr13 2.04 0.08 0.14 0.28
as you can see the data starts to repeat itself at year 12 on column 1,
year 13 for column 2 etc.
My problem is that the formulas that are in these cells calculate that
way as my module is based on a 11 year rollover. This means that my
formula changes at year 12 no matter what.
However, I need to be able to choose my rollover period. For example if
it is 8 years then my workbook will start to recalculate at year 9 in
column 1 and year 10 for column 2- etc.
example of the formula in year 1: Sheet 1 Actuarial Analysis'!AZ5
at year 12 it changes to: =IF(OR('Linfield ILU Actuarial
Analysis'!AZ16<'Linfield ILU Actuarial Analysis'!AZ5,'Linfield ILU
Actuarial Analysis'!AZ5/'Linfield ILU Actuarial
Analysis'!AZ16>96%),0,'Linfield ILU Actuarial Analysis'!AZ5)
can what i want be done?
yr1 0.97
yr2 2.04 0.08
yr3 2.18 0.16 0.05
yr4 2.23 0.17 0.11 0.10
yr5 2.29 0.18 0.11 0.22
yr6 2.35 0.18 0.12 0.23
yr7 2.41 0.19 0.12 0.24
yr8 2.48 0.19 0.12 0.24
yr9 2.55 0.20 0.13 0.25
yr10 2.62 0.20 0.13 0.25
yr11 2.69 0.21 0.13 0.26
yr12 0.97 0.21 0.14 0.27
yr13 2.04 0.08 0.14 0.28
as you can see the data starts to repeat itself at year 12 on column 1,
year 13 for column 2 etc.
My problem is that the formulas that are in these cells calculate that
way as my module is based on a 11 year rollover. This means that my
formula changes at year 12 no matter what.
However, I need to be able to choose my rollover period. For example if
it is 8 years then my workbook will start to recalculate at year 9 in
column 1 and year 10 for column 2- etc.
example of the formula in year 1: Sheet 1 Actuarial Analysis'!AZ5
at year 12 it changes to: =IF(OR('Linfield ILU Actuarial
Analysis'!AZ16<'Linfield ILU Actuarial Analysis'!AZ5,'Linfield ILU
Actuarial Analysis'!AZ5/'Linfield ILU Actuarial
Analysis'!AZ16>96%),0,'Linfield ILU Actuarial Analysis'!AZ5)
can what i want be done?