# Calculating highest allowable discount

1. ## Calculating highest allowable discount

Hello All,
Thank you for taking a quick moment to review my problem!
On the attached workbook, in cell D44 on the "Template" workbook, you will see the number -705.52. This is the highest allowable additional discount a salesperson can enter when summing cells K33:K37. Here is what I'm after - F33 allows the salesperson to either enter a direct number discount by selecting "Amount" - say -700 OR if they select "%" they can enter a percentage. I want the sales person to not be able to enter a higher discount than cell D44 when summing cells K33:K37. For instance, lets say the product in row 33 has an amount discount of -700, and then in row 34 they enter another product - I do not want them to be able to discount this product in cell K34 more than \$5.52. If they try to do this, they can get an error or it will only allow them to put in \$5.52. Conversely, if a user wants to put in a "%" discount, they still cannot discount more than -705.52 in total when adding cells K33:K37.

I hope my question is straight forward! I have been looking at this too long! Any and all help is much appreciated!

Regards,
Andrew

2. ## Re: Calculating highest allowable discount

1) On the Policy worksheet you have an embedded MS-Word document that looks like it may be company private. You may want to delete this. If so, I'm not sure whether you can do this yourself. If not then contact a moderator to do it for you.

2) To address your problem, it would be straightforward to have cell K38 display an error message instead of the total discount in the event that the total discount exceeds cell D44. Like this in K38:
Formula:
`Please Login or Register  to view this content.`
. I don't think this is exactly what you were looking for but is it workable for you?

3. ## Re: Calculating highest allowable discount

Hi Geoff,
You are correct, I accidentally posted confidential documents. Is there a quick way to have this taken down?
Also, your solution is very, very good. Thank you!

4. ## Re: Calculating highest allowable discount

I have alerted a moderator to have the workbook deleted.
Geoff

5. ## Re: Calculating highest allowable discount

Workbook removed. If you wish to reload a workbook with dummy info, please do.

6. ## Re: Calculating highest allowable discount

Thanks Alan. I think we're all set. In post #3 the OP says the proposed solution is OK.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1