Calculating percentages 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, I am going to show you some basic concepts, formulas, and especially methods about how to calculate percentage increase between 3 numbers in Excel.

## Practice Spreadsheet

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

## Percentage Change: Increase or Decrease Between Numbers

Simply, the formula for the percentage change:

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

Inputting values into the above formula, the output may be positive or negative. The positive number depicts the percentage increase because the new value is higher than the old value.

In the above figure, especially in the 2nd row, we see that the quantity of stock in February is higher than that of January. That’s why we found an increase in the percentage. Similarly, the percentage is increased in the 2nd, 3rd, 4th, and 5th row. On the contrary, we see that the quantity of stock in February is lower than that of January. For this, we found that the percentage has decreased and this situation continues till the 8th row.

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

Now let us explore how we get the percentage change. These are the required steps:

**Step 1:**

Type the formula that I mentioned earlier and it is:

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

As the new value is B2 and the old value is A2, we get `=(B2-A2)/A2`

**Step 2:**

Drag the cursor of the mouse over the cell C2 and fill up the cells from C3 to C8 using **Fill Handle Tool**

**Step 3:**

Now we have to adjust the digits after decimals. For this, click the lower right corner of the group command **Number**

**Step 4:**

After clicking the **Number** command you will get the following. Now click the Number and make **Decimal Place** into 2 and press **Ok**

After doing the above, we obtain the following figure-

**Step 5:**

At this moment, click the % sign of the **Number** group command

And you will obtain the following illustration:

### 1. Percentage Increase between Two Numbers

When the new value becomes higher than the old value, the percentage will always increase. If we look at the following illustration, it is clear that the percentage is being increased for all rows.

### 2. Percentage Increase among Three Numbers or More Numbers (Sequential Percentage)

At first, we have to look over the formula for calculating percentage among three numbers:

**(first value-second value)/(third value-second value)**

Now, you may proceed with the following steps:

**Step 1:**

If we input the value, we will get **(A2-B2)/(C2-B2) **

where A2 is the first value,

B2 is the second value and

C2 is the third value

**Step 2:**

At present, we have to adjust the digits after decimals. For this, click the lower right corner of the group command **Number**.

**Step 3:**

After clicking the **Number** command, you will get the following. Now click the **Number** and make **Decimal Place** into 2 and press **Ok**

Step 4:

Drag the cursor of the mouse over the cell C2 and fill up the cells from C3 to C8 using **Fill Handle Tool**

**Step 5:**

At this moment, click the % sign of the **General** group command

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

## Conclusion

This is the way you can calculate the percentage increase between 3 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