Results 1 to 5 of 5

Thread: Fomula for Percentage Calculation

  1. #1

    Fomula for Percentage Calculation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    HI Sir,

    I have table for Quality , where data validation sources are YES, NO and Blank , I want a formula (Quality %) where if I choose yes for one box , no for other and blank as well. The percentage should be based on all the three parameters (YES, NO and BLANK).

    Its important please
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Can you give a little more detailed example showing sample inputs and expected results?


  3. #3
    HI,

    As per the attached template ,I have three Parameters - YES, NO and BLANK. I want to calculate percentage , for example, if first four boxes are NO and rest six boxes are YES, then the Quality percentage should be 60%, and BLANK should not be considered. help
    Attached Files Attached Files

  4. #4
    Help required

  5. #5
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Hi
    Try the following formula in B12, in relation to the choices in Col B (Assuming B12 is formatted as a percentage):

    COUNTIF(B2:B11, "Yes")/Rows(B2:B11)

    If you create sets containing a different number of boxes, adjust the arrays to suit.

    HTH
    Last edited by Hercules1946; 2013-08-31 at 09:08 PM. Reason: typing omission

Posting Permissions

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