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
2020 AnswerTabsTermsContact us
This site uses cookies to improve your experience, for analytics and ads. By continuing to browse this site you agree to our use of cookies.