Perform Calculation using variable percentage based on other cell values part 2

Dear Everyone,

Here I am again requesting for your help in converting the below conditions into a working formula, I have attached herewith the current sheet I am working on as reference and likewise the formula's that I have been using.

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

try this formula in AM6
=IF($R6/12>=D6,$R6/12,D6)+(IF($R6/12>=D6,$R6/12,D6)*VLOOKUP(W6,{"New",10;"Same",3;0,4},2,0)%)

Hi Sadath,

Sadly it doesn't work. Thanks though!

Regards,

Francis

Originally Posted by Sadath31

try this formula in AM6
=IF($R6/12>=D6,$R6/12,D6)+(IF($R6/12>=D6,$R6/12,D6)*VLOOKUP(W6,{"New",10;"Same",3;0,4},2,0)%)