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
