View Single Post
  #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!