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 provides guidance on understanding percentages and a link to Microsoft's guide on using Excel to calculate percentages.
Relevant for Excel for Office 365,Excel for Office 365 for Mac, Excel 2019. Excel 2016
- A computer with Excel installed
- Some data that you would like to perform percentage calculations on this could be the percentage of a total, or the percentage change between two numbers.
A percentage is a proportion that shows a number as parts per hundred represented by the symbol '%'. So 25% means 25 out of every 100. Percentages can be confusing so if your not sure how or why to use percentages visit this BBC Bitesized guide:
Calculating percentages using Excel
Follow this Microsoft guide to using Excel to calculate percentages:
Last updated 3rd May 2019