Announcement

Collapse
No announcement yet.

Convert logic to Excel formula

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Convert logic to Excel formula

    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
    Attached Files

  • #2
    Re: Help Convert logic to Excel formula

    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

    Comment


    • #3
      Re: Convert logic to Excel formula

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

      Forum Rules | Message to Cross Posters | How to use Tags

      Comment

      Working...
      X