Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Convert logic to Excel formula

  1. #1
    Join Date
    7th February 2011
    Posts
    29

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th February 2011
    Posts
    29

    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Unable to convert Excel Formula to VBA
    By MattC in forum EXCEL HELP
    Replies: 5
    Last Post: October 7th, 2010, 23:15
  2. Convert Logic Function To Data Cell Validation
    By jennifer07 in forum EXCEL HELP
    Replies: 2
    Last Post: July 2nd, 2007, 13:06
  3. IF Function Formula Logic
    By blondn2jesus in forum EXCEL HELP
    Replies: 2
    Last Post: November 2nd, 2006, 15:21
  4. logic formula
    By Steve Mck in forum EXCEL HELP
    Replies: 1
    Last Post: May 30th, 2005, 02:54
  5. Applying Logic in a Formula
    By neillafferty in forum EXCEL HELP
    Replies: 4
    Last Post: May 3rd, 2005, 05:02

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno