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
0pnshow more
NicoleNicole
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



24 Jun 2019 at 06:26 PM
1pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us