LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mona
 
Posts: n/a
Default random start and calculation

I have 3 input cells (data will change based on user input) :
A1 300 (value) "start rate"
A2 10 (percent) "decline"
A2 feb-07 (date as month and year) "start date"

I need to populate cells based on the "start date", "decline", "start rate".

Example output:

jan07 0
feb07 300
mar07 290
arp07 280
may07 270
jun07 260
jul07 250
aug07 240
sep07 230
oct07 220
nov07 210
dec07 200

Another example is the start date could change to may-07 and the output
would start the cacluation on May07 through dec07. So may07 will be 300,
jun07 is 290, jul07 is 280, aug07 is 270, ....dec07 is 230.

I am OK with the math but I am having problems getting the right
functions/code for the startdate and the calculations after that.

thanks!



 
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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Date calculation OCD Cindy Excel Worksheet Functions 3 April 5th 06 06:06 PM
Time Calculation For A Timesheet To Include Lunch poddys Excel Worksheet Functions 2 March 3rd 06 08:05 PM
Please help with time calculation Al Excel Discussion (Misc queries) 7 August 31st 05 02:40 PM
Help on automatically ending a calculation Jim Excel Worksheet Functions 0 November 11th 04 09:42 PM


All times are GMT +1. The time now is 09:10 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"