How to Calculate Percentage in Excel: Every Formula You Need
2026-03-18
Percentage of Total
What percentage of the total does this row represent? Value in A2, total in A100:
=A2/SUM(A$2:A$100)Percentage Change
Calculate the percentage increase or decrease between old (A2) and new (B2) values:
=(B2-A2)/A2Add a Percentage
Increase a price by 15%:
=A2*(1+0.15)Subtract a Percentage (Discount)
Apply a 20% discount:
=A2*(1-0.20)Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free