=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(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
On Sun, 27 Feb 2005 16:31:03 -0800, "Brian" <[email protected]>
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
Try this:
=IF(M22="all","a",IF(ISNUMBER(SEARCH("e",M22)),"r","a"))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Brian" <[email protected]> wrote in message
news:[email protected]...
> =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(LEN(A1)>LEN(SUBSTITUTE(A1, "e","")), "r", "a")
--
Rob van Gelder - http://www.vangelder.co.nz/excel
"Brian" <[email protected]> wrote in message
news:[email protected]...
> =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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks