How to calculate percentage changes / growth in Excel ?

Hello, can you please give me advice how to simply calculate the percentage change between two numbers in Excel ?
22 Jun 2019 at 06:02 PM
0give a positive ratinggive a negative ratingshow more

To calculate percentage change in excel, you can use the following formula:

=( Second number - First number ) / First number

The formula should look like:

excel calculate percentage change

You will get the result:

excel calculate percentage change

Then you have to change formatting of the numbers to Percentage:

excel calculate percentage change

excel change formatting percentage

You should get the monthly percentage changes:

excel calculate percentage change

24 Jun 2019 at 06:26 PM
1give a positive ratinggive a negative ratingshow more
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook
2022 AnswerTabsTermsContact us