Pinterest Pixel

How to Calculate Percentage in Excel

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

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

How to Calculate Percentage in Excel | MyExcelOnline How to Calculate Percentage in Excel | MyExcelOnline

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:

How to Calculate Percentage in Excel | MyExcelOnline

Download excel workbookHow-to-Calculate-Percentage-in-Excel-1.xlsx

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

 

See also  Pivot Table Count Transactions

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

 

 

If you like this Excel tip, please share it
How to Calculate Percentage in Excel | MyExcelOnline How to Calculate Percentage in Excel | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...