In C2 use:
=IF(A2="blue",5%,IF(A2="black",7%,IF(A2="red",10%, NA())))
In D2 use
=B2*(1-C2)
best wishes (with homework?)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jerid B" wrote in message
...
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!