What each mode does
- X% of Y — finds a percentage of an amount. 15% of £2,400 is £360.
- Add % — increases an amount by a percentage, like a price rise or an uplift. £2,400 plus 15% is £2,760.
- Remove % — takes a percentage off, like a discount. £2,400 less 15% is £2,040.
- Change — measures the percentage change between two figures, such as this month against last month.
Everyday business uses
Percentages come up constantly in a small business: a client asks for 12.5% off, a supplier raises prices by 8%, a payment processor takes 1.75% of every transaction, or you want to know by how much revenue grew. Getting the sum right matters more than it looks — a discount taken off the wrong base quietly erodes a margin.
Worked example: a discount on a margin
A product sells for £120 with a 40% margin, so the gross profit is £48. You offer a 10% discount: the price falls to £108, but the profit falls to £36 — a 25% cut in profit from a 10% cut in price. The margin drops to 33.3%. This is why percentage discounts should always be checked against the margin, not against the price.
Percentage change, and the low-base trap
Percentage change is (new − old) ÷ old × 100. Going from £200 to £250 is a 25% increase; going back from £250 to £200 is a 20% decrease. The same £50 move is a different percentage in each direction, because the base changed. And when the starting figure is very small — one sale last month, two this month — the percentage looks dramatic while the absolute change is trivial. Quote both.
Percentage change is undefined when the starting figure is zero, because you cannot divide by zero. Use the absolute difference instead.