Previous Topic Next Topic

Multiple IF functions

Closed
panosi Posts 1 Registration date Wednesday February 24, 2016 Status Member Last seen February 24, 2016 - Feb 24, 2016 at 03:18 AM
 RayH - Feb 24, 2016 at 02:33 PM
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 response

Answer 1 / 1
RayH
Feb 24, 2016 at 02:33 PM
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.

Similar discussions

Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

Hello, I have a very strange situation in last two month. Usualy my clients send me multiple files for printing (photo or doc). From day one when i use whats-app web i choose select mesaje, thic multiple files or pres shift and select last files that i want downloaded. after select/ thick multiple files, i press the download simbol in right corner . an archive is downloaded, extract archiv and i see al files that i dwanted to download.. Now, in last two month, i can not find what it was changed, because when i select multiple file, download sign not apear. Only after i download individual files (on doc, odf or other) or viwe any photo, via web or phone, only after this operation download ...

4 responses
How to create two WhatsApp accounts on a Windows PC?
Lason -
talha007 -

I have a WhatsApp account on a Windows PC. It is more reliable than the phone. It shows all incoming calls. My phone often misses calls, probably due to the OS stopping internet traffic to save battery. I want to connect my wife's account to the same PC. As far as I can see, a WhatsApp instance can handle one account. How can I add another WhatsApp account to a PC where one account is already active?

3 responses
Can’t Log into Instagram from Multiple Devices
Isabella -
Abhishek0025 -

Hi! I’m struggling so so much with this, and it’s driving me mad. Last night I used a third-party app to look at my insights and stuff, but soon after discovered that such apps aren’t always trustworthy, so I logged out, and uninstalled it. I’ve always been logged into my account from my phone and iPad, but ever since last night, I get logged out of one device if I log into the other. It’s never been like this. I was always able to be logged into the account from both devices simultaneously, no problems whatsoever. After I uninstalled the Instagram followers analysis app I changed my password in fear that the app had access to my account. I’ve changed my password again since then, am able to...

5 responses
Excel - IF function with multiple words
Nick -
user -

Hi

I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the words I am trying to match.

Ie. I want the formula cell to read "Yes" if Cell B4 contains the words "Apple" or "Banana" or "Carrot", or "No" if it doesn't contain any of those words.

I am currently trying something like:

=COUNTIF(OR(B4,"*Apple*",B4,"*Banana*",B4,"*Carrot*")), "Yes","No"

(although this is rejected)

Help would be very much appreciated!

14 responses