Comments on: How to calculate percentage in Excel - formula examples

In this tutorial, you will lean a quick way to calculate percentages in Excel, find the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more. Continue reading →

Comments page 4. Total comments: 342

  1. how i can calculate 50/100 times 45 = 23 in Microsoft excel

    1. Hello, Rogers,

      For us to be able to assist you better, please describe your task in more detail.

  2. Hi Sirji,
    I want to find out the highest marks in the entire sheet for each code separately
    formula put in All marks columns

    code marks code marks code marks code marks code marks
    301 90 30 35 85 99 65 45 301 76
    40 92 41 65 30 85 41 36 37 85
    41 85 301 22 41 92 55 85 55 70
    30 35 48 25 301 45 40 77 30 55

    1. Hi AK Pandey,

      First copy and paste in new sheet, paste as special and select "Transpose" option. Next it will come one column total code and one column total marks,
      E.g.: Few like below for your ref.

      Code Marks
      301 22
      48 25
      30 35
      30 35
      41 36
      65 45
      301 45

      After this you can use pivot table, Please follow as below mentioned method.

      1."Row labels" you give code.
      2."Values" give Marks.

      Once you done with this option, you can see the details in work sheet as, one column for Code and other column for Marks.
      Under MARKS column, right click on any cell, then select option “summarize data by”, under this you can find MAX option. Please select MAX option, which will solve your issue.

      Feel free to ask for any clarification.

      Warm Regards,
      Hemanth….

      1. Hi Sirji Thanking you.

  3. I need help on how to set my excel in getting witholding tax if SINGLE is 25% and MARRIED is 10% to be deducted from the GROSS, this is just an example scenario.

    I need formula for IF function.

    THANKS A LOT

    1. Hello, Mark,

      For us to be able to assist you better, please explain your task in a kind of verbal formula. Like take N and subtract X from Y.

      1. BB x 19% = 5000
        I want to know the formula to know the amount "BB".
        hope you understand..

  4. I need help on a very simple formula

    my customer orders x qty of an item. she orders in 3 sizes at a percentage.
    ie. 1600 units
    30% is size small
    40% is size medium
    30% is size large.

    how can i set up a formula in excel where i can change the total units to figure this out? It is easy on a calculator, challenging in excel.
    thank you!
    dee

  5. Good morning. I need help. I want to create a formula that calculates percentages AFTER the first 6%. Currently I have it set up to calculate up to the first 6% but need to change it to only calculate everything AFTER the first 6%. =IF(B14>=0.06,"6%",IF(B14>=0.05,"5%",IF(B14>=0.04,"4%",IF(B14>=0.03,"3%",IF(B14>=0.02,"2%",IF(B14>=0.0001,"1%",IF(B14=0,"0%")))))))

    1. Hello, Delane,

      This formula should help:
      =IF(AND(B14>=0.001,B14<0.02),1, FLOOR(B14*100,1)) & "%"

  6. A B C D

    Unit Value Percentage Amount

    3 1,000 100% 3,000
    5 1,000 50% 2,500
    6 1,000 30% 1,800

    Can I know how to set the formula for Column D for the scenario above?

    1. Hello, Jeanette,

      Please see the formula you should use on the picture below:
      Formula for column D

  7. i have a formula

    =C4*4%

    I want to know if there is a way to add a formula without the number of percent and i can just add in 5% or 4% when ever i like i tried doing

    =c4* ?%

    but that doesnt work

  8. Hi Svetlana,
    Trying to help my husband do a spreadsheet for his work... I have a list of items and 3 regions with their separate totals for each item. The items are then totaled separately(all 3 regions together)to get the new total. There is a separate column to put the total out of 100% for each specific item. This column of totals then all need to add up to 100%. The only excel I have done is simple, not like this, so I'm lost - can you help me?
    Thanks so much in advance.
    Deb

    1. Hello, Deb,

      For us to be able to assist you better, please give us an exact example and describe the expected result. Thank you.

  9. Hi
    I need to make equation to convert percentage to points in excel Like that

    - 60% to 70% = 2 points

    - 71% to 100% = 3 points

    - 101% to 120% = 4 points

    - 121% to infinity = 5 points

    thanks for your help

    1. Hello Beshoy,

      To display points corresponding to percentages, you can use a nested IF formula like this:

      =IF(A1>120%,5, IF(A1>100%, 4, IF(A1>70%, 3, IF(A1>=60%, 2,""))))

      1. - first thing thanks for your help

        - second thing I need it but with Variable points not fixed

        Exp : form 60% to 70% = 2 points Maximum If It equal 70%

        If the percentage is 65 that means the points is equal part of the total points, but not all

        1. Sorry, I an not sure I can follow you. The formula assigns 2 points for percentages between 60% to 70%, inclusive. Are you looking for something different?

          1. Hi
            I need to make equation to convert percentage to points in excel Like that

            - From 60% to 70% = 2 points

            If the percentage between 60% & 70% the point will be displayed according to the percentage Like that

            1- IF the percentage less than 60% the point will equal 0 point

            2- IF the percentage = 60% the point will be equal 1.0 point

            3- IF the percentage = 65% the point will be equal 1.5 point, that means the is Variable not fixed

            4-IF the percentage = 68% the point will be equal 1.8 point

            Notes:

            - total range for the percentage is 10%
            - total point range is 2 Points

            thanks for your help

            1. Hi

              Sorry I need your answer urgent

  10. Hi everyone..
    I have a query..How to calculate a series of percentage for whole excel in one go?? for eg. if column A(A1 TO A 30) deals with marks obtained by 30 students in exam and Column B shows the total marks. so is there a formula by which we can calculate the percentage of all students in one go and don't do (=A1/B1 setting percentage function)??

    1. Hi Anoop,

      Sorry, I am not sure I can follow you. If =A1/B1 is the right formula for calculating the percentage of total for each student, and all you have to do is copy that formula down to other cells in the column. If the total is in some particular cell in column B, say B1, add absolute sell references like =$A1/$BS1 for the formula to copy correctly.

  11. Hello Shahid,

    Here you go:
    =100*6+(100*6)*0.01

    1. I need an Excel formula for this - if i charge 3% for every $10 i loan for 2 weeks, how much will I earn for $200 I loan for 2 weeks

  12. i have 14% but i want it to show as -84% what formula do i put it to make it show this?

    1. Hi Vicki,

      You probably meant -14%? To reverse the sign, you can simply multiply the value by -1, e.g. =A1*-1

      If you want to reverse the sign in existing cells, you can use the Paste Special function:

      - Enter -1 into any blank cell, and then copy that cell.
      - Select the range of cells where you want to change the sign.
      - Right click the range, select Paste Special > Multiply.

      1. sorry i meant i want it to say -86%

  13. Hi,
    if i have number 811 then how to calculate 5.20% out of them.
    Regards,

    Rajeev Mishra

    1. Hi Rajeev,

      This is the general formula:
      Total * Percentage = Amount

      In your case, =811*5.2% or =811*0.052

      Either way, the result is 42.172.

  14. i need a percentage of pass + fail. I have 10 tests, 3 pass and 4 fail. What is the % that was tested?

    1. Hi Sammy,

      You can use the following simple formula, replace values with corresponding cell references, and apply the percentage formal to the cell with the formula:
      =(3+4)/10

  15. Hi, I have a question, I am trying to calculate up a percentage and can't figure out the formula… can you help me?
    I have a wholesale price of $25
    I know the retailer wants to make 20%
    How do I calculate the consumer price - but if I times 25x20%, i only get $5, and added to the original $25 is $30. But 20% of $30 is $60. I can't figure out the formula in Excel. Thanks!

    1. Karin,
      $5 is 20% of $25.00 total. 20% of $30.00 is $6 not $60.
      (where A1 is the total of $25) you will enter the following in B1 =A1x5%

      1. use the * not the x in the cell B1 ...sorry just noted that after it posted.

  16. i wanna buy something..86500 that's the price..but the seller says that he will give me 50% + 20% off..what does it meant?? how much should i pay? n how to make the formula ??

    1. i wanna buy something..62.23 that's the price.and tax price is 12% where as rate is 66.23 how to write a formula on excel ....

    2. Most likely your price is 34600:

      =86500*50%*(100%-20%)
      or
      =86500*0.5*0.8

      But you'd better check with the seller anyway because the offer is not crystal clear...

      1. that's the formula i need...thank you very much Ms.svetlana

  17. i have multiple percentage 50% + 20% off from the price list..how to make the formula to know how much should i pay??..thanks before

    1. Hi Ali,

      If you want to calculate the discounted price, you can use a formula similar to this: =A1*(100%-20%)

      Where A1 is the full price and 20% is the discount.

      If you are looking for something different, please clarify.

      1. i wanna buy something..86500 that's the price..but the seller says that he will give me 50% + 20% off..what does it meant?? how much should i pay? n how to make the formula ??

  18. This is all very helpful. Thanks!

    Column A of per person cost.
    Column B of number of people.
    I need to multiply the per person cost by the number of people. THEN add 8.25% sales tax to the multiplied amount.

    Per Person x number of people + 8.25% sales tax.

    I cannot figure it out for the life of me. Please help.

    1. Hi Danny,

      Here you go:
      =A2*B2+(A2*B2)*8.25%

  19. How can I calculate a percentage of rows for a specific Username (column) that have "Yes" values out of the total number or rows for that same Username to obtain Individual metrics? This is easy to do with a Pivot table and Yes/No fields as distinct columns, but I am trying to find a way to obtain percentages from the source data.

    1. Hi Kevin,

      You can use the COUNTIF function to count the "yes" values in a column, and ROWS function to count all cells. And then devide the former by the latter to get a percentage. For example:

      =COUNTIF(A2:A100, "yes")/ROWS(A2:A100)

      If you want to exclude blank cells from the total count, then use COUNTA instead if ROWS:

      =COUNTIF(A2:A100, "yes")/COUNTA(A2:A100)

  20. I have a column of discounts that I want to apply to a column of subtotals, but some of the rows contain a 0% (or no) discount. If I apply any of the formulas above, multiplying the subtotal by 0 will result in a total of $0 instead of simply transferring the subtotal into the total column. How do I get around that in Excel?

    I would appreciate any advice you could provide! Thank you!

    1. Hi Teresa,

      You can use an IF formula similar to this:

      =IF(B2>0, A2*B2, A2)

      Where A is sub-total and B is discount %.

  21. How do I write a formula that determines that a number is equal to 60% of what number? I need a formula to account for 40% loss. The scenario involvers a withdrawal from a 401(k). I know that if I need $60,000, I must withdraw $100,000 to account for the 40% loss in taxes. How do I write that in a formula?

    1. Hi Frank,

      If my understanding is correct you know the amount (60,000) and percentage (60%) and you want to calculate the total. If so, use one of the following formulas:

      =A1/0.6 or =A1/60% where A1 is $60,000

      =A1/B1 where A1 is amount ($60,000) and B1 is percentage (60%)

  22. Hello, I am Cambodian, Please help me, How to find average and what is the formula to find it? please :)

    1. Hi!

      You can use the AVERAGE function. For example the formula =AVERAGE(A1:A10) returns the average of values in cells A1 through A10.

  23. My total amount is for example $3500,I want to know the amount of 5.5% including total amount in $3500.When I Add the amount + 5.5% amount it should come =$3500.

    1. Hi Muralli,

      If my understanding is correct, you want to calculate 5.5% of the total ammount and then add it to the total. If so, you can use any of the follwoing formulas:

      =3500+(3500*5.5%)
      =A1+(A1*5.5%)
      =A1+(A1*0.055)

      Where A1 is your total ammount.

  24. In my spreadsheet "column C row 9 has $75.00" in column D row 9 I want it show 30% off of the $75.00 with the total being $52.50 in column D row 9. How do i enter that formula

    Thank you

    1. Hi Jeff,

      It can be either =C9*70% or =C9*0.7

      1. Thank you

        How did you get that number because I also now have to but in that column in different rows 15% 25%.

        Jeff

        1. Just subtract it from 100%. For example, 100% - 15% = 85% or 0.85 in the decimal form.

  25. =IF(ISERROR((($K7+$M7)/$I7)),0,(($K7+$M7)/$I7))

    Please explain what this formula means.... I think my percentages are not calculating correctly.

    1. it means you've put to many nested if's in your formula.

  26. Hello ,
    I need to make an excel sheet for my rate reference to update prices.
    in the first column i would have the net rate ( different base rates) and next column i need to add say 10 % to the net rate of the first column and in the third column i need 15 % of the net rates given in the first column .
    how can i do this ?? Hope u understand
    I only need to get different percentage of the net prices fixed in column one .

    1. Hello George,

      Please enter these formulas into the 2nd cell of each column and then copy and paste them across the columns:

      Second column
      =A2*110%

      Third column
      =A2*115%

      Insert these formulas and then copy/paste them down across columns.

  27. Hie

    Let say .. i have 10 customer. Total Sales : $1,000

    Customer A : $100 ; Total contribution : 10%
    Customer B : $200 ; Total contribution for A + B = 30%
    Customer C : $100 ; Total contribution for A + B + C = 40%

    How to do i do the % contribution in formula ?

  28. Hi there,

    I want to calculate a percentage of the number of "Yes" response of the total given the option of three - yes, No amd Inappropriate.

    How will I calculate the % of how many responses are "YES" out of the three responses

    Please Help

    1. Hi Priyanka,

      I believe the COUNTIF function may help:
      =COUNTIF(A1:A10, "yes")/10

      Where A1:A10 are the cells with responses and 10 is the total number of cells.

      After entering the formula, remember to click the Percent Style icon on the ribbon (Home tab > Number group) to display the result as percentage.

      1. I need to formula to check if current "Yes" survey response is 71% for X number of responses how many more "Yes"survey responses will I need to get the score of 80%

      2. Hi Svetlana,

        I am currently using the following percentage formula for calculating "Yes" vs "No" but not including the blanks.

        =IFERROR(COUNTIF(C12:ZZ12,"Yes")/COUNTA(C12:ZZ12),"")

        I am trying to add a third option of "Maybe" that I want to be counted as a "Yes" in the percentage. Any thoughts would be helpful as I am running out of ideas.

      3. Svetlana,
        How about if the column from which the formula is pulling continuously grows? the "/10" portion of the formula would have to be altered to match the ever-changing number of cells. Can the formula be set to match the total number of cells in the column?
        I know you could do (A1:A99999), and that would take care of the first part of the formula, but if there's a way to make the "divide by" value equal the number of "active" cells, that would be great!

        1. Hi Kyle,

          You can use COUNTA to get the total count of non-blank cells, like this:
          =COUNTIF(A1:A99999, "yes")/COUNTA(A1:A99999)

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)