Hi Everyone,
Can anybody help me convert the following logic to a working formula please?
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
Bookmarks