# Calculate Percentage Increase between 3 Numbers in Excel

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.

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

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. 1. Reply  