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 ?
posted on 22.06.2019 at 18:02
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



posted on 24.06.2019 at 18:26
1pnshow more
TimTim
share on facebookshare on twitter
2021 AnswerTabsTermsContact us