Updated query on IF/AND question

[Orangeanorak]

Can you please give me the solution to my latest problem.
I want to show the word "Win" in cell I7 if cell J7 is greater than .5 AND the word "Ball" appears in cell K7.
I also need I7 to show "Win" if J7 is greater than two even if the word "Ball" does not appear in K7
Thank you for your time and help with this.
Regards
Jn

 

[gnaga]

=IF(OR(AND(J7>0.5,K7="Ball"),J7>2),"Win","")

GNaga

 

[Aladin Akyurek]

=IF(((J7>0.5)*(K7="Ball")+(J7>2)),"Win","")

 

[Orangeanorak]

Many thanks - works exactly as required
Jn