Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Parameters for an excel formula

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default Parameters for an excel formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Issue [email protected] Excel Discussion (Misc queries) 2 August 16th 06 11:44 PM
HOW CAN I PROTECT A FORMULA IN EXCEL Kingsley Excel Discussion (Misc queries) 6 August 13th 06 04:12 PM
Excel formula Q scoobz Excel Worksheet Functions 8 July 17th 06 07:19 AM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
converting formula from lotus.123 to excel zaharah Excel Worksheet Functions 2 July 27th 05 03:04 PM


All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"