If you are looking for **how to calculate percentage between multiple numbers in Excel**, then you are in the right place. Calculating percentage is an indispensable and useful necessity in many aspects of our life. For example, calculating discounts in shops, bank interest rates, rates of inflation, etc., the percentage is always useful. In this article, we’ll try to show you some basic concepts, formulas, and especially methods about how to calculate percentage between multiple numbers in Excel.

**Download Practice Workbook**

## What Is Percentage?

A percentage is a number or a ratio that is represented as a fraction of a whole number. For example, **X** person got **89** marks out of **150**. If we want to express the marks of** X** into a percentage, it will be **(89/150) =60%**.

**2 Ways to Calculate Percentage Between Multiple Numbers in Excel**

We can calculate percentages between two numbers or between multiple numbers. In the case of two numbers, we have to calculate based on the two data, and in the case of multiple numbers, we need to calculate based on multiple numbers. Both of cases the formula is quite similar.

Simply, the formula for the percentage change.

`=(new value-old value)/old value*100`

To show these, we have made a dataset named **Dataset of Sales**. It has column headers as **Stock at January (Unit)**, **Stock at February (Unit)** and **Stock of March (Unit)**. The dataset is like this.

We’ll now discuss the ways to calculate percentages.

**1. Percentage Change Between Two Numbers**

To calculate percentage change between two numbers, we need to use simple arithmetic formula. Percentage change can be two types.

- Percentage Increase
- Percentage Decrease

When the second value i.e. the new value is greater than the first value i.e. old value, then the percentage change becomes positive and it is mainly a percentage increase. On the other hand, when the second value is smaller than the first value, the percentage change becomes negative which means a percentage decrease.

In the figure below, we’ll try to calculate the percentage change between two values in the **Column D**. The two values are **Stock at January** and **Stock at February**.

We just need to follow the steps below.

**Read More: How do you Calculate Percentage Increase or Decrease in Excel**

**Steps:**

- Firstly, type the formula in the
**D5**cell that we mentioned earlier and it is.

`=(new value-old value)/old value`

In this case, it is.

`=(C5-B5)/B5`

Here, **C5** and **B5** refer to the first value of **Stock of January** i.e. **10** and **Stock of February** i.e. **15** respectively.

- Secondly, press
**ENTER**to get the output as**0.5**. - Thirdly, use the
**Fill Handle**by dragging down the cursor while holding the**right-bottom**corner of the**D5**cell like this.

- Eventually, we’ll get the output like this.

- Fourthly, select the cells
**B5:B11**> click the**%**sign of the**Number**group command.

- And finally, we will obtain the following illustration.

In the above figure, especially in the **5th** **Row**, we see that the quantity of **Stock at February** is higher than **Stock at January**. That’s why we found an increase in the percentage. Similarly, the percentage is increased in the **6th**, **7th**, and **8th** rows. On the contrary, we see that the quantity of **stock at February** is lower than that of **January **in the **9th**, **10th**, and **11th** **Rows**. For this, we found that the percentage has decreased and this situation will happen for every case when the second value is lower than the first value.

### 2. Percentage Change Among Three or Multiple Numbers

We can also calculate percentage change among three or more numbers by using the arithmetic formula. In this case, the formula is slightly different that the formula in the case of two numbers. Here, we’ll bring the consecutive numbers to calculate percentage change in the formula like this.

`=(first value-second value)/(third value-second value)`

**E Column**.

Now, we need to proceed with the following steps:

**Steps:**

- Firstly, write the following formula in the
**E5**cell like this.

`=(B5-C5)/(D5-C5) `

Here, where **A2** is the first value, which is **10**, **B2** is the second value which is **5** and **C2 **is the third value which is **20**.

- Secondly, press
**ENTER**and use the**Fill Handle**to get the output like this.

- Thirdly, select the cell of
**E5:E11**> click the**%**sign of the**Number**group command

- And finally, you will get the percentage increase among the three numbers.

## Conclusion

This is the way we can calculate the percentage increase between multiple numbers in Excel. Even if calculating percentages manually is not your favorite work, you can easily calculate using formulas in Excel from now on. I appreciate you for reading this article and leaving any opinions or comments below.

## Further Readings

**Calculate Year over Year Percentage Change in Excel (Advanced Technique)****How to Calculate Sales Growth Percentage in Excel****How to Calculate Grade Percentage in Excel (2 Easy Ways)****Calculate Average Percentage in Excel [Free Template+Calculator]****How to Calculate Growth Percentage Formula in Excel****How to calculate salary increase percentage in Excel [Free Template]****Excel formula to calculate percentage of grand total (4 Easy Ways)**

Hello, How do I calculate count change and percent change with many values given?

The formula for calculating count change is simply final avalue – initial value. But my teacher want me to do it for like 10 different columns the amount of burglaries from 2000-2011. Each year has a value example year 2000 38352, 2001 32763, 2002 31275, 2003 29110, and so on. So if I were to calculate the “count change” with two numbers i know what to do but with all of this numbers I don’t know how, and then after that I have to calculate the “percent change” for all these numbers. Do you know how this is done. Maybe I am just very confused.thank you

Dear Nelly,

Actually, percentage change mostly fits between two numbers. There is no specific formula to calculate percentage change among multiple numbers. Rather, when we face percentage change calculation, it means we are simply asked for the percentage change between the first number and the last number. In this case, the formula is.

=((Final Value – Initial Value)/Initial Value)*100

As your teacher has given you 10 different columns of values, you can calculate percentage change for each 2 individual columns and finally find a mean value of percentage change.

This is like.

=((2nd Value – First Value)/First Value)*100

Then,

=((3rd Value – 2nd Value)/2nd Value)*100

Similarly, following the same formula find all the individual percentage change. For 10 columns you will find 9 individual percentage change.

Finally, to find the mean.

=(Percentage Change of (Step 1 + Step 2 + …….+ Step 9))/ 9

Similarly, this statement is true for calculating count.

Regards,

Towhid

Excel & VBA Content Developer

ExcelDemy