We have the same parts, but in different colors. Certain customers get
discounts based off the color of the parts.
So it looks like this:
Color Price Discount Whole Price
Blue $20 ?? Price - Discount

The discount I am not sure how to do. It could be red, blue, or black.
So I want ti say "If A2 is Blue it equals 5% discount, but if it's Black it
equals 7%, but if it's Red it equals 10%

All the parts get the same discount off the color so I don't have to worry
about different part numbers. Help please!