# Calculate Percentage Difference Between Two Numbers in Excel: 4 Methods

## Method 1 – Calculating Percentage Difference Between Two Numbers Manually in Excel

STEPS:

• Select cell D6 and type the formula.
`=((C6-B6)/AVERAGE(B6:C6))*100`
• Press Enter.
• Return the percentage difference.

• Use the AutoFill tool to get the other outputs.

## Method 2 – Applying Percentage Number Format to Compute Difference Between Two Numbers

STEPS:

• Click cell D6 and input the formula.
`=(C6-B6)/AVERAGE(B6:C6)`
• Press Enter.
• Apply AutoFill.

• Range D6:D8.
• Go to Home > Number > %.

• Itâ€™ll return the percentage of differences.

## Method 3 – Using Excel Format Cells Dialog Box to Get Percentage Difference

STEPS:

• In cell D6, insert the formula.
`=(C6-B6)/AVERAGE(B6:C6)`
• Return the result by pressing Enter.
• Use AutoFill.

• Press the Ctrl and 1 keys together.
• The Format Cells dialog box will pop out.
• In the Number tab, select Percentage.
• Press OK.

• The outputs will be transformed into percentages.
• See the picture below.

## Method 4 – Using Keyboard Shortcut to Get Percentage Difference in Excel Between Two Numbers

STEPS:

• Click cell D6.
• Type the formula.
`=(C6-B6)/AVERAGE(B6:C6)`
• Press Enter.
• Use AutoFill.

• Range D6:D8.
• Press the Ctrl, Shift, and % keys simultaneously.
• Get the percentage difference between the 2 numbers.

## Related Articles

<< Go Back to Percentage Change |Â Calculating PercentagesÂ | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Siam Hasan Khan

Hello! Welcome to my Profile. Here I will be posting articles related to Microsoft Excel. I have completed my BSc in Electrical and Electronic Engineering from American International University-Bangladesh. I am a diligent, goal-oriented engineer with an immense thirst for knowledge and an attitude to grow continuously. Continuous improvement and life-long learning are my mottoes.

1. So if Microsoft isn’t prepared to fix the DATEDIFF function – what is the alternative method of finding Years and part DAYS between dates.

• You can use the DATEDIF Function without any problem.
Thanks.

2. Sorry, isn’t this calculating the “percent change” and not the “percent difference”? Percent difference is the difference between two values divided by the average of the two values shown as a percentage.

• Thank you so much for pointing out the issue. We have updated the article. Now it’s alright. Please check.

Advanced Excel Exercises with Solutions PDF