| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a cell a price off another cells color
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Threaded Mode
