+ Reply to Thread
Results 1 to 4 of 4

Formula with Percentages

  1. #1
    Forum Contributor
    Join Date
    10-18-2015
    Location
    manila, philippines
    MS-Off Ver
    MS Office 2010
    Posts
    186

    Formula with Percentages

    Hi,

    Can someone help me with putting up formulas for cells O12:O14 in "Summary" sheet. I would want to know how many got 90% and above for O12, 85% to 89.99% for O13, and 84.99% in O14.

    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Formula with Percentages

    In O12:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In O13 (and filled down to O14):
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Forum Contributor
    Join Date
    10-18-2015
    Location
    manila, philippines
    MS-Off Ver
    MS Office 2010
    Posts
    186

    Re: Formula with Percentages

    worked great, thank you!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Formula with Percentages

    I think that there are more problems with your sheet than you may realise. On yur sheet, as posted, the overall passing rate was 8%. That can't be correct. There was only one set of scores, which passed, so it can ONLY have been 100%.

    All of the yellow shaded cells have been amended. Only when a candidate ID number is entered will the cells populate.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formula to help with percentages
    By ricspratt86 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-13-2016, 09:25 PM
  2. IF formula with different percentages %
    By Sarah Lovell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2014, 01:16 AM
  3. Reversing input percentages against variable percentages.
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2014, 08:56 PM
  4. [SOLVED] Percentages formula
    By daxcrocker in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2014, 05:52 PM
  5. Formula with Different Percentages
    By KimMerc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2012, 03:44 PM
  6. [SOLVED] Formula for Percentages?
    By ChristyT71 in forum Excel General
    Replies: 6
    Last Post: 09-12-2011, 05:00 PM
  7. [SOLVED] Re: formula for percentages
    By Tracy in forum Excel General
    Replies: 0
    Last Post: 05-11-2005, 02:06 PM

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