if a cell = a particular letter or even contains that letter

Brian · Feb 28, 2005

=IF(M22="all","a",IF(M22="e","r","a"))

Notice the "e", how can I insert the following:

....If m22 contains "e" anywhere,"r","a"))

Thanks

Brian

Ron Rosenfeld · Feb 28, 2005

=IF(M22="all","a",IF(M22="e","r","a"))

Notice the "e", how can I insert the following:

...If m22 contains "e" anywhere,"r","a"))

Thanks

Brian

.... =IF(COUNTIF(m22,"*e*")>0,"r","a")

--ron

Ragdyer · Feb 28, 2005

Try this:

=IF(M22="all","a",IF(ISNUMBER(SEARCH("e",M22)),"r","a"))

Rob van Gelder · Feb 28, 2005

=IF(LEN(A1)>LEN(SUBSTITUTE(A1, "e","")), "r", "a")