Two ways to compare numbers as percentages. One is directional, one is symmetric. Pick the right one for your context.
| Percent change | Percentage difference | |
|---|---|---|
| Formula | (new − old) ÷ old × 100 | |A − B| ÷ ((A+B)/2) × 100 |
| Symmetric? | No | Yes |
| Direction? | Yes (+ or −) | No (always positive) |
| Use when | Clear baseline / chronology | Comparing equals |
Anytime there’s a clear “before” and “after”, or one value is treated as the baseline:
When neither value is the baseline — typically when comparing two measurements of the same thing or two independent quantities:
Imagine two scientists measure the same plant: one gets 40 cm, the other gets 60 cm. Should the discrepancy depend on whose result is labeled “first”?
Two different numbers for the same discrepancy — unsatisfying. Percentage difference gives a single answer (40%) regardless of order.
Because it always divides by the 'old' value, treating it as the baseline. If A is the baseline, you get one number; if B is, you get another. Percentage difference avoids this by using the average of A and B as the denominator.
The four percentage formulas in Excel: percentage of a number, percentage change, percent of total, and formatting cells...
The same formulas work in Google Sheets as in Excel, with a few keyboard shortcut and formatting differences.
The percent key on different calculators does different things — here's what to expect on phone, desktop, and four-funct...