## Use VLOOKUP to calculate discount percentages

Have you ever tried to build a formula to calculate discounts depending on price? The VLOOKUP function is much easier to use than nested IF functions.

You can also use the methods described in this article to calculate commissions, tariffs, charges, shipping costs, packaging expenses etc.

#### Table of contents

- Use price ranges to determine discount
- Linear discounts
- Multiple tables
- Two-way lookup in multiple cross reference tables
- Download xlsx file
- Functions in this post

### Use price ranges to determine discount

For this example our price range plan looks like this:

- Total price between 0 and 100 returns a 5% discount
- Total price between 100 and 300 returns a 7% discount
- Total price between 300 and 500 returns a 8% discount
- Total price between 500 and 1000 returns a 10% discount
- Total price between 1000 and above returns a 15% discount

The picture below shows you the discount percentage table (B2:D7) and a summary table (B9:E19) with a calculated discount (E21).