Percent of vs Percent Change — The Mix-Up That Breaks Spreadsheets

Someone asks: “What’s 18% of 2,500?” Easy. Someone else asks: “Sales went from 2,500 to 2,950—what’s the percent change?” Also easy—until you use the first formula for the second problem and wonder why the dashboard looks optimistic.

I mixed these up early in my career on a discount sheet. The shopkeeper was kinder about it than my spreadsheet was.

Three questions that look alike

Percent of — part from a whole. Example: GST-style “18% of the base.”

Percent change — how much something moved relative to where it started. Example: revenue up from last month.

Percent remaining / leftover — after a cut, what’s left. Example: stock after a 30% clearance, or marks after negative marking depending on how the rule is written.

Same % symbol. Different story.

A quick way I decide

If there is only one amount and a rate, I’m usually doing percent of.

If there are two amounts in time (before and after), I want percent change: (new − old) / old × 100.

If someone says “after taking off X% what’s left,” I’m careful. Sometimes they want the remainder (100 − X)% of the original. Sometimes they want the amount removed. I ask one clarifying sentence before I calculate. It sounds pedantic. It saves arguments.

Where people get hurt

• Applying percent change math to a single-price discount
• Averaging percentages that shouldn’t be averaged (two different tax lines)
• Stacking discounts as if 10% + 10% equals 20% off (it doesn’t, unless the contract says so)

When I’m unsure, I run the same numbers through Percentage Calculator and label the mode in a cell comment: “percent of” or “percent change.” Future me is not smarter at midnight; notes are.

Tiny worked contrast

Base price ₹2,500, rate 18% → percent of → tax amount, then add if the quote is exclusive.

Sales ₹2,500 → ₹2,950 → percent change → +18%. Same digits, different meaning. That’s the trap.

If your work mixes GST, discounts, and growth charts in one workbook, write the question in plain language above the formula. The calculator is there when you want a second pair of eyes: Percentage Calculator.

More calculators live under /calculators. For tax-inclusive quotes, the older GST inclusive vs exclusive post pairs well with this one.