How to Calculate Percent Change in Excel

Channel Avatar
Comment
X
Share
How to Calculate Percent Change in Excel
How to Calculate Percent Change in Excel
In this tutorial you will learn how to calculate percent change in Excel.

Don’t forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids – our feed
http://www.facebook.com/howtechtv – join us on facebook
https://plus.google.com/103440382717658277879 – our group in Google

In this tutorial you will learn how to calculate percent change in Excel.

Percent change, or percentile change, is a statistic indicator that shows the growth or decline between two values. It is also known as the rate of change or percent of growth rate.

The formula for percent change is:

Pc {(A-B)/B} x 100, where A is the first value, and B is the second value. Here is how you calculate it in Excel.

Prerequisites: Microsoft Excel.

Step 1. Launch Excel and open the document that needs to calculate percentile change.

Step 2. Enter the two values in two separate cells.

Step 3. Position the cursor to the cell that you want to hold the result.

Type the following:

((AAxx — BBxx)/BBxx)*100, where

AAxx and BBxx are the two values that you want to calculate the percentage change to.

Hit Enter. Excel will do the calculation and will display the result.

Result: Congratulations! You have learnt how to calculate percent change in Excel.

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *