Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Convert logic to Excel formula

1. Member
Join Date
7th February 2011
Posts
31

## 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

Excel Video Tutorials / Excel Dashboards Reports

2. Member
Join Date
7th February 2011
Posts
31

## 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. ## Re: Convert logic to Excel formula

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

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

#### 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