Percent Help

Discussion in 'Excel' started by trent92, Jul 19, 2016.

  1. trent92

    trent92

    Joined:
    Jul 19, 2016
    Messages:
    4
    Likes Received:
    0
    I have a spending plan that Starts in Oct 1 and end Sept 30. I used a Authority availability on a quarterly basis, however they made not use all Funding (but, they could go over and request more money for that qtr - bad).

    exp: Row (a) available funds
    exp: Row (b) they spent
    exp: Row (d) money that’s available.

    My question - is there a way to show in a new column a percent of status per quarter? 1st Qtr 25%, 2nd Qtr 50%, 3rd Qtr 75%, 4th Qtr 100% of Spending plans funds but, gets a RED highlight if over that Qtr. Just need to know if a "District" is staying within budget (by the way I have 94 Districts). Also, can a District stand out (be flag)?

    upload_2016-7-19_15-51-13.png











     

    Attached Files:

    trent92, Jul 19, 2016
    #1
    1. Advertisements

  2. trent92

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    Are you looking for help creating the formula or making the cells red if they exceed budget?

    I can't tell the cell numbers but a percent formula would look something like this:
    =(cell_that_contains_total_spend)/(cell_that_contains_budget)

    You can then use conditional formatting to highlight the ones that are exceeding their budget. For example, for Q2, if the cell is >0.50 than highlight the cell red. This can be done in the Home Menu > Styles > Conditional Formatting. The same idea would work for the other quarters but you would use 0.75 and 1.0 as the conditions.
     
    Amy @ German Pearls, Jul 20, 2016
    #2
    1. Advertisements

  3. trent92

    trent92

    Joined:
    Jul 19, 2016
    Messages:
    4
    Likes Received:
    0
    Yes, on the right path - So if my Quarterly budget is $8,000 and spent$2,000 should be 25% (good), but, if my budget is $8,000 and I spent $13,000 should be163% (bad); then I should be able to use conditional formatting that highlights the percent in red. I think I got it. Thank you Amy
     
    trent92, Jul 20, 2016
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. build

    maths help

    build, May 1, 2011, in forum: Excel
    Replies:
    2
    Views:
    800
    XLPadawan
    Jun 16, 2016
  2. bookerk2

    help with conditional formatting

    bookerk2, May 4, 2011, in forum: Excel
    Replies:
    1
    Views:
    772
    XLPadawan
    Jun 16, 2016
  3. jsduiahd
    Replies:
    0
    Views:
    639
    jsduiahd
    Jul 26, 2011
  4. Nago
    Replies:
    0
    Views:
    589
  5. Catw0327

    Timebase help!!!

    Catw0327, Apr 10, 2012, in forum: Excel
    Replies:
    1
    Views:
    793
    XLPadawan
    Jun 16, 2016
  6. Mark

    Help Fill Series

    Mark, Apr 4, 2013, in forum: Excel
    Replies:
    1
    Views:
    1,192
    XLPadawan
    Jun 16, 2016
  7. caziscarol

    Excel help recording hours

    caziscarol, Oct 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    564
    chimpytech
    Apr 12, 2014
  8. Peter Kaufmann

    Lookup Function Help

    Peter Kaufmann, Nov 8, 2014, in forum: Excel
    Replies:
    1
    Views:
    398
    Peter Kaufmann
    Nov 13, 2014
Loading...