Conditional Formula for 2011 Forecast

[franztupaz]

Dear Everyone,

1st Condition
Jan 2011 forecast = Jan 2010 sales if ("GDP" will equal to +4% growth) if ("Same" will equal to +6% growth) if ("New" will equal to 10% growth).

2nd Condition
Jan 2011 forecast is greater than average sales then Jan 2011 forecast is = (equal to) Jan 2011+growth

3rd Condition
Jan 2011 forecast is lower than 200,000 then it will take or be equal to average sales of 2010 (Jan-December Sales)

Note:
Minimum monthly forecast will always be the average 2010 sales as default forecast+growth factors
But is the actual monthly forecast is greater than the average 2010 sales then monthly forecast will equal to 2010 monthly sales+growth factors.

Growth Factors:
2010 + 4% (GDP Growth)
2010 + 6% (Marketing Program Growth - "Same")
2010 + 10% (New Program + GDP Growth - "New")

Hope you can help me turn the logic into a working equation or formula, thank you very much.

Sincerely,

Francis