Thread: IF question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default IF question

=if(isnumber(search("a",a1)),"A1 contains an a","nope")

If you want to match case, then use =Find() instead of =search()

And another way if you don't care about upper/lower case:
=if(countif(a1,"*a*")0,"yep","nope")


Alyssa wrote:

I am attempting an IF lookup for a list of cells that have letters in them. I
know how to say IF the cell equals (=) a certain letter, but is there a way
to say IF the cell contains a certain letter?


--

Dave Peterson