Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Future Value of Money

I have a number which increases each year by 3% at a certain date. What cell
entry can I input to have this number increase automatically per year
dependant upon that date.

For instance, I have a # 2532, which increases by 3% every year on September
2. How can I plug this date into the equation so that the # automatically
increases every September 2 in my spread sheet?



Thank you,
Philip
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Future Value of Money

I wouldn't do it that way......because, if you open an old file for review,
it may "update" itself without your permission.......I would just base all
relative formulas on a key cell, and then manually update that cell each
year......and anyhow, someday it may change from 3% to somethine else........

hth
Vaya con Dios,
Chuck, CABGx3



"Keeprogoal" wrote:

I have a number which increases each year by 3% at a certain date. What cell
entry can I input to have this number increase automatically per year
dependant upon that date.

For instance, I have a # 2532, which increases by 3% every year on September
2. How can I plug this date into the equation so that the # automatically
increases every September 2 in my spread sheet?



Thank you,
Philip

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
Future Value of Money Keeprogoal Excel Worksheet Functions 3 January 12th 07 08:25 PM
annuity with daily compounding but annual deposit of money Marjory K Excel Worksheet Functions 2 January 3rd 07 07:35 PM
Basic Future Value Formula & Interest Rate Formula Peter Excel Discussion (Misc queries) 2 November 12th 06 04:23 AM
Tricky Date calculation: How to calculate a future date [email protected] Excel Discussion (Misc queries) 9 August 11th 06 04:24 AM
Money "In" Money "Out" Formula heater Excel Discussion (Misc queries) 6 February 13th 06 10:19 PM


All times are GMT +1. The time now is 05:38 AM.

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

About Us

"It's about Microsoft Excel"