May I please request for your assistance in figuring out the proper equation?

Logic:[/b]

If 2010 Sales is lower than 2010 ave.sales, 2011 forecast is equal to ave.sales provided that its greater than 200,000

If 2010 Sales is lower than 2010 ave.sales, 2011 forecast is equal to ave.sales provided that its greater than 200,000, if the average sales is lower than 200,000 by default it will take the minimum forecast of 200,000

If 2010 Sales is greater than 2010 ave.sales, 2011 forecast is equal to 2010 sales + growth factors

Growth Factors:

2010 + 4% (GDP Growth)

2010 + 3% (Marketing Program Growth - "Same"

2010 + 10% (New Program + GDP Growth - "New"

Total Probable forecast growth is 10%

Hoping to hear from you and thank you very much.

Best regards,

Francis