I have a large table of data. In one column is a name of an opportunity, in the 2nd column is the product that is a part of that opportunity, and in the 3rd is the price. I am trying to write a formula in the 4th column (Actual Price) that basically says the following...
IF Opportunity A has Product C and either Product A or Product B, then Actual Price for Product C is 0, otherwise it is = to Price in Column C.
The Opportunities can not be sorted alphabetically. I have attached the below table in Excel for added help.
A B C D
1 Opportunity Product Price Actual Price
2 Opportunity A Product A 100 100
3 Opportunity A Product B 200 200
4 Opportunity A Product C 300 0
5 Opportunity B Product A 100 100
6 Opportunity B Product B 200 200
7 Opportunity B Product D 400 400
8 Opportunity C Product A 100 100
9 Opportunity C Product B 200 200
10 Opportunity B Product C 300 0
11 Opportunity A Product E 500 500
12 Opportunity C Product D 400 400
Bookmarks