Gert Blij <gert <at> icon.co.za> 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?
>
A different tack which, like the others, relies on an exact match is
=EXACT("sometext";A1) which will give you TRUE or FALSE. You need to enclose
your text in double quotes, not single quotes.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
