Excel's formula for calculating the increase degree is: (current year-comparison year)/comparison year = (b3-b2)/b2, which can be converted into percentage.

Tools/raw materials:

hp compaq dx7200

Windows 10

Excel20 10

1. Open the Excel table and click on the place where the growth rate needs to be calculated.

2. Next, enter the formula = = (B3-B2)/B2 in this box and press Enter to get the ratio.

3. Represent the data in the form of a percentage sign, click the "Data" section of the toolbar, find the percentage sign, and click.

You can see that the data is in the form of percentage.