Calculate percentages

To calculate percentages in Excel, the basic formula is:

✅ Basic Percentage Formula

=Part / Total

Then format the result as a percentage (click the % button on the Home tab or use Ctrl+Shift+%).

📌 Examples

1. Simple Percentage

If:

• A1 = 50 (part)
• B1 = 200 (total)

Formula:

=A1 / B1

Result: 0.25 → formatted as % → 25%

2. Percentage Increase or Decrease

To calculate how much a value increased or decreased:

=(New - Old) / Old

Example:

• Old value (A1) = 100
• New value (B1) = 120

Formula:

=(B1 - A1) / A1

Result: 0.2 → 20% increase

3. What is X% of Y?

=Y * X%

Example: What is 30% of 500?

=500 * 30%

Result: 150

4. What percent is X of Y?

=X / Y

Example: What percent is 75 of 300?

=75 / 300 → format as % → 25%**

---