If a certain text is in a cell, multiply a different cell by a number

[kefin]

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?

 

[Joe4]

Welcome to the Board!

You get FALSE returned if your condition is not met and you have not told it what to return when that happens.
If you wanted it to return nothing instead, you could do:

=IF(C2="Black",D2*4,"")

Now, if you want to add in the green condition, one way is to use a nested IF like this:

=IF(C2="Black",D2*4,IF(C2="Green",D2*3,""))

If you have more than a few colors you need to work into the formula, I would recommend either setting up a lookup table and using VLOOKUP to return the factor to multiply by (see: How to use the Excel VLOOKUP function | Exceljet).

 

[kefin]

Welcome to the Board!

You get FALSE returned if your condition is not met and you have not told it what to return when that happens.
If you wanted it to return nothing instead, you could do:

=IF(C2="Black",D2*4,"")

Now, if you want to add in the green condition, one way is to use a nested IF like this:

=IF(C2="Black",D2*4,IF(C2="Green",D2*3,""))

If you have more than a few colors you need to work into the formula, I would recommend either setting up a lookup table and using VLOOKUP to return the factor to multiply by (see: How to use the Excel VLOOKUP function | Exceljet).

You are a godsend, my friend! Thank you very much!

 

[Joe4]

You are welcome.
Glad I was able to help!