2011 Forecast based on 2010 number excel formula configuration

[franztupaz]

GOD BLESS YOU FOR YOUR WISDOM THANK YOU FOR HELPING ME SOLVE THE PROBLEM


Dear Everyone,

May I please beg for you assistance how I can convert the below logic into an excel formula? Please I really need help. Thanks.

Parameters:
2010 Average Sales
4% Growth (GDP)
6% Growth (New Promotion) (represented by YES) definition is a promo that did not run last 2010 but will be implemented by 2011
3% Growth (Repeat Promo) (Represented by NO) definition is a promo that run 2010 and will be implemented again by 2011

logic 1 "2010 average sales + 4% GDP Growth + 6% if YES = 2011 forecast

logic 2 "2010 average sales + 4% GDP Growth + 3% if NO = 2011 forecast

Logic 3 "2010 average sales + 4% GDP Growth + 0% if blank = 2011 forecast

basically what I wanted to derive is a forecast with a minimum of 4% growth from 2010 and an additional 3% or 6% (median of 7% & max of 10%) = 2011 forecast

Am very sorry for the trouble, and many thanks in advance.

Please see file as basis or example.

Hope someone will help me please.

Regards,

Francis

[ConneXionLost]

In cell '2010 Sales Data'!AB5 you are using this formula:

=(1+0.04+IF($AA5="Yes", 0.06, 0.03))*$R5

try changing it to:

=(1+0.04+IF($AA5="Yes", 0.06,IF($AA5="No", 0.03, 0)))*$R5

and autofill/copy throughout.

Hope this helps.

[franztupaz]

Thank you very much sir may God bless you for your wisdom