How this instrument works
A percentage off is an instruction to multiply, but the two small words that carry it — off and of — point at opposite numbers and get swapped constantly. Twenty-five percent of eighty is twenty; twenty-five percent off eighty is sixty. The discount removes 25% of the price, so what remains is the other 75%, which is why the working formula multiplies the price by (1 − d ⁄ 100) rather than by d ⁄ 100 on its own.
The same instruction shows up wherever a percentage is subtracted from a running figure — a promo code at checkout, a loyalty rate on a subscription renewal, a discount line on a freelance invoice — not only on a shop tag. Whoever wrote the percentage means the smaller of two numbers: the amount still owed after the cut, which is a different quantity from the amount the cut itself is worth. This sheet reports both, so neither has to be inferred from the other by hand.
You pay and You save always sum to the original price, and that identity is the fastest check that nothing was mistyped. The arithmetic stops there, though. It knows nothing of a processing fee added after a coupon, sales tax charged on the reduced total, or a renewal price that resets once an introductory code expires. Treat the result as the pre-fee, pre-tax figure the percentage alone produces, then add whatever the invoice or receipt tacks on afterward.
- Enter the figure before any reduction into Original price, $.
- Set Discount, % to the percentage quoted — 25 for a quarter off, 50 for half off.
- Read You pay for the amount that actually leaves your account.
- Read You save for the size of the cut itself; the two figures always sum back to the original price.
Worked example — an $80 renewal at 25% off
A one-year software plan renews at $80, and a loyalty code knocks 25% off that figure. The fraction still owed is 1 − 25 ⁄ 100 = 0.75, so You pay reads 80 × 0.75 = $60.00. You save reads the other slice, 80 × 25 ⁄ 100 = $20.00, and the two readouts add back to the full $80 renewal price — confirmation that the code applied cleanly.
Move the same percentage onto a bigger renewal and the split scales with it: a $240 plan at 25% off costs $180 with $60 saved, the identical three-quarters and one-quarter of whatever figure starts the calculation. What the instrument cannot see is what happens next — whether the provider charges tax on the discounted total, or whether the 25% code was only good for the first term and the second renewal reverts to the full $80.
Questions
Is 25% off the same as 25% of the price?
No — they land on opposite numbers. 25% of $80 is the smaller figure, $20, which is a plain percentage with nothing subtracted. 25% off $80 keeps the other 75%, so the reduced price is $60, and $20 is the amount saved rather than the amount owed. Reading You pay and You save side by side is the fastest way to keep the two straight.
Does You pay already include tax?
No. This sheet applies only the percentage in Discount, % to the figure in Original price, $. Sales tax, a checkout processing fee, or a delivery charge are layered on afterward by whoever is billing you, not before, so You pay is the pre-tax total the percentage alone produces. Add your local rate to that figure separately to reach what actually leaves your account.
Why do You pay and You save always add up to the original price?
Because a discount can only remove a fraction of the price, never invent or hide one. You save equals price times d ⁄ 100, You pay equals price times the remaining fraction (1 − d ⁄ 100), and those two fractions are built to sum to exactly 1. If the two readouts ever failed to add back to Original price, $, that would signal a broken entry, not a valid discount.
Can Discount, % go above 100?
The sheet stops it, because a discount past 100% would mean being paid to take the item, which is a different transaction entirely. Entering a figure above 100 in Discount, % triggers a check instead of a silent negative price. Percentages above 100 do appear in business pricing as a markup over cost, but a markup is measured against a different base than the price a customer sees, so it is not this calculation.
How is this different from stacking two separate discount codes?
This sheet applies exactly one percentage to exactly one starting price. Two codes used together — a storewide markdown followed by a loyalty coupon, say — compound rather than add, because the second code acts on the already-reduced figure, not the original. Run this calculation once for the first code, then feed You pay back in as a new Original price, $ to work out what the second code does.
References
- Consumer Financial Protection Bureau — Consumer Tools and resources
- Federal Reserve — Consumer information and resources
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.