Percentages in Excel are often used in calculations to work out a percentage increase in sales or to calculate the percentage increase in a bill or service. This can sometimes give a better overview of the increase or decrease rather than just a difference between two numbers. This guide shows you how to calculate percentage of difference between two numbers in Excel. 

We have used Excel 2010, but the concepts will be similar in other versions.

You’ll need:

  • A computer with Excel installed 

Watch our screencast for instructions (click on the [ ] icon on the bottom left to make video full screen):

Karen Maxwell is a Digital Unite tutor and assessor/trainer of computer accessibility.