To calculate a percentage change you need to calculate the difference divide the change by the original value and then multiply that amount by 100. Start by selecting the first cell in the Percentage of Change column. Take 10 percent and divide by 2nd percentage.
Calculating percentage difference of two numbers.
DV V2 100 V1 - V2 V1 V22 100 percentage difference. 20 - 30 -10 10. Divide the difference by the average. This is the actual change where the original value is subtracted from the new value.