Help with Excel - Calculating 2 cells based on the text within another

[Johnny_The_Muz]

Hello ! I hope someone can help me :)

My issue is, I need to calculate the multiplication of 2 cells, when a completely different cell returns a specific text.

Eg: 

Cell A = 10

Cell B = 5

Cell C = HAT

Cell D = (this is the cell I want to run the calculation of Cell A* Cell B - but only if Cell C = HAT

if Cell C were to = "Trousers" I would not want the calculation to occur.

Your help would be greatly appreciated !!!

[#2]

@Johnny_The_Muz 

=IF(C1="HAT",A1*B1,IF(C1="Trousers","",""))

You can try this nested IF formula.

 

[#3 · Accepted solution]

@Johnny_The_Muz 

Perhaps

=IF(C1="HAT", A1*B1, "")

[#4]

This was so fast ... Thank you so much for the quick response.. This formula worked perfectly.
Thank you so very much.

[#5]

Thank you Sergei - This also works perfectly.. very much appreciated.

[#6]

@Sergei Baklan 

Apologies to be incredibly annoying but I have an extension to that issue.. are you able to assist?

Your formula works great but now i have a simple sum in the next field which is now returning a #value error..

[#7]

Cancel that - I've worked it out.

[#8]

@Johnny_The_Muz 

Great to know. If you share result that will be useful for other people in the community.