Expanded Validation rule to apply quantity to product codes - Stuck!
Stuck again!
I am using the following code to produce an error message when the Quantity for specific product numbers (listed below) is up to 499 users AND when the discount exceeds 40%. What I'd like to do is expand this code to include a number of quantity ranges, say 500-999, 1000-1500 etc, where the discount (against the same product codes) should not exceed 45%, 50%, 60%, respectively.
Is there a way to do this in one code string rather than create unique validation rules? Here's what I am using...it works for up to 499 users, and up to 40% discount:
Basically a bunch of ANDs within an OR. Try something like:
OR(
AND(Quantity<=499, Discount > .4),
AND(Quantity >= 500, Quantity <=999, Discount > .5),
AND(Quantity >= 1000, Quantity <=1499, Discount > .6) )