Convert logic to Excel formula

[franztupaz]

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

Please see file as basis or example.

Hope someone will help me please.

Thanks!

Francis

[franztupaz]

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

[AAE]

Duplicate thread: Discussion continued here: Calculate sales forecast using multiple criteria