Variable Discount

**wilfreddie** · 10-25-2012, 12:59 PM

Hello all, first want to say that this forum has helped me so much in the past, however I did a search and could not find the answer to my question. I have a price list that I would like to discount depending on the list price. Example if the list price is between 1.00 to 400.00 i would want a discount of 8%. From 401 to 1,000 a discount of 10%, etc... Thank you in advance for any help.

**Moo the Dog** · 10-25-2012, 01:05 PM

If your price is in A1, try this:

Formula:

Please Login or Register  to view this content.

- Moo

**FDibbins** · 10-25-2012, 01:07 PM

this is fairly easy to do. set up a table with your discount rates in it, then use a vlookup to find then then apply the rate to your price.

if you have a problem setting this up, upload a sample workbook and i will walk you through it

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**wilfreddie** · 10-25-2012, 01:26 PM

Thank you so much for the quick replies. The first reply would be easier for me to use, since I am not an advanced user. However I still need a little help with that formula. When I ran it, it returns the proper desired discount expressed as a % (8%, 10%, 12%), but what would then be the formula to deduct that specific discount from original listed price. For example, if the list price is $500, I would like the returned value to be $450 and not 10%.