How to calculate a discounted price
✓ Verified in LibreOffice 25.8.7.3Apply a percentage discount to a price — e.g. 25% off $80.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =A2*(1-B2) | A2=price, B2=discount as a percentage (format the cell as %). |
| Google Sheets | =A2*(1-B2) | Identical. |
| LibreOffice Calc | =A2*(1-B2) | Identical. |
How it works
A discount leaves you paying (1 − discount) of the price: 25% off means paying 75%, so 80 × 0.75 = 60. Entering 25% in a percent-formatted cell stores 0.25, which is why the formula uses it directly. To get the discount amount instead of the final price, use =A2*B2; to add a markup or tax, flip the sign: =A2*(1+B2).
Verified, not just documented
We ran =A2*(1-B2) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 60 — exactly the expected result. Every formula here is confirmed by actually executing it.