broncos347
Active Member
- Joined
- Feb 16, 2005
- Messages
- 291
- Office Version
- 365
- Platform
- Windows
I have a question surrounding indexation which someone can hopefully help me with because I can't get my head around what i need to do.
I have a table which holds an annual index figure, the table has two columns one for the year and one for the indexation rate.
I have another table with a base amount, says £100,000, and this amount has a base year of 2016, the sheet also has another column which shows year of construction, e.g. 2020 (this year could change), what i am trying to do is * the £100,000 to bring it up to a figure in 2020, i can do this by simply *ing the base figure by the indexation rates between 2016 and 2020, for example, £100,000*1*1.023*1.026*1.04*1.025 and this would give me the figure i need, what i can't get my head around is how i can automate this so that if the year of construction changes the £100,000 will be adjusted accordingly.
Any help would be appreciated.
I have a table which holds an annual index figure, the table has two columns one for the year and one for the indexation rate.
I have another table with a base amount, says £100,000, and this amount has a base year of 2016, the sheet also has another column which shows year of construction, e.g. 2020 (this year could change), what i am trying to do is * the £100,000 to bring it up to a figure in 2020, i can do this by simply *ing the base figure by the indexation rates between 2016 and 2020, for example, £100,000*1*1.023*1.026*1.04*1.025 and this would give me the figure i need, what i can't get my head around is how i can automate this so that if the year of construction changes the £100,000 will be adjusted accordingly.
Any help would be appreciated.