Formula for quarterly product launches

[Bwatson123]

I am struggling with creating a table that shows the quantity of products sold by retailer over a twelve month period.

Each retailer will start out selling 10 units each month and increase 5 units each subsquent month. The problem is that the retailers will all start in different months. I am hoping to create a table that allows me to flag which month the retailer starts and if I change this start date, the table will automatically fill with 10 units in the month of launch increasing by 5% each month after launch.

I am being long-winded but hopefully somebody gets it.

Retailer 1 may launch Jan1 with 10 units Feb 15, Mar 20, Apr 25....

Retailer 2 launches April1 with 10 units March 15, Apr 20....

Retailer 3 may launch in Sept with 10 units

I will want to change the launche dates and have the table update automatically.

Any help much appreciated!

[dogberry]

Hi

Can you post a sample worksheet so people can see your layout and how far you have got. I doubt you will find anyone to do all the work for you.

Chris

[Armando Montes]

Maybe:
=IF(B2="","",B2+5)
Fill across