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:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

How to Use Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013. It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows lite...
Find Blank Cells In Excel With A Color In Excel you can have a data set that comes from an external source which isn't always formatted to your liking. One of the most common things you may encounter are blank cells in your Excel data which can hinder your analysis, especially if you are using a Pivot Table to anal...
Use Excel Goal Seek To Find The Formula Result You... If you have a formula and want to show a specific result, but you do not know what input values to change within the formula, then Excel's Goal Seek feature is the one for you. Imagine you are calculating the payment terms on a loan. Your PMT formula gives you an amount of ...
Format Cells: Special Numbers If you have a list of values that come from a database and want to format them in Excel using a special number format like a Zip Code, Social Security Number or Phone Number, then this is possible using the Format Cells dialogue box and choosing the "Special" number category. ...