# How to Calculate Percentage of a Number in Excel (5 Easy Ways)

We need to calculate percentages in our day-to-day lives quite often. Excel can help us get any percentage with ease and in no time at all. In this article, we will show you 5 easy ways to calculate percentages in Excel. We have considered different scenarios while calculating percentages. This article will answer all your queries related to how to calculate the percentage of a number in Excel.

## 5 Easy Ways to Calculate Percentage of a Number in Excel

In this article, we have included 5 different scenarios and shown how how to calculate percentage of a number in Excel.

### 1. Percentage of a Number from Another Number (Percentile)

Suppose we are to determine the percentage of a number. In this case, we have 3 different columns namely Number, Percent, and Amount. We will find the percentage of the Number column in the Amount column.

To do so, we will multiply the number with the percentage. In the D5 cell, we will write,

`=B5*C5`

Pressing the Enter key we will get the result in the D5 cell.

Now by dragging down or double-clicking the Fill Handle to use the AutoFill feature of Excel we will get values in corresponding cells.

### 2. Getting Percentage from 2 Numbers in Excel

If we wish to find out how much a number is in terms of the percentage of other numbers we can do it using Excel. Consider the following example. We need to find out how much each student has obtained in terms of percentage of the total number. To do so, we need to divide obtained marks by total marks.

In cell E5 we type,

`=C5/D5`

Pressing the ENTER key we will get the result.

Now to express it in percentage terms, we will go to the Number ribbon and select the Percentage symbol.

We can also go to the Drop Down menu and select Percentage.

We will get the results in a percentage format.

Now by dragging down or double-clicking the Fill Handle to use the AutoFill feature of Excel we will get values in corresponding cells.

### 3. Calculating Percentage Change of a Number in Excel

We can calculate the percentage change of any data in terms of other data. Consider the following example. We are given the sales data of a company. It shows the sales of four quarters. We want to calculate the percentage change in sales with respect to the previous quarter. To do so, first, we need to find out the difference between sales in two successive quarters and divide it by the sales in the former quarter.

In cell D6 we type,

`=(C6-C5)/C5`

Formula Breakdown

`(C6-C5)` >> Gives us the value of the difference between the sales of two successive quarters.
Â  Â  Â  Â  Â  Â Output is >> 2000
Â  Â  Â  Â  Â  Â Explanation >> The difference in sales between Quarter 1 and Quarter 2

` (C6-C5)/C5`>> Gives us the relative change in terms of sales of previous Quarter
Â  Â  Â  Â  Â  Â Output>> 0.20
Â  Â  Â  Â  Â  Â Explanation >> Gives us the relative change in terms of sales of Quarter 1

Pressing the Enter key we will find the result in cell D6.

Using the steps shown in the previous method we will find the percentage.

Now by dragging down or double-clicking the Fill Handle to use the AutoFill feature of Excel we will get values in corresponding cells.

### 4. Percentage of a Number in Terms of a Total

Now suppose in the example of the previous method we want to see how much the sale of each quarter in terms of total sales of that year.
To do so, first, we will calculate the total sales of the year by adding the sales of all 4 Quarters. To do so, we will simply add the sales of 4 quarters.

We have used the SUM function to add the values. Click to know more about the SUM function or how to add in Excel.

Then we will express the sales of each quarter in terms of sales of that year. To do so, we will simply divide the sale of each quarter by the total sales of the year.

In cell D5, we type

`=C5/\$C\$9`

We use Absolute Referencing here as the total sales for the year remain the same for all the quarters.

Pressing the ENTER key we will get the result in cell D5.

We can turn the value into a percentage format by using the steps in method 2.

Now by dragging down or double-clicking the Fill Handle to use the AutoFill feature of Excel we will get values in corresponding cells.

### 5. Increase or Decrease a Number by a Percentage in Excel

Sometimes we want to increase or decrease a number by a percentage. Using Excel, we can do this in a jiffy!! Letâ€™s look at the following image. We have some numbers in the Number column. We want to increase or decrease these numbers by the percentages in the Increase (Decrease) by Percent column. To do so, we will have to add the percentages with 1 and multiply them with the numbers.

In the D5 cell we type,

`=B5*(1+C5)`

Formula Breakdown

`(1+C5)`>> Gives us the value of increased or decreased percentage value with the original number.
Â  Â  Â  Â  Â  Â  Output is>> 1.20
Â  Â  Â  Â  Â  Â  Explanation>> The number 19022 will be increased by 20%

`B5*(1+C5)`>> Gives us the increased amount.
Â  Â  Â  Â  Â  Â Output is>> 22826.4
Â  Â  Â  Â  Â  Â Explanation>> 19022 * 1.20

Pressing the ENTER key we will find the result in the D5 cell.

Now by dragging down or double-clicking the Fill Handle to use the AutoFill feature of Excel we will get values in corresponding cells.

## Things to Remember

Percentage values should be less than 1 when they are in number format. Expressing values that are greater than 1 in percentage terms may result in a large number.

When calculating percentage increase or decrease, be careful about what you choose as the denominator. Selecting the wrong denominator may yield in the wrong result.

## Practice Section

We have included a practice section in the worksheet provided so that you can practice the methods yourself.

## Conclusion

Percentage calculation in Excel is a fairly easy and simple operation. This article has guided you through 5 different methods to do so. Feel free to reach out to us with any of your Excel-related problems. Our team will get back to you at the earliest convenience. If you have any queries, leave a comment or feedback below.

## Related Articles

#### Lutful Hamid

Hello! Welcome to my Profile. I have completed BSc in Naval Architecture and Marine Engineering from BUET and MBA from IBA. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this.

We will be happy to hear your thoughts

5 Excel Hacks You Never Knew