BLOG
To calculate a percentage at work, identify the base amount first. A discount, a share of a total, and a change between two prices all use percentages, but they answer different questions. A mathematically correct formula applied to the wrong base can still make a quote or commission wrong. Write down what the percentage applies to before entering a number in a calculator or spreadsheet.
Start with the business rule
For a commission, is the base the quoted price, the amount collected, or the amount after refunds? For a discount, do shipping and optional services count? The formula cannot decide these terms. Agree on the commercial rule and record it alongside the rate. The examples below illustrate arithmetic, not a recommended fee, margin, or pricing policy for a business.
Calculate a percentage of an amount
Divide the rate by 100 and multiply by the base. Twenty percent of $500 is 0.20 × $500, or $100. If a $500 invoice carries a 20% discount on the whole amount, the discount is $100 and the resulting price is $400. The same result comes from $500 × (1 − 0.20). Check that all items in the invoice are actually covered by the agreed discount before using that result.
Find the share or the change
To find what share $100 represents of $500, divide $100 by $500. The ratio is 0.20, or 20%. To find the percentage change from $400 to $500, use ($500 − $400) ÷ $400 = 0.25, or a 25% increase. The previous value is the base in that change calculation. If it is zero, the ordinary change formula cannot divide by it; label that case explicitly instead of displaying an invented rate.
Keep the four operations distinct
| Question | Operation | Example |
|---|---|---|
| What is 20% of a base? | Base × 0.20 | $500 → $100 |
| What remains after 20% off? | Base × 0.80 | $500 → $400 |
| What share is a part? | Part ÷ total | $100 ÷ $500 → 20% |
| How much did a value change? | (New − old) ÷ old | $400 → $500: 25% |
A discount and an increase do not cancel at the same rate
After a 20% discount, $100 becomes $80. Raising $80 by 20% yields $96, not $100, because the second calculation starts from a smaller base. Restoring $80 to $100 requires a 25% increase relative to $80. This matters when a business stacks promotions or reverses a price change. Apply each step in order and show the intermediate amount rather than adding or subtracting percentages mentally.
Markup on cost is not margin on revenue
A 20% markup on a $100 cost gives a $120 selling price. The $20 difference is about 16.67% of the $120 price, not a 20% margin on revenue. Define which concept a quotation uses and which expenses are included in cost. Copying a rate from one workbook to another without its base can silently change the meaning of a calculation.
Check spreadsheet formatting
In Excel, a cell containing 0.20 can display 20% when formatted as a percentage. A cell containing 20 can display 2,000% with that same format. Inspect the stored value and formula, not just the percent symbol. Microsoft’s percentage guidance for Excel provides examples of calculating amounts and changes. Use clear headers for base, rate, and result, and check decimal separators when importing data.
Verify before quoting or paying
Calculate one easy case by hand and compare it with the spreadsheet. Then test zero rate, decimals, refunds, and any rounding that affects cents. Define whether rounding happens at each line or after the total; different choices can change the final amount. Keep the commercial rule with the calculation so another person can reproduce it later. A plausible-looking total alone is not evidence that the base and formula were right.
Common questions
Why does a 20% decrease followed by a 20% increase not return to the start? The second percentage applies to the reduced amount.
What if the old value is zero? The standard percentage-change formula is undefined because it divides by zero. Explain the absolute change or use a specifically agreed metric.
For a real quote, write the base, rate, and order of operations in plain language beside the numeric result. That is what makes the calculation reviewable by a colleague or client.
When several discounts apply, write down their order before calculating the final price. A percentage applied after another discount has a different base from one applied to the original price. Show each line separately in a quote so the client and your team can reconcile the result.
