| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a cell a price off another cells color
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a cell a price off another cells color
I'd use another worksheet.
I'd put all the colors in column A and the discount percentage in column B. Then use a formula like: =vlookup(a2,sheet2!a:b,2,false) to return that discount or =b2*(if(iserror(vlookup(a2,sheet2!a:b,2,false)),0, vlookup(a2,sheet2!a:b,2,false))) to do the arithmetic 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 |
|
#4
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make a cell a price off another cells color
can you help with homework
-- ROCHELLE SANCHEZ "Dave Peterson" wrote: I'd use another worksheet. I'd put all the colors in column A and the discount percentage in column B. Then use a formula like: =vlookup(a2,sheet2!a:b,2,false) to return that discount or =b2*(if(iserror(vlookup(a2,sheet2!a:b,2,false)),0, vlookup(a2,sheet2!a:b,2,false))) to do the arithmetic 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 |
| Reply |
| 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 | |||
Linear Mode
