=IF(LEN(A1)LEN(SUBSTITUTE(A1, "e","")), "r", "a")
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"Brian" wrote in message
...
=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