+ Reply to Thread
Results 1 to 5 of 5

Pass/Fail Percentages

  1. #1
    Registered User
    Join Date
    04-13-2011
    Location
    el paso
    MS-Off Ver
    Excel 2007
    Posts
    4

    Pass/Fail Percentages

    I am trying to make a cell that would calculate the pass/fail averages for an Army Physical Fitness Test and am some what lost. I am going to attach the spread sheet I am working with in Excel 2007. If any on could help me out I would appreciate it. Some general knowledge for the sheet I am working with is the individual scores for each even (Push ups, Situps and 2 mile run) much be 60 points or greater to be a pass and automatically make the PT test a fail. These scores are already marked in red for easy id. I am hoping there is a way to make the percentage automatically adjust when I fill in the scores. If anyone could help I would apreciate it very much.
    Last edited by cheech1206; 04-13-2011 at 12:29 PM. Reason: Removed attachment: Confidential data

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Pass/Fail Percentages

    How about the attached - I added an extra column (L) but you can put it someplace else and hide it if you want.
    Attached Files Attached Files
    Last edited by Cutter; 04-13-2011 at 12:04 PM. Reason: Removed private data from attachment

  3. #3
    Registered User
    Join Date
    04-13-2011
    Location
    el paso
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Pass/Fail Percentages

    Thats perfect thats alot. Its exactly what i needed.

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Pass/Fail Percentages

    You're welcome. Always very happy to help out the military. Thank YOU.

    Don't forget to mark your thread as SOLVED - click on FAQ at top of page for directions (if needed).

  5. #5
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Pass/Fail Percentages

    This is Cutters' solution, but I thought you might want to see what groupings can do for your sheet, rather than hide rows. Toggle the +/- buttons in the left margin

    Also get rid of as much merged cells in your tables as you can, better still all of them, they just give you grief.
    I have cleaned out the principal offenders and put in an alternative that looks the same.

    Cheers
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1