Can you have the "IF" function look for several words?

[BJIII]

I would like an IF function to look for the following words. If it find them I want it to report true and then I can set the action I need. If false then I can set the opposite. Is there a way to get the IF function to recognise several words? I can set it to look for a specific word but not multiple.

Burr
Circularity
Concentricity
Flatness
Hardness
Profile
Roundness
Roughness
Straightness
True Position

Thanks!
BJW

 

[Andrew Poulsom]

Try something like this:

=COUNTIF(A1:A10,"Roundness")>0

Change the range reference to suit and the text "Roundness" can also be a cell reference.

 

[Aladin Akyurek]

I would like an IF function to look for the following words. If it find them I want it to report true and then I can set the action I need. If false then I can set the opposite. Is there a way to get the IF function to recognise several words? I can set it to look for a specific word but not multiple.

Burr
Circularity
Concentricity
Flatness
Hardness
Profile
Roundness
Roughness
Straightness
True Position

Thanks!
BJW

=LOOKUP(9.99999999999999E+307,SEARCH(WordList,A2))>0

where WordList is a range housing the words of interest.

 

[Jonmo1]

If you put your list of words in a range of cells, say B1:B10
And A1 is the cell you want to check..

=IF(COUNTIF($B$1:$B$10,A1)>0,"Yes","No")


Hope that helps.

 

[BJIII]

Thanks for the reply's!!!

jonmo1 I think that will for fine for me

Thanks again!!!
BJW