How to calculate a growth rate in excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-2-2.jpg)
Growth rate shows how much progress there is compared to a previous period. To do that in Excel, it requires some mathematical knowledge to execute it.
Step 1 – Click on an empty cell
![](https://spreadcheaters.com/wp-content/uploads/Step-1-2-2.jpg)
Click on the empty cell and start adding in the formula.
Step 2 – In the formula bar right in the following:
(Present ValuePast Value-1)*100
![](https://spreadcheaters.com/wp-content/uploads/Step-2-2-2.jpg)
For this example, B3 is the present value and B2 as the past value. Do take note that I intentionally skipped a single line mainly because you always have to take the past value as reference.
Step 3 – Press Enter
![](https://spreadcheaters.com/wp-content/uploads/Step-3-1-2.jpg)
Pressing Enter automatically shows the output of the formula.