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

Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data.You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot TableAdding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.See how easy it is to add some color to your analysis.DOWNLOAD WORKBOOK...
Unpivot Data Using Excel Power Query Power Query is a free add-in created by Microsoft for Excel 2010 (or later) and you can download and install it for Excel 2010 and 2013:Click to see tutorial on how to install Power Query in Excel 2013Click to see tutorial on how to install Power Query in Excel 2010In...
Copy The Cell Above In Excel Sometimes we get data that is downloaded from an external source and it is not formatted properly.You may have cells with missing data and cases where you want to copy the cell directly above to fill in your empty cell in Excel.This can be achieved with the following step...