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 ?
0
give a positive ratinggive a negative rating
22 Jun 2019 at 06:02 PM
Hi,

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



1
give a positive ratinggive a negative rating
24 Jun 2019 at 06:26 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
2024 AnswerTabsTermsContact us