[users] Like operator in Calc IF function

[Gert Blij]

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]