The Problem
Reports often compare two periods side by side, but the raw numbers do not always tell a fair story. A product that gained 500 dollars might be doing great if it started small, or barely moving if it already had a huge baseline.
That is why percent change is more useful than plain subtraction in many business sheets. It explains the movement relative to where the item started, so growth and decline can be compared across products that do not share the same starting revenue.
The flow below shows the difference between movement and meaning. The old and new values create the movement, but the percent change turns that movement into something you can compare across the whole list.
The Problem: Reading Growth Fairly Raw movement only becomes useful after it is compared with the starting value.
In this workbook, each product has Q1 revenue and Q2 revenue. The sheet needs to calculate the growth percentage for each row, then use the summary area to show the total starting revenue and count which products grew strongly enough to pass the performance rule.
Compare the same item across two periods
old value -> new value -> percent change
row trend -> summary count
This keeps the report from overreacting to raw dollar changes. The row-level percentage shows direction and scale, while the summary gives a quick snapshot of how many items actually performed well.
How We Solve It
The standard formula is (New - Old) / Old. First find the difference, then divide that difference by the original value.
That gives you a decimal result which Excel can display as a percentage. Positive values mean growth, and negative values mean decline.
Method 1: Standard Percent Change
Method 1: Use the standard percent change formula based on old and new values.
This is the clearest version because it shows the story in the same order a person would explain it: find the difference first, then compare that difference to the starting value.
It is a good default for shared workbooks because the parentheses make the order obvious. Someone reviewing the sheet can immediately see that the formula is measuring change from the original period, not just dividing two numbers randomly.
=(C2-B2)/B2
Method 2: Compact Ratio Version
Method 2: Use a compact ratio formula that returns the same percent change.
You can also write percent change as New / Old - 1. This treats the new value as a ratio of the old value, then removes the original 100 percent baseline.
Some analysts prefer this version because it is fast to type and clean in dashboards. The caution is that it is less beginner-friendly, so the standard formula may be better when the workbook needs to teach or explain itself.
=C2/B2-1
Method 3: Measure Change Size Only
Method 3: Use ABS when you want the size of the change without caring about direction.
If the goal is to measure how large the movement was, not whether it went up or down, you can wrap the difference in ABS. That removes the negative sign from declines and focuses only on size.
This is useful in variance dashboards where a 15 percent drop and a 15 percent increase both deserve attention. It is not the best choice for this challenge's growth column, because here the direction still matters.
=ABS(C2-B2)/B2
Function Explanation
1. Division
Division is what turns a raw difference into a relative change. Without it, you only know the amount of movement, not whether that movement is large or small compared with where the item started.
That makes division the part of the formula that makes the report fair across different product sizes. A small product and a large product can be compared using the same percentage scale.
2. Parentheses
Parentheses make the order of operations clear. In the standard formula, they force Excel to calculate the difference before dividing by the old value.
That detail prevents a subtle mistake where only part of the expression gets divided. It also makes the formula easier for another person to read later.
3. Percent Format
Excel stores percent-change results as decimals, so formatting matters. A result like 0.25 is mathematically correct, but it is much easier to read as 25%.
That is why percentage formatting is part of the workflow, even though the underlying value stays the same. It helps the report communicate clearly without changing the calculation.
If the old value is 0, percent change formulas can break because you would be dividing by zero. That is a useful edge case to watch in real reports.
Calculate the percent change from Q1 to Q2 for each product, then review the summary section to see the total starting revenue and how many items grew by more than 20 percent. This gives you both the row-level trend and a quick performance snapshot in one sheet.