Re: [users] Like operator in Calc IF function

[RLShadow]

 
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