If function -

J

Jock

Can I use a 'LIKE' operator rather than the '=' one?
For instance:
=If(A1 LIKE "Ford", this,that)
If not, is there an alternative which will return partial matches?
 
T

Toppers

perhaps ..

=IF(ISNUMBER(FIND("Ford",A1)),"found","not found")

FIND is case sensitive, SEARCH is not.

=IF(ISNUMBER(SEARCH("Ford",A1)),"found","not found")

HTH
 
S

Sebation.G

u can use text formula Exact() or Find()
=if(exact(a1,food),this,that)
or
=if(iserror(find(food,a1),that,this)

hope this can be helpful
 
J

Jock

Thanks very much
--
tia

Jock


Toppers said:
perhaps ..

=IF(ISNUMBER(FIND("Ford",A1)),"found","not found")

FIND is case sensitive, SEARCH is not.

=IF(ISNUMBER(SEARCH("Ford",A1)),"found","not found")

HTH
Click to expand...
 
Top