The Math Behind Percentage Increases
Most people mess this up because they grab the wrong number first. You take your starting value, subtract it from the new value, divide that difference by the original number, then multiply by 100. That gives you the percentage increase. It sounds simple enough until you're dealing with real numbers that don't divide cleanly, and then you start second-guessing your calculator work. The formula itself is ((New Value - Original Value) / Original Value) x 100. That's it. Everything else is just context around whether the numbers actually make sense when you plug them in. I've seen people divide by the new value instead of the original and call it a day. It happens more often than you'd think, especially in finance departments where someone copies a template from three years ago without checking the denominator. Let me walk through a real example. Say your product cost was $45 last quarter and it's $62 this quarter. The difference is $17. You divide $17 by $45, which gives you 0.3778. Multiply by 100 and you get approximately 37.78% increase. That's a concrete, verifiable number you can show on a spreadsheet or in a report without anyone asking for clarification.
There's an edge case that trips people up regularly. When the original value is negative or involves mixed signs, standard percentage increase calculations break down in ways that nobody warns you about. I ran into this with inventory adjustments where a item had been written down previously. The original value was effectively negative from an accounting standpoint, and the percentage increase formula produced results that were mathematically correct but completely useless for decision-making. What I ended up doing was switching to absolute dollar change for reporting and only using percentage when the baseline was positive and stable. It wasn't in any tutorial I'd ever read. Another thing nobody emphasizes enough is when the increase is tiny relative to the original. If something goes from 0.4 to 0.5, the formula gives you a 25% increase. That number looks impressive until you remember the actual change is a tenth of a unit. In operations and supply chain management, I've learned to always pair percentage increases with the absolute change figure. They tell two different stories and both matter depending on who's reading the report. Percentages also behave badly when you compound them. A 50% increase followed by a 50% decrease does not bring you back to where you started. It leaves you at 75% of the original value. This comes up constantly in budget discussions where a department gets a 20% boost and then a 20% cut the next year. People hear two similar numbers and assume they cancel out. They don't.
For quick mental math, you can approximate percentage increases without a calculator. If something goes from 80 to 100, that's a 20 point increase on a base of 80. Twenty is one quarter of 80, so roughly 25%. Not exact, but fast enough for most business conversations where precision to the decimal doesn't change the outcome. If you need to automate this across many rows, Excel or Google Sheets will do the work in seconds. A simple formula like =(B2-A2)/A2*100 dragged down a column handles hundreds of calculations in under a minute. Manual computation becomes painful around row 50 and unmaintainable past that point. Spreadsheet formulas are also easier to audit since anyone can trace where each result came from. The main limitation of percentage increase as a metric is that it's highly sensitive to small baselines. A jump from 2 to 4 is a 100% increase, but the absolute change is just two units. Context matters more than the percentage number alone, and ignoring that leads to genuinely poor decisions in procurement, pricing, and performance tracking. The percentage tells you the rate of change relative to the starting point. It does not tell you whether that change is significant in any practical sense.
Get the Full Details
