Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a multy year budget proposal for our project. All the values in the
columns sum properly per year. However what I need to do is take the year end total cell and increase each years total by 3% to allow for inflation. How do I create such a formula so the 3% increase shows in an adjacent cell to the year end total? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
At first blush the answer sounds easy: if the year end total is in cell
A1, then the formula is =A1*1.03 However, since your budget is across several years, consider using the POWER function. That will ensure the 3% increase is applied across all years. Year 1 formula: =A1*POWER(1.03,1) Year 2 formula: =A1*POWER(1.03,2) Year 3 formula: =A1*POWER(1.03,3) etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
HOW CAN I PROTECT A FORMULA IN EXCEL | Excel Discussion (Misc queries) | |||
Excel formula Q | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions |