Results 1 to 6 of 6

Thread: Conditional formatting for 2011 forecast

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    franztupaz
    Guest franztupaz's Avatar

    Conditional formatting for 2011 forecast

    Dear Everyone,

    I am a newbie in the excel and basically has close to "0" knowledge except for basic functions, but have seen the benefit of having a working sheets/templates which cuts work time in half.

    If I may kindly request for your assistance as I am working on a 2011 forecast and I am stuck and cannot move on, please see below parameters and likewise the attached excel sheet as an example.

    Conditions:
    Base Number - by branch 2010 monthly sales
    Growth Factors - grow 2010 Monthly Sales by branch
    "GDP"=+4% growth
    "Same"=+6% growth
    "New"=+10% growth

    If monthly 2010 sales is greater than 200,000, then just add growth factors as 2011 monthly forecast
    If monthly forecast is less than 200,000 base number should be average 2010 sales + growth factors
    If monthly forecast is greater than 150% of average 2010 sales, then forecast should take average 2010 sales as its forecast + growth factors.
    Round final numbers

    Please refer to the attached under "Tarlac" row, but please note that this was computed manually and without any "nested formula".

    Hope someone helps me.

    Thank you.

    best regards,

    Francis
    Attached Files Attached Files

Posting Permissions

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