Posted to microsoft.public.excel.misc
|
|
Make a cell a price off another cells color
ps...
Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html
Jerid B wrote:
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!
--
Dave Peterson
|