G

#### Guest

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!