To calculate the percentage increase between two numbers in Excel, you can use the following formula:

Percentage Increase=New Value−Original ValueOriginal Value\text{Percentage Increase}=\frac{\text{New Value}-\text{Original Value}}{\text{Original Value}}Percentage Increase=Original ValueNew Value−Original Value​

In Excel terms, if your original value is in cell A1 and the new value is in B1, enter this formula in another cell:

=(B1 - A1) / A1

Then, format the result cell as a percentage to see the percentage increase. This formula calculates the relative increase from the original value to the new value

. Alternatively, you can use this equivalent formula:

=(B1 / A1) - 1

which yields the same result

Example

• Original value in A1: 100
• New value in B1: 120
• Formula in C1: =(B1 - A1) / A1
• Result: 0.20 (or 20% after formatting as percentage)

If you want to calculate the new value after increasing the original number by a certain percentage, use:

=A1 * (1 + percentage)

For example, to increase 100 by 10%, use:

=100 * (1 + 10%)

which gives 110

Summary

• Percentage increase formula: (New - Original) / Original
• Excel formula example: =(B1 - A1) / A1
• Format the result as a percentage.
• To increase a number by a percentage: =A1 * (1 + percentage)

This method is widely used for financial, sales, and data analysis tasks in Excel