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

  1. 10 205 7 75.00%
    13 205 7 75.00% a)what % of the sample
    29 202 9 71.40% weigh 172 lbs or less
    3 201 10 67.80%
    11 200 11 64.20% b)what % of the sample
    7 196 12 57.10% is 200 lbs or more
    14 196 12 57.10%
    25 195 14 50.00%
    26 195 14 50.00%
    19 193 16 46.40%
    5 191 17 42.80%
    12 174 18 39.20%
    21 172 19 35.70%
    24 165 20 32.10%
    22 163 21 28.50%
    9 162 22 25.00%
    23 161 23 21.40%
    18 159 24 17.80%
    1 157 25 14.20%
    6 156 26 7.10%
    28 156 26 7.10%
    16 152 28 3.50%
    20 150 29 0.00%

  2. in excel you have a list of values in cell A1 through A40 explain in words or show the formula you would use to give the average of the values.

    pls gv me d ans

  3. Good day every one.am a novice in excel. So pls I need your help on this question...you as a business manager is expected to manage and keep your clients records, client I'D, client name and amount credited are inputs from the user of the package while amount debited and balance are computed fields where amount debited is 10% of amount credited.use the the figure below and write the formulas for: Amount debited and balance when 10% of the amount credited is the amount debited and the balance is what remains after taking away the amount the amount debited from the amount credited...so pls I want to knw the formulas for amount debited and balance...... Thanks

  4. HELLO EVERY ONE
    Any one me teach me Excel classes

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

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

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

  8. 100×6+1%=606
    How can i get this answer in excel.
    Tell me formula to get this answer.

  9. In Cell B14, calculate the Cost of Sales by multiplying the Sales Amount 60%. (Hint; In your formula, multiply the value in cell B6 times.6.) Copy the Formula to the range C14:E14.

    I'm sorry I am trying to figure this out. Like i know that there is a hint there but at the same time this is my first time doing this. Can someone help me asap before the night is over I would appreciate it

  10. Hello,

    I have to keep track of all the annual training for all the employees. The employess that have finished a training I mark the cell green, and for the training not yet completed I mark the cell red. I want to calculate percentage of green cells. How do I do that?

    Thank you very much!
    Iza

  11. You can use this formula for quick understand:-

    For eg.,

    Given amount is Rs. 18000. Interest 3%.

    Answer = (18000/100*3), is 540.

  12. Dear sir,
    please post easy percentage formula

  13. I have a total increase of 5%. Product A increased by 9%, Product B increased by 7%. How can I tell how much % Product A and B contributed to the overall increase?

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

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

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

  17. Hi everyone,

    I am building a spreadsheet with a number of columns holding information regarding audits that have been carried out on various establishments. About 10 of the columns will relate to regulatory articles and may or may not have a numerical figure entered in the row to the related establishment. What I want to do is find the percentage of rows within that column that have an entry against the total of audits (number of rows) completed.

    Hope someone can be of help.

    Many thanks.

  18. Hi,
    I want to calculate in percentage the adherence to plan in the work place
    Example 1: Planned 100 CTNS VS actual 90 Ctns = 90%
    Example 2: planned 100 Ctns VS Actaul 110 Ctns = because it was overproduced, i want the formula to calculate the inverse result, no 110%

  19. Hi,

    Hope you can help me on this, I have a spreadsheet with the left and right margins set at 0 and top and bottom set at 0.25. My paper size is 8 1/2x11” Landscape. My work is within the margins but when I do a print screen it shows 2 pages to print. The second page is blank. I am not sure way this happens.

    Thanks

  20. What a great article. As an example I would like to track percentage of sales Ytd vs lytd
    Customer x spent 25,000 last year and I have put in a 10% budget increase and this ytd has spent 8,000 what formula would I use to calculate percentage of budget ytd
    Thanks

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

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

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

  24. 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!

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

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

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

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

  29. 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!!!

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

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

  32. 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!

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

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

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

  36. HI,

    HOW TO CALCULATE THE PERCENTAGE OF THE TOTAL MARKS

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

  38. 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!

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

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

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

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

  43. 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%?

  44. 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!

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

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

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

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

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

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

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 :)