A useful little explanation
Expected vs actual: calculate the gap without a spreadsheet séance
Expected 100. Got 120. The numbers are twenty apart, but “twenty” and “twenty per cent” answer different questions. Here is exactly what this calculator reports.
Put the expected number first
Enter two finite numbers in this order: expected, actual. For example, “100, 120” means you expected 100 and received 120. Use plain numbers without currency signs or thousands separators: enter “1000, 1200”, not “1,000, 1,200”. A comma separates the two values.
The signed difference is actual minus expected. In this example, 120 − 100 = 20. A positive difference means actual is numerically higher; a negative difference means it is lower. The sign is a direction, not a verdict on whether the result is good.
Use the baseline the tool actually uses
The percentage here is (actual − expected) ÷ |expected| × 100. The vertical bars mean the absolute value: the size of the expected number without its sign. For a positive expected value of 100, the result is 20 ÷ 100 × 100 = 20.00%.
Reverse the inputs and you ask a different question. Expected 120, actual 100 gives −20 ÷ 120 × 100 = −16.67%. The gap has the same size, but the baseline has changed. Percentages do not remember which answer you preferred.
Percentage change is not symmetric percentage difference
This tool asks how actual differs from a chosen expected baseline; swapping the numbers changes its percentage. If neither value is a baseline, you may instead want a symmetric percentage difference. For two positive values, one common convention is |actual − expected| ÷ ((actual + expected) ÷ 2) × 100. State that convention when sharing the result.
For 100 and 120, that symmetric calculation is 20 ÷ 110 × 100, or about 18.18%, whichever value comes first. This calculator instead reports 20.00% for expected 100 and actual 120. It does not calculate the symmetric convention. Keep the expected-first tool for comparisons with a genuine reference value; do not treat the two percentages as interchangeable.
Read the result in its own context
For a count of completed tasks, going from 100 expected to 120 actual might be welcome. For a count of spelling mistakes, the same calculation might deserve a quiet word. The tool compares numbers; it does not know what you wanted those numbers to do.
If the values are already percentages, distinguish percentage points from relative change. Expected 40%, actual 50% is a difference of 10 percentage points and a relative change of 25%. Enter “40, 50” and the tool displays a difference of 10 and 25.00%; you supply the units. It does not label a percentage-point difference automatically.
The pocket checklist
- Use the same unit and period for both numbers.
- Enter expected first and actual second.
- Read the signed difference before interpreting the percentage.
- For rates, label percentage points separately.
- Check the zero and negative baseline guide for those cases.
Displayed percentages are rounded to two decimal places. Arithmetic uses ordinary JavaScript numbers, so very large values or tiny decimal differences can show rounding artefacts. This is a quick comparison tool, not an exact accounting or measurement system.
Compare two numbers →