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.

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

what is percentage

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.

Percent Increase or Decrease

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

percentage change: increase or decrease

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

percentage change: increase or decrease

Step 3:

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

nNumber command in Excel

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

Format cells in Excel

After doing the above, we obtain the following figure-

Percentage increase or decrease

Step 5:

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

Percent Symbol in Excel

And you will obtain the following illustration:

Percentage increase or decrease

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.

Percent Increase between Two Numbers

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

Percent Increase among Three Numbers or More Numbers (Sequential Percentage)

Step 2:

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

Number format in percentage between three numbers

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

Number format in percentage between three numbers

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

Percent Increase among Three Numbers or More Numbers (Sequential Percentage)

Step 5:

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

Percent Symbol in percentage between three numbers

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

Percent Increase among Three Numbers or More Numbers (Sequential Percentage)

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

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

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

Leave a reply

ExcelDemy
Logo