How to Calculate Percentage in Excel

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?

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

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

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

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 > %

Your percentage values are now all ready!

How to Calculate Percentage in Excel

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin