I am familiar with Nested IFs.. but what I need is multiple IFs where ALL conditions can be true.
IF text1 is found in A2... do this..
IF text2 is found in A2.. do this
IF text3 is found in A2... do this..
example A2 = "Bulgarian; Chinese (Mandarin - Taiwan); Czech; Danish; Dutch; Estonian; Finish; German; Greek; Hungarian; Icelandic; Italian; Japanese; Korean;"
now, i need to arrange these values in 3 cells named as Language(A-F), Language(G-P), Language(Q-Z). If language starts with A-F, it would fall on column named "Language (A-F)", so Language (A-F) would have values
"Arabic; Chinese (Cantonese); Chinese (Mandarin); Chinese (Mandarin - Taiwan); Croatian; Czech; Danish; Dutch; English; Estonian; Finish; French"
while Language (G-P) would have "German; Greek; Hungarian; Icelandic; Italian; Japanese; Korean"
So for column "Language (A-F)", I'm thinking of using:
to test for English.. but I wonder how I can test for other POSSIBLE values. I wonder how to do the multiple IFs with this.