Multiple IF functions [Closed]

Report
Posts
1
Registration date
Wednesday February 24, 2016
Status
Member
Last seen
February 24, 2016
-
 RayH -
Hello, I am trying to built a multiple If condition. I want excel to search for 2 words in an array "Lose" and "Tie". If it finds "Lose" then i want result "Lose". If it finds "lose and tie" then results again "Lose". If it finds ONLY "tie" then result is "tie". If it finds none then result "win".
Till now I have only produced a formula which finds only "Lose" and if it detects it
returns"Lose" if not returns "Win". Tie is what droubles me.
=IF(COUNTIF(G2:AG2,$A$2),"Lose","Win")
G2 cell contains the word Lose.
Thanks in advance.

1 reply

Here is a multiple IF statement.
It may not do EXACTLY what you are intending but it may help you put together that works for you.

=IF(COUNTIF(G2:AG2,"Lose")>0,"Lose",IF(AND(COUNTIF(G2:AG2,"Lose")>0,COUNTIF(G2:AG2,"Tie")>0),"Lose",IF(AND(COUNTIF(G2:AG2,"Tie")>0,COUNTIF(G2:AG2,"Lose")=0),"Tie","Win")))


It does not use the A2 cell. I didn't know what was in there.