How to calculate percentages
Almost every percentage question is one of three: the part, the percentage or the whole. Learn to spot which one is missing and the rest is one multiplication or division.
Open the tool: Percentage Calculator
The percentage triangle
- Part = Percentage × Whole ÷ 100
- Percentage = Part ÷ Whole × 100
- Whole = Part × 100 ÷ Percentage
Reverse percentages
A jacket costs $84 after a 30% discount. The $84 is 70% of the original price, so the original was 84 ÷ 0.70 = $120. A common mistake is adding 30% to $84, which gives $109.20.
Percentages in Excel and Google Sheets
=A1*B1 gives B1 percent of A1 when B1 is formatted as a percentage (15%). =A1/B1 gives the share; format it as a percentage. Percent change is =(B1-A1)/A1, and increasing a value by 20% is =A1*(1+20%).