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]
