How to use
- Enter list prices, one per line. Thousands separators and currency symbols are fine.
- List the discount rates separated by commas or spaces. Ranges such as
10-50/10(start-end/step) also work. - Choose how to handle the last digits with round to and nearest, down or up.
- When the table appears, use Copy table to paste it straight into Excel or Google Sheets, or Download CSV.
With one list price you get a vertical table of sale price and amount saved for each rate. With several prices you get a matrix: prices as rows, rates as columns.
The currency starts from your country, and if you pick another currency the amounts you entered are converted at live exchange rates.
Writing the rates
| You type | Rates produced |
|---|---|
5, 10, 20 |
5%, 10%, 20% |
10-50/10 |
10%, 20%, 30%, 40%, 50% |
1-5 |
1%, 2%, 3%, 4%, 5% (step defaults to 1) |
0.5-2/0.5 |
0.5%, 1%, 1.5%, 2% |
Duplicates are used once and your order is kept. Values outside 0 to 100 are reported and skipped. The table holds up to 60 rates and 200 prices.
Worked example
List prices of $10, $25 and $49.90 with 5, 10, 20, 30 and 50 percent off, rounded to the nearest 0.01.
| List price | 5% | 10% | 20% | 30% | 50% |
|---|---|---|---|---|---|
| 10 | 9.5 | 9 | 8 | 7 | 5 |
| 25 | 23.75 | 22.5 | 20 | 17.5 | 12.5 |
| 49.9 | 47.41 | 44.91 | 39.92 | 34.93 | 24.95 |
Sale price = list price × (100 − discount) ÷ 100.
Handling the last digits
15% off a list price of $19.90 gives $16.915 before rounding. How you tidy the number changes the result.
| Setting | Sale price |
|---|---|
| Nearest 0.01 | $16.92 |
| Down to 1 | $16 |
| Up to 1 | $17 |
Rounding down favors the customer slightly and rounding up favors the seller. Pick whatever matches your pricing policy.
When you publish the prices
A banner reading “up to 50% off” may only be true for a few items. Showing a crossed-out original price that was never actually charged can mislead shoppers, and many countries regulate this, so check your local advertising rules. This tool only calculates and gives no legal advice.
Frequently asked questions
If I discount twice, do I add the rates?
No. 20% off and then 10% off is 28%, not 30%, because the second discount applies to the already reduced price. Use the Discount Calculator for stacked discounts.
Can I use decimal rates?
Yes, for example 12.5. Set the rounding unit to 0.01 to see two decimals.
How do I find the discount rate from a sale price?
Use the “sale price to discount %” mode in the Discount Calculator.
Will Excel read the numbers as numbers?
The copied table is tab separated and keeps thousands separators, which some settings read as text. For calculations use Download CSV, which contains plain numbers.
Related tools
- One price, one rate or stacked discounts: Discount Calculator
- Selling margin: Margin Calculator
- Prices with and without VAT: VAT Calculator
- Percentages in general: Percent Calculator
The values you enter are processed only in your browser and never sent to a server.