Or rather...
=IF(ISERR(FIND("sometext";A1));"No";"Yes")
Dave
On 11/15/05, David Chapman <[EMAIL PROTECTED]> wrote:
>
> Try this...
>
> =IF(ISERR(FIND("sometext";A1));"";FIND("sometext";A1))
>
> Dave
>
> On 11/15/05, Johnny.1966 <[EMAIL PROTECTED]> wrote:
> >
> > Try this:
> > =IF(FIND("sometext";A1);"Yes";"No")
> >
> > However, I found that this only works if it finds the text, otherwise it
> > will return "#VALUE!".
> > Anyone who knows why this happen???
> >
> > A1, in my case, contains "Halledudasoetextne då!" ("No" case) or
> > "Halledudasometextne då!" ("Yes" case).
> >
> > Johnny
> >
> >
> > Den 2005-11-15 12:08:19 skrev < [EMAIL PROTECTED]>:
> >
> > > Try this:
> > > =IF(A1="sometext";"Yes";"No")
> > > In a message dated 11/15/2005 5:54:28 AM Eastern Standard Time,
> > > [EMAIL PROTECTED] writes:
> > >
> > > I am trying to do something like this:
> > >
> > > =if(a1 like '*sometext';"YES";"NO")
> > >
> > > But keep getting the #NAME error. What am I doing wrong?
> > >
> > > TIA
> > > Gert
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
> My OpenOffice Calc Website
> http://www.openofficetips.com
--
My OpenOffice Calc Website
http://www.openofficetips.com
