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 3. Total comments: 342

  1. please i want the to formula calculating 12.5% of basic salary as salary tax.
    and 10% of basic salary as rent allowance on Excell. let us say basic salary is as fellow s
    1year-5000
    2year-2000
    3year-1000

    1. Hello Eugine!
      If I understand your task correctly, the following formula should work for you:

      =IF(A1=1,5000*(0.125+0.1),IF(A1>=3,1000*(0.125+0.1),2000*(0.125+0.1)))

  2. Hello! I understand your discussion great! Super helpful. Is there a way i can make my numbers automatically round up in the same answer column? For example, i am finding 15% of 242 to = the number of records i need to pull for a review. However the answer is 36.3. Is there a way to make any answer automatically round up to the next whole number? Thanks for your help:)

    1. Hello Samantha!
      If I understand your task correctly, the following formula
      =ROUNDUP(A1*0.15,0)
      If there is anything else I can help you with, please let me know.

  3. Isn't the first example of apples wrong?
    If I have 20 apples for 5 friends, then each should receive 20% and not 25%.
    I think that formula is not suitable for this example.

    1. Hi Hermes,

      Our example is different from yours, please read carefully :)

      Suppose, you have 20 apples and you gave 5 to your friends (not to 5 friends, you just give 5 apples to someone). How much did you give, percentage wise? The answer is 25% (i.e. 5 is 25% of 20).

  4. Hi,
    Thank you for this article. I may have a slightly complicated case.
    Cells A1 through A3 have fixed values. Cells B1 through B3 will have different percentages. Cell B4 will have the total of Cells A1 through A3 after they have been adjusted by the corresponding percentages in Cell B1 through B3. For instance, A1 is 10, B1 is 100%. A2 is 20, B2 is 50%. A3 is 30, B3 is 0%. The expected value in B4 should be 20. What is the correct formula to use in B4, and is there a way to use ranges for this so that if I insert more rows they will automatically be captured in the formula?
    Thanks very much.

    1. Hi, it's me again. I just wanted to say that a friend of mine helped me out to use the SUMPRODUCT function properly. I had incorrect syntax. =SUMPRODUCT($A1:$A3,B1:B3) is what should be in cell B4. Also the reason I use dollar signs in front of A1 and A3 is because when I copy this formula to column C so that I can give a different set of percentages, C4 will still reference the initial values in the A column. I hope that someone out there finds this information useful.
      I also want to thank the author for using a comment section that does not require registration. I know there is a lot of abuse out there with bots, but I'm the type of person that doesn't bother posting if there's registration required.
      Best regards,
      CK

  5. 300 is total and 192 is marks then how many percentage

    1. =192/300*100

      =64%

  6. Please, how to calculate the value plus 5 percent of the value

    1. Hi Salisu,

      Assuming the value is in A1, use one of these formulas:

      =A1+A1*0.05 or =A1*(1+5%)

  7. HELLO I WANT TO ASK YOU HOW TO MAKE A PERCENTAGE IN THIS FORM 12/% , BECAUSE I'M TRYING BUT I FAIL WHY I NEED TO GET THE BEST STEPS ABOUT THAT FORM.

    1. Hi, 1st of all you should type digits or any price,
      Example, 350
      Start fromula. =350*12/100 Enter.....

  8. how can i calculate, if the value is 2350/-(25%) , i need to find out the value of 75%, please give the formula.

    1. =2350*0.75, does it answers?

  9. I need to add the GST of 15% to total

    1. when I calculate the GST 13% on a particular amount the GST amount in cents shows difference with 1 cents some time up sometime down. Is there any fix formula for this GST increase and decrease on cents

  10. For example, I have purchased a book at Rs. 495/-. Now, I want to calculate 25% off on this book then what will be the formula for this?

    1. =495*25/100

      Amount you want to calculate, it has to be multiplied by the percentage then it has to be divided by 100

      =495*25/100= 123.75
      so you need to pay (495-123.75)=371.25

      1. 495*(1-.25)= 371.25

  11. just need the formal $ 3580.69 % of $ 44775.39

    1. =3580.69/(44775.39/100), A1=3580.69, B2=44775.39, =A1/(B2/100), cell format chosse persentage, done

  12. Hi,
    I need to work out what percentage of people achieved a certain result range. For example, how many of a percentage achieved 99-99.90 and next group 98-98.95.
    Thank you.

    1. Please I need the answer to the same question Rita asked. Kindly help me with the formula to use. Thank you.

  13. Hello friends, I want help,

    I'm an sugar industry employee and I forget percentage formula of:

    for example A vehicle No.123 has weight =17490 kgs, but he got deduction for bad variety 1749kgs, as percentage 10%

    please show me in excel with formulas,,

    1. Zameer:
      Where the weight is in A2 the percentage deduction is calculated by:
      =A2*0.1

  14. some value cell A16=2299 , How to calculate 20% value of a16

  15. 5400(old) 5880(new) how much increase in between old and new?

    1. Sagar:
      The formula in Excel is in an empty cell enter
      =New-Old

  16. I am trying to come up with a formula in excel to tell me how many invoices were paid on time based on net 45 vs. paid late?

    Invoice Date Terms Date Paid Days to pay Overdue
    6/29/2018 45 7/23/2018 24 No
    7/10/2018 45 8/13/2018 34 No
    7/11/2018 45 8/13/2018 33 No
    3/7/2018 45 5/17/2018 71 Yes
    3/16/2018 45 5/17/2018 62 Yes

    1. Dean:
      If you want the count of how many invoices were paid on time vs paid late using the data in your sample enter this in an empty cell:
      where the "Yes" and "No" text is in the range E16:E20
      =COUNTIF(E16:E20,"Yes").
      Then in another empty cell enter: =COUNTIF(E16:E20,"No") for overdue invoices.
      Do you need more formulas than this to get the analysis you want?

  17. Good morning, Please help I mam stuck. this is my formula but it does not want to take it.
    =IFSUM(G13>F13.100%);IF(OR(F13<G1390%)IF(OR(F13,G13<90%)

    1. Hello, Michelle:
      Seems as if there are several parts of the formula that should be corrected. I think you might benefit by reading an article here on AbleBits on using the IF OR statement. The article is at: https://www.ablebits.com/office-addins-blog/excel-if-function-multiple-conditions/
      If after reading this article and practicing some of the techniques described and you're still experiencing difficulties, post another question and you'll get some help.

  18. Please
    Sir I forget the formula of finding percentage
    in excel

    1. (Obtained Marks/Total Marks)*100

    2. C1=A1/B1 format C1 as percentage.

  19. I have a simple formula: 4688.8306 * 4% = 4876.3838

    When I check my work with: 4688.8306/4876.3838, I get 3.8462%

    Why are they different?

    1. Anna:
      When I multiply 4688.8306 * .04 I get 187.55.
      When I divide 187.55 by 4688.8306 I get .04.
      Are there some other numbers that aren't visible in the formulas?

  20. I'm trying to caculate the percentage of but 3 words
    Open
    Closed
    Ongoing

    I need the percentage of the closed and ongoing to be collective to make up the done.
    Can anyone assist please?

    1. Amelia:
      Sum the numbers in the Open column, then sum the numbers in the closed column, then sum the numbers in the ongoing column.
      Add the closed value to the ongoing value then divide the value of the open column by this total.

  21. plz can u give me solution about this
    =866.50+60 *1% answer is 917.235

    1. Viny:
      When I enter this: =(866.5+60)*0.01, Excel returns 9.265.
      Is there something else that should be entered in the formula?

  22. I am trying to equate the percentage of each employees work load by the total workload for all. I want to calculate individual workload by total workload for all. For instance in Cell F2 I have 66 and the total overall in cell F9 is 500. If you could please give advise I would greatly appreciate it. thank you so much

    1. Divide the individual by the total like this:
      For example in G2 enter =F2/F9
      then format G2 as percentage in the Format Cell window.

  23. can u give me solution about this
    =(130-80)*8+800+6.45*50 calculate total amt less 10% and show last amt 1370
    thanks

    1. Viny:
      Here's a solution that shows you all the steps.
      =((130-80)*8+(800+6.45*50))-(((130-80)*8+(800+6.45*50))*0.1)
      BYI, this returns 1370.25.

      You could substitute cell addresses for some of these hard coded numbers and make this a little more flexible.

  24. I want know this

    value is 3410
    after percentage = 1747.68
    so want what is percentage in this value

    1. 1747.68/3410

  25. I am trying to add a number to a percentage formula. My current formula is: O143+O143*Q143, which equates to a number in "O143" multiplied by a percentage in "Q143". After that is calculated, I want to add a number that is not affected by the percentage to the total in the first equation. For example, the number in O143 is $5,999.58 and the percentage in Q143 is 3%. The number to add, $75.64, is in N143. I have tried doing "+N143" but that does not give me the correct total. The total should come out to be: $6,255.21. Please provide help to this formula to come to the correct total.

    1. The equation should be =(O143*Q143)+(N143+O143)

  26. I want to see the % increase in excel from Value A to Value B
    Value A = 0
    Value B = 455

    Formula Applied (B-A)/A, but it gives #DIV/0. Can I get the % in results instead?

    1. The Microsoft Excel Help site has a good explanation of working with this situation. Search "How to correct a #DIV/0! error" and you'll see the work a-rounds.

  27. Dear sir,
    hope your are fine, kindly solve my this problem i want to take 50 percentage of 37800 in other column in excel sheet. how i can do this.

    God Bless you.
    Regards
    Atif Durrani

    1. Hello,

      If I understand your task correctly, please try the following formula:

      =A1*50%

      Where cell A1 is “37800”

      Hope this will help.

  28. I have an Annual Budget of $1,450,00, I need to insert formulas that will calculate total amount for each department based on the specified percentage of the annual budget

    1. Hello,

      If I understand your task correctly, please try the following formula:

      =A1*25%

      where cell A1 is “$1,450,00”

      Hope this will help you!

  29. I have a simple issue that I don't know how to do since I am not a financial person.
    Cell A I have amount to receive from my clients, Cell B I have to pay the money to get the job/product. I need cell C to show what percent I have made out of it. Hope you understand. Thank you in advance. TC

    1. Hello,

      If I understand your task correctly, please try the following formula:

      =(A1-B1)/100

      Hope this will help you!

  30. How to calculate the % of specific text in Excel:

    For example:

    Orange
    Orange
    Red
    Blue
    Blue
    Blue
    Red
    Red
    Orange
    Orange

    What is the %'of red, blue and Orange? How to come up with a formula in Excel?

    1. Hello,

      Supposing you have a list of text data in column A, you can use the following formulas:

      =COUNTIF(A:A,"Orange")/COUNTIF(A:A,"<>")

      =COUNTIF(A:A,"Red")/COUNTIF(A:A,"<>")

      =COUNTIF(A:A,"Blue")/COUNTIF(A:A,"<>")

      Hope it will help you.

  31. Hello, I need to Calculate the percentage (%) of income that is being contributed to retirement in B20.
    Gross Income:B12 $45,926.40
    My Contribution:B14 $6,888.96
    Roth IRA:B16 $3,600
    Total Retirement Contributions:B17 $12,785.28

    Thank you

    1. Hello,

      If I understand your task correctly, please try the following formula:

      =(B14+B16+B17)/B12

      Please check that the Percentage format is applied to cell B20. To do this, open the Format Cells dialog either by pressing Ctrl + 1 or right-clicking the cell and selecting Format Cells… from the context menu. Make sure the Percentage category is selected and specify the desired number of decimal places in the Decimal places box.

      Hope it will help you.

  32. how can you find the average and total when you have salary, allowances,gross pay, tax(16%),and net pay.

    1. Formula,=AVERAGE,(all the numbers)

    2. please I really need it

  33. Hi
    I have 3 values in 3 column (e,f,g)e is booked patient,f is seen patients and g the number of no shows. to obtain g I have formulated the cell to =(E28-F28)/E28 e.g to give me a percentage of no shows.
    however when I have zero values in E and F I get this error message #DIV/O in G.
    I cannot seam to find the right equations to reflect g as a 0% until numbers have been populated in e and f.
    any recommendation gratefully appreciated
    regards

    1. Hi, Grag,

      the point is that when a number is divided by zero (0), Excel shows the #DIV/0! error. It happens with your formula when there's nothing in F28 cell. Please try the following formula in G28 instead:
      =IF(F2>0,(E2-F2)/F2,0)

      If you want to learn more about the IF function, please have a look at our article that explains how the functions works.

  34. 10-2%=9.8
    TELL ME FORMULA

    1. Hello, Ram,

      If you take a quick look at this point of the article, you'll see that to decrease an amount by a percentage you need to build the following formula:
      = Amount * (1 - %)

      For instance, the formula =10*(1-2%) reduces the value by 2%. Don't forget to set Number as a number format.

  35. I Wanna calculate in percent
    e.g.: for $350 i want to add 20%

    And for each $ less than $350 should be added 5.7% more to the 20%
    e.g.: for $349 should be added 25.7% and for $348 should be added 31.4% etc.

    How can I write it in a formula in excel ?

    Thanks
    Catalog Manager

    1. A B C D
      350 20 0 0
      349 20 5.7 25.7
      348 20 5.7 31.4
      347 20 5.7 37.1
      346 20 5.7 42.8
      345 20 5.7 48.5
      344 20 5.7 54.2
      343 20 5.7 59.9
      342 20 5.7 65.6
      341 20 5.7 71.3
      340 20 5.7 77
      339 20 5.7 82.7

      FORMULA IN D IS AS FOLLOWS
      =B2+($C$2*(ROW()-1))

  36. Maths=34
    Physics=45
    Biology=55
    Total=300
    Find percentage in exel give formula

    1. Name Maths Physics Biology Total Marks Obtained Percentage
      A 34 45 55 300 134 44.66666667
      Formula for Percentage-
      (Marks Obtained/Total Marks)*100

    2. I also don't know

  37. How do i get rid of divx errors when trying to work out growth percentages as per example below:

    =(U21-T21)/T21

    Always shows divx when it is dividing by 0 and this makes spreadsheet look unprofessional and i am struggling with the iferror formula to help with this kind of error.

    1. try =iferror((u21-t21)/t21),)
      That should leave it blank

  38. I am trying to figure out how to charge my adult children rent for the amount I am in the hole every month. I am in the whole $2,000 a month. I want to figure out how much each person will pay by there yearly income. Some make 40K, some 20K and 12K. Also, what is the formula to check the calculation.

    1. I would sum the total income (say total income is $100,000). Then determine each person's percentage of the income (whoever makes 12k would be 12%, and so on). Then you'd use that percentage to determine that person's share of rent (the person who makes 12k would pay $240).

  39. I have the following share price fluctuations:
    From To Appreciation
    Company A $100 $50 -$50
    Company B $50 $100 +50
    Company C $100 $200 +100
    Company D $200 $150 -50
    Shares were sold at $160

    Now, the total growth is 60 (i.e. 160 - 100) but each company contributed different portions. For example, Company A was no contribution, Company B no contribution as the price was from a loss to the same as allocation, but Company C moved from 100 to 200 = R100 contribution. However because the shares were sold at 160, they pick up the entire growth of $60. This is because D was a decline too.

    I have tried multiple formulas to help be calculate these contributions irrespective of how high or low the price was ut struggling. Anyone with an idea.Thanks

    1. old new + or - sold price contribution in percentage
      100 50 -50 160 -31.25
      50 100 50 160 31.25
      100 200 100 160 62.5
      200 150 -50 160 -31.25

  40. I am sorry if this has been covered above, please do let me know if this is the case....

    What I'd like to know is how can I generate various plus and minus percentages for a number? for instance, if I have to find out the values above and below the ranges of 1,5 and 10 percent? in one column I have the numbers I would like to work with and in the next columns I have plus 10%, minus 10%, plus 5%, minus 5%, plus 1% and minus 1%... Is there a way I can make excel work out the percentage values for the number in that column? Surely there's a quicker way than the old calculator method. Any help or tips would be greatly appreciated. thank you!

  41. Hi,

    I want to calculate the percentage of calls made per people in the room. For example there are 16 people in the room and I've made 50 calls between them. What is the percentage?

    1. Hi, Phillip,

      To begin with, you need to calculate the number of calls per person.
      If A1 – 16 people, B1 – 50 calls, then C1:
      =B1/A1
      And then in D1 you can count the percentage:
      =C1/B1
      Make sure to convert your number to percentage (Home tab > Number group > Percentage).

  42. 650=100%
    430=?

    1. 430 is variable

  43. Hi Svetlana.

    I want to follow % calc as you wrote above for entire column, but not able because of excel 2016 paste special appears different way. Could you explain please? thank you

    1. Hi Jey,

      In my Excel 2016, Paste Special seems to be the same as in the screenshots. Anyway, you can use the Paste Special shortcut that works in all Excel versions since 2007. So, here are the steps:

      1. Input your percentage formula (like =1+20%) in an empty cell, select it and press Crtl+C to copy the cell.

      2. Select the column (or a range of cells) that you want to increase/reduce by %, and press Ctrl+Alt+V to open the Paste Special dialog.

      3. Select "Multiply" or press M, and hit Enter. Done!

  44. I know it must be me but I have spent literally hours trying to find the answer to my percentage problem and have all but given up. It can't be that difficult.
    i have a register of students with for example 111101110 showing an individual's attendance and absence. What is the formula I need to use to show the % he/she attended - this is just so frustrating. Let's assume the register shows the marks in row D.

    1. Hello Derek,

      Is my understanding correct that for each student you have 1's and 0's in separate cells in the same row? If so, you can use the following formula to calculate the percentage of 1's in row 2, columns B to E:
      =COUNTIF(B2:E2, 1)/COUNTIF(B2:E2, "<>"&"")

      If your register is organized differently, please provide the details.

  45. The projected revenue for Jan, Feb and Mar are $1000, $2000, and $2500 respectively. The projected expenses as a percentage of revenue for each month are: Rent = 25%, Operating Expenses = 35%, Administrative expenses = 10% and Miscellaneous expenses = 8.5%. Create a projected Income Statement and formatted it so it looks good

    Month Rev Rent Operating Expense Admin Expenses Misc. Expenses Total Expenses Net Income
    Jan $1,000.00
    Feb $2,000.00
    Mar $2,500.00

    Rent Operating Expense Admin Expenses Misc. Expenses
    25.00% 35.00% 10.00% 8.50%

    1. how do I find a formula for the pecentage

  46. i need a small help.
    can u pls telll me how to create a formula so that,
    after adding between to box in a row, even if the answer is more than 100,the result displayed inthe total box should be only 100.
    that means the total value should not be shown more than 100.

    for eg:
    65+55=120, but in the total value box it should be only 100.
    thankyou,

    1. Hi Mathew,

      You can use the following approach: =IF(SUM()>100, 100, SUM())

      For example: =IF(SUM(A1:C1)>100, 100, SUM(A1:C1))

  47. Hi, Let say 49.90-20% = 39.92

    How to set this on excel.

    Thank you

    1. Hi Alice,

      In Excel, you can calculate it like this:
      =49.9-(49.9*0.2)

      1. thanks, this helped me too

  48. hi dear user
    hope you will be fine and happy
    i have one account that i got one thing 110 USD and sold on 200 USD how percentage will be my profit
    please show in formula
    Example: qty name purchase price sale price profit in percentage
    2 potato 111 200 how much will be
    wish you solve my problem and send me excel spread sheet

    1. Item name Qty Sale Price Total Purchase price profit Total Profit Percentage in profit
      Printer 2 200 400 300 100 200 How much will be
      Key board 3 150 450 260 110 330 ×

  49. If I copy formula for percentage in a new cell for e.g B1/A1 and cell A1 and B1 are empty in same case the result is #DIV/0!. How can make that this result bi hiden untill I put number at cells A1 and B1. Thanks

    1. Hi Arben,

      You can embed the percentage formula inside the IF function like this:
      =IF(AND(A1<>0, B1<>0), B1/A1,"")

  50. hi,
    i have a prize fund of £800 (but this may change weekly) how do i work out on excel how to split the fund into prizes of 40% 20% 10% etc

    1. Hi Kev,

      Supposing you have the prize fund in A1. Then, you can calculate the desired percentages using a few simple formulas similar to this: =A1*40%

      Or, you can enter the percentages in a few cells, say B1, C1, and D1, and then calculate the amounts by multiplying the total fund by percentage, e.g. =$A$1*B1

      If you opt for the second way, then you can check if the specified percentages add up to 100% using this formula:

      =IF(SUM(B1:D1)=100%, "OK", "parts do not add up to 100%")

      Where B1:D1 are cells where you've entered the percentages.

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