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 24. Total comments: 728

  1. 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.

  2. 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

  3. 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 ??

  4. I have cells in multiple non-consecutive columns(all on the same row) that I need to total, others identical that I need to total and then find a percentage of the difference between those two totals. IE: Total merits/total demerits= what%.
    The reason is because they are broken down into individual sections(columns) that already display a %, now I need an overall %. Hope that is enough info. Thanks!

  5. I'm try to get an equation like this can you guys for my excel help ..
    Example

    1075*7% + 5% + 70+ 45 +108 =342 .

    In other word

    $1,075 * $75 +$54+70+45+108 =342

  6. Hello, I need some help creating a % increase

    Im looking to have column "F" increased by 12%, so that column "G" shows the product

    I can not seem to get the formula correct.

  7. Hi, I hope you are fine.

    I have cities two month sales and percentage of two months sales. after I want to give 900 TV give form all cities by percentage of sales. when I drag it not show me correct.

    TVGift 900
    City Month1 Month2 Percentage
    Kabul 100,000 490000 20% 184
    Mazar 200,000 490000 41% 75
    Badghis 120,000 490000 24% 18
    Farah 30,000 490000 6% 1
    Helmand 40,000 490000 8% 0
    490,000 100% 278
    In here must be 100% Not correct.

    Best regards

  8. Am very much happy to learn from excel sheet. I do hope to learn more its great helpful to me.

    Kindly also send me thru my email on how to work more on calculating pls

    With regards,

    Henh

  9. If I wanted to get percentage of Pass per month? For example In January with 31 days X person achieved the goal (passed) 18 days which would be 58% percent for January for that person. Any ideas would be appreciated. There are 23 employees being track on one spreadsheet, per day, with a pass or fail grade. I tried a pivot table but its not what I need. Thanks!!!

  10. 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%

  11. 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)

  12. Hello
    may you please help in my fomulas also
    I need to calculate the outcome for sales people
    the conditions are the following
    Target is 7 811
    Person will receive max 15% in case 100% of target is achieved
    Person will receive zero in case only 85% of target is achived
    Outcome is 7 609, which represents 97.4%
    How much % the person will receive?

    appreciate on your support!

  13. 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 %.

  14. Ho to calculate current percents??
    750000,how is calculate 750000 current percents?
    Thanks

  15. If my A product is increased by $120,000 but B product is decresed by 10%, how can I write it with only 1 formula as I have to calculate the total amount either by the value or percentage. In other words, no matter i put percentage or value in the column, I still can get the same total amount.

  16. HI,

    HOW TO CALCULATE THE PERCENTAGE OF THE TOTAL MARKS

  17. 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%)

  18. I want to return a monthly value for fixed starting number that increases at a fixed percentage over a year. Let me show you the example:
    Base number (we'll call it January) = 1,000 (B1)
    Annual Increase = 40% (A1)
    What is the increase in each month Feb- Dec (A2-A12) of the year (expressed as the base + one-twelfth of the percentage? When I do the .40/12 in the formula I come up with 1,434. I think it should be 1,400. (1000 *.4 +1000)

    I'm missing something.

    Thanks!

  19. Hello,
    I want to calculate the following:

    6 = 2014 average (cell C23)
    8 = Jan 15 total (cell D23)
    5 = Feb 15 total (cell E23)

    I need to calculate the % increase/decrease between the 2015 average (8+5/2=6.5) and the 2014 avg (6). Note, I will need to continually update the formula to include future months (cells F23-O23).

    Thanks in advance,
    Mark

  20. How do I add 40% to the first 100 dollars and then 29% after the first 100??

  21. 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.

  22. Thank you for this article
    I am struggling to find out the percentage of my quantitative data,
    I had multiple choose questionnaires from (1 to 5)
    1. I need to find out how many of participants chose number 1, 2, 3, 4,5 to put in table
    2. I need the percentage of each number such is how many participants chose number 3

    This is one example of my questionnaires
    1 never 2 rarely 3 sometimes 4 very often 5 always
    Q1.
    Q2 .
    Q3.

    Thanks in advance

  23. I calculate an agents effectiveness using this formula =(AHT/ agreed AHT)*100. results are either less than or equals to 100. but sometimes i get results over 100. how do i calculate for such agent over 100%?

  24. Thanks for the article, it is very helpful! I am trying to show the percent change between two columns. I am ending up with the correct number, but there is not a '%' How do I get the percent sign to show up? This is the formula I am using; =((C5-B5)/B5)*100 Thanks!

  25. how to know the percentage of a number from within
    e.g 20% is 25% on top
    or 150% is 60% from within what is the formula

  26. 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.

  27. 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.

  28. how to use if i give 12 pieces of item to shop keeper so i put 12 item then auto it increase 1 item in scheme if i put 24 item then auto it increase 2 item in scheme.

  29. %GE OF SERVICE TAX IN DIFFERENT PERIODS.
    PLEASE HELP ME, HOW TO WRITE FORMULA IN EXCEL SHEET
    REGARDS
    T K MITRA

  30. HOW TO CALCULATE SERVICE TAX IN THREE DIFFERENT PERIODS, E.G.

    DATES : 31/12/13 = 31/12/13 : 12.36%, >= 01/04/2015 : 14%

    PL. WRITE THE FORMULA IN EXCEL SHEET

    REGARDS

  31. How to use absolute cell references as necessary so that you can copy the formula, in cell G4, construct a formula to calculate the Percent of Total Sales for the first region. Copy the formula down for the remaining regions.

  32. Please can you help?
    I need an efficient workaround to discount a select group of products (given in a table with the percentage to reduce/increase price) from a huge database of products (given in a seperate list). the result should be updated prices for those products which should be discounted and all other product prices not affected by discount to remain the same.

  33. =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.

  34. 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.

  35. 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 ?

  36. 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



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)