Thanks David, That last one is working fine and solves my problem.
Cheers Gert > -----Original Message----- > From: David Chapman [mailto:[EMAIL PROTECTED] > Sent: Tue 15 November 2005 03:42 PM > To: [email protected] > Subject: Re: [users] Like operator in Calc IF function > > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
