Creating a new workbook dependant on a variable

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Else?? 0
Compare two columns 7
Code somewhat works. Please help? 4
Auto calc. the bottom 20% with a twist... 1
A Challenge 17

Top