Hello
So I am dealing with a large amount of data. I have product colours in one column and the colour weight in another column.
So if a product is black, I want to multiply the weight of the colour by 4. But if it is green, I want to multiply the weight by 3.
The closest I could get is =IF(C2="Black",D2*4)
The problem with this is every other cell responds with FALSE. How do I specify for each different colour?
So I am dealing with a large amount of data. I have product colours in one column and the colour weight in another column.
So if a product is black, I want to multiply the weight of the colour by 4. But if it is green, I want to multiply the weight by 3.
The closest I could get is =IF(C2="Black",D2*4)
The problem with this is every other cell responds with FALSE. How do I specify for each different colour?