GOOGLE SHEETS: Using Multiple ANDs with IFS - Possible?

[jetheat]

I am trying to use IFS but with multiple AND statements. It seems to get stuck after the very first AND statement.

Here is what I have:

=IFS(AND(I2="Half",H2="Long")=TRUE,"Half True",TRUE,"Half False",AND(I2="Completion",H2="Long")=TRUE,"JustComp True",TRUE,"JustComp False")

The problem is that, even if I select "Completion" in the I2 dropdown box, even then, the output is "Half False".
In other words, its not getting past the first AND statement.

How do I solve this?

Appreciate the help,
Thanks,

JH

 

[Joe4]

Can you just explain for us the logic you want in plain English?
There is always a danger in trying to "guess" what someone wants from a formula which does not work right.

 

[ExcelToDAX]

It is hard to understand what you are trying to accomplish, but I believe you are trying to do this:

=SWITCH(TRUE,AND(I2="Half",H2="Long"),"Half True",I2="Half","Half False",AND(I2="Completion",H2="Long"),"JustComp True",I2="Completion","JustComp False")

 

[jetheat]

I forgot to mention I'm using Google Sheets. I don't know if that makes a difference.
That Switch formula doesn't seem to work.

Here's what I am trying to do.

If the values of two separate cells is true (I2 and H2) (both of them have to match the words), then I want my current cell to perform a calculation. But if one of those cells is false, then I want my current cell to perform a different calculation.

The two cells have drop downs in them where I can select what I want. So I need multiple AND statements to account for the different options selected.

I just replaced the calculations above for some simple words.

JH

 

[Joe4]

I forgot to mention I'm using Google Sheets.

Yes, that absolutely makes a difference! While there are many similarities, Excel and Google Sheets are NOT the same thing and have differences.
As such, you should not post Google Sheets questions in the "Excel Questions" forum, but instead use the "General Discussion & Other Applications" forum.
(note the mention of Google Sheets there). You should also mention in your question that this is for Google Sheets.

I have move this thread for you and updated your title.