multiple two cells based on text in another cell

[jimjim001]

I am trying to make a cell multiply two other cells, only if another cell has text in it.

EG

make A1 multiply A2 and A3, but only if A4 has the word YES in it.

In the image attached, A1 should show 50 when A4 has the word YES typed in it. When no text, it stays blank.

Any help would be greatly appreciated.

 

[Siddharth Rout]

You mean like this?

=IF(A4="YES",A2*A3,"")

 

[jimjim001]

thats the one! thanks legend!