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
by Svetlana Cheusheva, updated on
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
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!
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%
use the * not the x in the cell B1 ...sorry just noted that after it posted.
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 ??
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 ....
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...
that's the formula i need...thank you very much Ms.svetlana
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
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.
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 ??
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!
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
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.
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
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
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!!!
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.
Hi Danny,
Here you go:
=A2*B2+(A2*B2)*8.25%
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.
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)
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!
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!
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 %.
Ho to calculate current percents??
750000,how is calculate 750000 current percents?
Thanks
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.
HI,
HOW TO CALCULATE THE PERCENTAGE OF THE TOTAL MARKS
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?
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%)
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!
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
How do I add 40% to the first 100 dollars and then 29% after the first 100??
Hello, I am Cambodian, Please help me, How to find average and what is the formula to find it? please :)
Hi!
You can use the AVERAGE function. For example the formula =AVERAGE(A1:A10) returns the average of values in cells A1 through A10.
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
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%?
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!
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
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.
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.
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
Hi Jeff,
It can be either =C9*70% or =C9*0.7
Thank you
How did you get that number because I also now have to but in that column in different rows 15% 25%.
Jeff
Just subtract it from 100%. For example, 100% - 15% = 85% or 0.85 in the decimal form.
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.
%GE OF SERVICE TAX IN DIFFERENT PERIODS.
PLEASE HELP ME, HOW TO WRITE FORMULA IN EXCEL SHEET
REGARDS
T K MITRA
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
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.
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.
=IF(ISERROR((($K7+$M7)/$I7)),0,(($K7+$M7)/$I7))
Please explain what this formula means.... I think my percentages are not calculating correctly.
it means you've put to many nested if's in your formula.
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 .
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.
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 ?
Hi Kelly,
You can use the SUMIF() function to fulfill this task. Please see the following tutorial for more information:
https://www.ablebits.com/office-addins-blog/excel-sumif-function-formula-examples/
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
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.
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%
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.
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!
Hi Kyle,
You can use COUNTA to get the total count of non-blank cells, like this:
=COUNTIF(A1:A99999, "yes")/COUNTA(A1:A99999)