+ Reply to Thread
Results 1 to 6 of 6

Yes or No with Percentage

  1. 10-23-2019, 07:26 AM #1
    brix1219
    brix1219 is offline
    Registered User
    Join Date
    09-05-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    8

    Yes or No with Percentage

    Hello everyne,

    Trying to figure this one out I've created a quality form for my team unfortunately having some challenges with the percentage file

    Wondering how can i change the formula for a better view

    I really appreciate all the help thank you

    Untitled.jpg
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-23-2019, 07:42 AM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Yes or No with Percentage

    Please post your actual question in the post because it can help for people looking to help to know what you are actually asking to have done.
    Upon opening your workbook I don't find more information contained that helps me to understand what you are looking for.
    It is always best to post a workbook WITH samples AND expected results. Your workbook contains nothing more than your snapshot except that now I can see the formula used in column G.
    But I have no idea what your expected results are.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 10-23-2019, 08:16 AM #3
    brix1219
    brix1219 is offline
    Registered User
    Join Date
    09-05-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Yes or No with Percentage

    Hi Sambo Kid,

    Sorry for the confusion is there any way to remove Column G but still able to do, the rating, and still getting the total of Final Score

    I appreciate the help

    Again, Sorry for the confusion, but I would like to have Column G remove withour loosing the formula if you switch the rating from Yes to No

    Thank you
    Reply With QuoteRegister To Reply
  4. 10-23-2019, 08:23 AM #4
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Yes or No with Percentage

    I'm still not sure I follow you, but are you looking for something like this in col G? = IF(E7="Yes",1,0)
    then if it is No it will return 0%. It will also return if col E is blank. So to avoid that = IF(E7="Yes",1,IF(E7="No",0,""))
    If those aren't what you are looking for then please give me a couple examples of expected results.
    Reply With QuoteRegister To Reply
  5. 10-24-2019, 03:42 AM #5
    brix1219
    brix1219 is offline
    Registered User
    Join Date
    09-05-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Yes or No with Percentage

    Hello Sambo kid,

    Thanks for helping me out, but I also have a problem

    If I put yes, I should be getting 20% of it but it is showing a 14% value to the final score

    Thank you for all the help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 10-24-2019, 03:57 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Yes or No with Percentage

    Which version of Excel are you using? Please update your profile accordingly.

    Try this:

    =SUMIF(G7:G15,1,D7:D15)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deducting percentage, calculate what percentage needs to be added to reverse
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2019, 05:47 AM
  2. Turning a percentage round to show the remaining percentage
    By tjb333 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2018, 10:51 AM
  3. Percentage values based on number of reports not actual percentage value
    By RickMcc in forum Excel General
    Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  4. [SOLVED] Formula for percentage Increase and corresponding percentage decrease (and viceversa)
    By jcroque89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2015, 10:25 AM
  5. I need a graph that shows percentage of a whole, but also the percentage of individual seg
    By jellybrown in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-05-2013, 08:10 PM
  6. increasing a range of cells by a percentage but need to add the percentage on to original
    By lammie26 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2013, 08:39 PM
  7. Format-Can a cell that is formated for percentage be red if the percentage is negativ
    By SteveW in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 12:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1