How to calculate percentage in excel | Complete Guide
In this article, we’ll learn excel percent calculation. We’ll calculate percent, calculate percentage increase in excel and much more.
Calculation of percentage in excel is one of the most performed arithmetic calculations. Whether you want to calculate price after discount, deduct income tax from revenue etc. you’ll have to calculate % in excel.
Let’s now look at the basic Excel percentage formula and how to calculate percentage in excel.
Excel Percentage Basics
You would remember from your school days that a percentage is just a fraction of 100. It is calculated by dividing the numerator by denominator and multiplying it by 100.
For example: if we have 100 bucks and we give 40 bucks to someone, how much did we give percentage wise?
This is how we calculate percentage. In excel, the process is much simpler as excel does the calculation part for you.
In excel, there is no single formula which will cover every possible scenario. It’ll depend on what you’re trying to accomplish. Let’s see simple formulas like excel percentage formula, excel percentage change formula etc.
Excel Percentage Formula
Let’s look at what is percentage formula in excel. The formula is:
You don’t have to multiply it by 100, excel does that for you. Let’s say we have a dataset of marks of different students and we want to calculate percentage of marks scored by each student.
- In cell D2 type the formula =B2/C2 hit enter and drag the formula to the rest of the rows.
- Now the values in column D would be decimal values and that’s okay. We’ll just have to convert those values into percentage in excel. Select Column D then go to Home tab, under number group select Percent Style button.
- Voila! Now you have the percentage values.
You can follow the same steps to calculate percentage in excel.
Excel Percent Change Formula
Often you’ll be needing to calculate excel percentage change between 2 values. Let’s see how to calculate percent change:
The formula is:
=(New value – Old value)/ Old value
Let’s say you had 100 bucks yesterday and today you have 140 bucks meaning you have 40 bucks more than from yesterday. In this case, the excel percentage increase formula will be:
=(140-100)/100= 40/100 = 40 %
140 is the new value and 100 is the old value. Let’s see this now on excel.
- In cell E2 type the formula =(C2-B2)/B2 hit enter and drag the formula to the rest of the rows.
- Now the values in column E would be decimal values and that’s okay. We’ll just have to convert those values into percentage in excel. Go to Home tab, under number group select Percent Style button.
- Voila! Now you have the percentage change in excel
Some values might be in negative and that’s okay. It just means that for that specific item there have been a percentage decrease. While positive ones represent percentage increase in excel.
Calculate total and part value from percentage
Let’s look at few more scenarios where we have the percentage in excel but we need to calculate other things using the % in excel.
Suppose, we’re buying a product for $100 and now there is an additional VAT of 13% which is to be charged. Now how much more do we have to pay & what is the total amount we have to pay now?
Amount=Total * Percentage
Amount is the additional tax we would have to pay and Total is the base price of $100
Simply in cell D2 put the formula =A2*B2 to calculate additional tax.
Now, in E2 put =A2+D2 which will give you the new price you have to pay after adding VAT of 13%
Make sure the value in B2 is in percentage otherwise the calculation will return a much higher value.
Let’s say someone is selling you a second hand iPhone for $600 which is 30% off the original price. You want to find out the original price. As 30% is the discount we’ll deduct it from 100% which is 100-30=70%. We did this as 30% is the discount on price of 100% so in reality you’ll be only paying 70% of the original value.
Now we will use:
This is how it’ll look in excel:
In excel percentage formula is widely used in business operations while calculating prices and working with sales figures. One such function is Excel Percentile, do also read about it to understand how that works.
I hope this article was helpful to you and explained you formula for percent excel and calculation of percentage in excel.
If you have any questions or tips, I’d love to hear them in the comment section below.