May I please request for your assistance in figuring out the proper equation?

Logic:[/b]
If 2010 Sales is lower than 2010 ave.sales, 2011 forecast is equal to ave.sales provided that its greater than 200,000

If 2010 Sales is lower than 2010 ave.sales, 2011 forecast is equal to ave.sales provided that its greater than 200,000, if the average sales is lower than 200,000 by default it will take the minimum forecast of 200,000

If 2010 Sales is greater than 2010 ave.sales, 2011 forecast is equal to 2010 sales + growth factors

Growth Factors:
2010 + 4% (GDP Growth)
2010 + 3% (Marketing Program Growth - "Same"
2010 + 10% (New Program + GDP Growth - "New"
Total Probable forecast growth is 10%

Hoping to hear from you and thank you very much.

Best regards,

Francis

I think all you need to use is IF() and AND() functions.

IF(AND(S2010<AS2010,AS2010>200000),AS2010,IF(AND(S2010<AS2010,AS2010<200000),200000,if(S2110>AS2010,S2010*G))

where AS2010 = Average Sales in 2010
and S2010= Sales 2010

Hi Sir,

To clarify, please see below looking forward to your help sir.

1st Condition
Jan 2011 forecast = Jan 2010 sales if ("GDP" will equal to +4% growth) if ("Same" will equal to +6% growth) if ("New" will equal to 10% growth).

2nd Condition
Jan 2011 forecast is greater than average sales then Jan 2011 forecast is = (equal to) Jan 2011+growth

3rd Condition
Jan 2011 forecast is lower than 200,000 then it will take or be equal to average sales of 2010 (Jan-December Sales)

Note:
Minimum monthly forecast will always be the average 2010 sales as default forecast+growth factors
But is the actual monthly forecast is greater than the average 2010 sales then monthly forecast will equal to 2010 monthly sales+growth factors.

Growth Factors:
2010 + 4% (GDP Growth)
2010 + 6% (Marketing Program Growth - "Same"
2010 + 10% (New Program + GDP Growth - "New"

Hope you can help me turn the logic into a working equation or formula, thank you very much.

Sincerely,

Francis

HI sir,

AL6=Grow D6 by 4% if W6 is "GDP", 6% if W6 is "Same" and 10% if W6 is "New",IF (Grow D6 by 4% if W6 is "GDP", 6% if W6 is "Same" and 10% if W6 is "New" is less then 200,000 then use R6 as 2011 forecast, then round numbers.

This means all Jan 2010 actual sales(D6) will either grow by 4%, or 6% and max of 10% (W6) and minimum forecast will be the average 2010 sales (R6).

I have attached the worksheet I am trying to use as reference, hope someone can help me.

Thank you.

Regards,

Francis

thanks for helping me figure things out, even if it still is unresolved. appreciate the effort

When worksheet functions become very complicates it is worth using a custom VBA function. Her is a link to help you create your first function.

Here is a start on a custom function but I'm afraid I cannot understand all your logic. Hopefully you can complete it yourself