On Sun, 27 Feb 2005 16:31:03 -0800, "Brian"
wrote:

=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