In calculating percentages in Excel, there are a lot of ways that you could do this:

  • What is the percentage of a number?
  • What is the percentage change of value i.e. The percentage increase or decrease
  • What is the proportion against a total value?

How to Calculate Percentage in Excel

Let us go over each method in the tutorial below:

DOWNLOAD EXCEL WORKBOOK

STEP 1: What is the percentage of a number?

To calculate the percentage of the number, simply multiply the number and the percentage together:

Percentage x Number

75% * 100

How to Calculate Percentage in Excel

 

STEP 2: What is the percentage change of value i.e. The percentage increase or decrease

To calculate the change in value as a percentage, get the difference of the new value and the old value, then divide it by the old value:

(New – Old) / Old

(150 – 100 ) / 100

How to Calculate Percentage in Excel

 

STEP 3: What is the proportion against a total value?

To get the proportion as a percentage, divide the portion by the total amount:

Portion / Total

12/20

How to Calculate Percentage in Excel

 

STEP 4: We are almost done! The last two values are not in the percentage format, so let’s fix that.

Select the last two values and go to Home > Number > %

 

How to Calculate Percentage in Excel

Your percentage values are now all ready!

How to Calculate Percentage in Excel

 

How to Calculate Percentage in Excel

How to Calculate Percentage in Excel

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Data Bars, Color Scales & Icon Sets Conditional Formatting has improved in Excel 2010 with the introduction of Data Bars, Color Scales & Icon Sets.Data Bars: Includes graphic bars in a cell, proportional to the cell’s value - Good for Financial AnalysisColor Scales: Includes a background color, proporti...
Excel´s Fill Justify Tool An interesting tool within Excel is the Fill Justify.  It allows you to select text from several rows and merge them in to one cell.So if you have data that gets downloaded in to separate rows and want to join them up in to one sentence, then the Excel´s Fill Justify option i...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list.A dynamic drop down list expands as the Excel Table expands when new data gets added to it.This is great when you want to have users select from a predefined ...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count.This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit.DOWNLOAD...