How to do multiple IFs in Excel?

Microsoft Excel 2007
October 22, 2009 at 21:08:32
Specs: Windows XP
Hi,

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:
IF(SEARCH("English",A2,1)>0,"English","")

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.

Thanks.


See More: How to do multiple IFs in Excel?

Report •


#1
October 23, 2009 at 09:32:12
Excel questions are best asked in the Office Software Forum.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question