Find Percentage Change Between Numbers

by

The percent change formula is used very often in Excel. For example, to calculate the Monthly Change and Total Change.

1a. Select cell C3 and enter the formula shown below.

1b. Select cell C3. On the Home tab, in the Number group, apply a Percentage format.

Worked Example:   How to calculate percent sold in Excel

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

1d. Check if everything went alright.

2a. In a similar way, we can calculate the Total Change. This time we fix the reference to cell B2. Select cell D3 and enter the formula shown below.

Worked Example:   Find, Trace and Correct Errors in Excel Formulas using 'Formula Auditing'

2b. Select cell D3. On the Home tab, in the Number group, apply a Percentage format.

2c. Select cell D3, click on the lower right corner of cell D3 and drag it down to cell D13.

Worked Example:   Calculating Percentages in Excel

2d. Check if everything went alright.

Explanation: when we drag the formula down, the absolute reference ($B$2) stays the same, while the relative reference (B3) changes to B4, B5, B6, etc.

Leave a Reply

Your email address will not be published. Required fields are marked *