2011 Forecast based on 2010 number excel formula configuration

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

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

Please Login or Register  to view this content.

try changing it to:

Please Login or Register  to view this content.

and autofill/copy throughout.

Hope this helps.