Re: Help Convert logic to Excel formula
May I please beg for you assistance how I can convert the below logic into an excel formula? Please I really need help. Thanks.
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.
Video Tutorials / Excel Dashboards Reports