Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a new workbook dependant on a variable
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'!AZ1696%),0,'Linfield ILU Actuarial Analysis'!AZ5) can what i want be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a variable dependant on content of specific cells | Excel Discussion (Misc queries) | |||
Creating Variable for a Sheet | Excel Programming | |||
creating a variable | New Users to Excel | |||
Macro Creating Variable and using variable in a SQL statement | Excel Programming | |||
Macro Creating a variable which is to be used in a SQL in the Mac | Excel Programming |