How To Properly Nest IF Statements

[honkin]

hi

I have 3 consecutive columns which will either have an X or be blank. I have 3 IF statements which cover all possible scenarios, but am struggling to nest them properly into one formula.

This first one tests if the sequence of the 3 columns is XX

=IF(AND(T2="X",U2="X"),"**","")

This one tests if the sequence is X Blank

=IF(AND(T2="X",U2=""),"*","")

This last one tests if the sequence is Blank Blank X

=IF(AND(T2="",U2="",V2="X"),"x","")

So I end up with either **, * or x in the cell. Naturally if there is nothing in all 3, I get a blank.

Firstly, how to best nest these 3 and secondly, is it actually the best way? I mean, can the SWITCH function be used with AND? Just after the most reliable way to do what I am after

Thanks in advance

 

[etaf]

Code:
=IF(AND(T2="X",U2="X"),"**","")
This one tests if the sequence is X Blank
Code:
=IF(AND(T2="X",U2=""),"*","")
This last one tests if the sequence is Blank Blank X
Code:
=IF(AND(T2="",U2="",V2="X"),"x","")
-------
=IF(AND(T2="X",U2="X"),"**",IF(AND(T2="X",U2=""),"*",IF(AND(T2="",U2="",V2="X"),"x","")))

I assume for the first 2 conditions V does not matter what it is

and that T2 = "" , U2 = "X"
also does not matter

 

[honkin]

=IF(AND(T2="X",U2="X"),"**",IF(AND(T2="X",U2=""),"*",IF(AND(T2="",U2="",V2="X"),"x","")))

I assume for the first 2 conditions V does not matter what it is

cheers Etaf.
Yes, V made no difference withe the first 2. That works brilliantly.
Thanks so much

 

[etaf]

you are welcome