Re: Need help with IF function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


There maybe a more elegant solution but meantime, this should work for
you:

<< Is there any way for me to run an IF function that meets the
following
criteria:

If column C INCLUDES the word "German", then return "German" in this
cell.

Right now I have =IF(C:C="German","German", 0), but it's not working.

The problem is that column C is a long string of text that may or may
not include the word German anywhere in the text string. The text is
seperated by colons so I could break the column out into multiple
columns, but the word "German" doesn't always appear in the same node
of the text string.

blah : blah : German : blah
Blah : German : blah : blah >>

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(\"GERMAN\",C1:C100))))>0,\"GERMAN\",0)

<< And just curious, is there a way to run the following:
If column C doesn't include "English", return "Other" ?? >>

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(\"ENGLISH\",C1:C100))))=0,\"OTHER\",\"\")

The second formula will return a blank if the word "English" is found
in Column C.

As I mentioned earlier, there might be a more elegant (and also,
efficient) formula for your situation. BTW, out of curiosity ... what
result would you like to have IF the word "German" is found in the
column AND the word "English" is not in the column?

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=401986

.

Relevant Pages

  • Windows 2000
    ... I have used loadstring() function to access my string table which consists of English / German. ... My system is English OS and system locale is German. ...
    (microsoft.public.vc.language)
  • Re: string upper, string lower, string subthisforthat
    ... I'm not an specialist in German, ... |> character by character - we decide that after we have ... | For a comparison, I had a look at the O'Caml String module, ... | to uppercase, including accented letters of the ISO Latin-1 ...
    (alt.comp.lang.learn.c-cpp)
  • Re: string upper, string lower, string subthisforthat
    ... 'measure') and *Masse* are two different words in German; ... For a comparison, I had a look at the O'Caml String module, part of the ... to uppercase, including accented letters of the ISO Latin-1 ... character set. ...
    (alt.comp.lang.learn.c-cpp)
  • Translating Dialog text - do I need multiple dialogs?
    ... both English and German. ... should be used and depending on this, display the appropriate ... How are the String tables chosen by MFC? ... have the same IDs in each table with different translations? ...
    (microsoft.public.vc.mfc)
  • Re: Any luthiers here?
    ... You are arguing with that peculiar type of German or Swiss who still ... I am searching for a luthier who can build an acoustic guitar ... That requires a ZERO FRET, and not that white stuff at the upper end ... string, same as every el-cheapo electric guitar has. ...
    (rec.music.makers.guitar.acoustic)