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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Text To Columns: Dates Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes. Sometimes "Date" values are downloaded as "Text", so you cannot sort in the periodic date format. No worries!  Text to Columns ...
Excel Table Slicers Slicers were introduced with Pivot Tables in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons. You can see the power of Slicers and the different ways you can format them in these posts: https://www.myexcelonline.com/category/pivot-ta...
Show The Percent of Parent Column Total With Excel...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers suc...
Extra Excel Table Styles The Excel Table Styles give a user a choice of different styles ranging from Light, Medium and Dark. There are over 50 choices depending on your favorite style or company standard but you are not only limited to those. You have extra Table styles in the Page Layout tab in y...