Results 1 to 3 of 3

Thread: Calculate percentage

  1. #1
    New Member
    Join Date
    Dec 2018
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calculate percentage

    I am trying to work out a percentage...

    COUNT ISSUES TOTAL
    13 1 8%

    This is what I'm currently getting, however I want to flip it. So that the 8% in the total
    column displays 92% instead.

    So the count of 13 is 100%, minus the issues of 1 which is 8% which gives me a total of 92%.

    How would I go about this?

    Thanks for any help.

  2. #2
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,449
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculate percentage

    Excel 2010
    A B C
    1 COUNT ISSUES TOTAL
    2 13 1 92%
    Sheet1

    Worksheet Formulas
    Cell Formula
    C2 =1-(B2/A2)
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

  3. #3
    Board Regular
    Join Date
    Apr 2003
    Location
    England
    Posts
    5,890
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Calculate percentage

    Try

    =1-B1/A1
    To post screen shots download the MrExcel HTML Maker
    Look here for other options Recommended Add-ins and Links

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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