![]() |
excel formula question
I am trying to create a formula where I have a yearly cost and I want to add
inflation adjustment each year over around 20 years and find the total cost for 20 years. Anyone know how to do that? Thank you. |
excel formula question
Try
=1000*(1+3%)^20 Where 1000 is the present value 3% = inflation term 20 yrs Mike "crookedsoul108" wrote: I am trying to create a formula where I have a yearly cost and I want to add inflation adjustment each year over around 20 years and find the total cost for 20 years. Anyone know how to do that? Thank you. |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com