Percent Change Formula

Percent change formula is often used in Excel. For example, to calculate Monthly Change and Total Change.

1a. Once you have selected the C3 cell, enter the formula below.

Percentage Change Formula


1b. Select cell C3 and apply a Percentage format.

Percentage Change Format


We do not need to repeat Step 1a and Step 1b ten more times.

1c. Select cell C3, click the lower right corner of cell C3 and drag it towards cell C13.

Percent Change Formula


1d. Check that everything is all right.

Percent Change Formula


2a. Similarly, we can calculate the Total Value. This time we fix the reference to the B2 cell. Select cell D3 and enter the formula shown below.

Percent Total Change Formula


2b. Select D3 cell and apply a Percentage format.

2c. After selecting the D3 cell, click on the edge of the D3 cell and drag it down.

2d. Check that everything is all right.

Percent Change Formulas


Explanations: the absolute reference ($B$2) remains the same when the formula is traversed downwards, with the mutual reference (B3) B4, B5, B6 and so on. It changes as. Perhaps this is a very advanced step for you. , But it shows you one of the many other powerful features Excel offers.