Formula for Sales Pace in Excel

[aces2011]

Hi - I'm trying to create a formula to automatically create a monthly sales pace in excel. I have one product that has a sales pace of 0.5 per month but it's impossible to see half of a product in a month. How do I create a formula so that using the example above it would so a sale in month 1, no sale month 2, a sale in month 3 etc, instead of .5 sales per month?

 

[RichardMGreen]

What formula do you have so far?
What's your spreadsheet layout?

 

[aces2011]

I'm using a sumif formula right now. I'm pulling from a table which has a sales pace forecast and the result is below.

Sales Pace
Sales Pace/ Month Year 1 Year 2 Year 3 Year 4 Year 5
Level 1 1.00 2.00 3.00 3.00 3.00
Level 2 0.50 1.00 1.00 1.00 1.00
Level 3 0.25 0.25 0.25 0.25 0.25


Proforma
Year 1 1 1 1 1 1 1 1 1 1 1 1
Month 1 2 3 4 5 6 7 8 9 10 11 12
Date 9/30/11 10/31/11 11/30/11 12/31/11 1/31/12 2/29/12 3/31/12 4/30/12 5/31/12 6/30/12 7/31/12 8/31/12

Sales Projection
Units
Small 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00
Medium 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 1.00
Large 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25

 

[RichardMGreen]

From the data you've posted, what would your expected result be (or is that the sales projection)?

 

[aces2011]

this is a sales projection. If the sales projection is set at 0.5/month then the desired result would be to show 1 sale in month 1, 0 sales in month 2, 1 sale in month 3 etc. There would be one sale shown every other month. If the sales projection was .25 then it would should one sale every 4 months.