If function -
 

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?
--
tia

Jock

If function -
 

One way:

=IF(COUNTIF(A1,"*Ford*"),this,that)

In article ,
Jock wrote:

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?

If function -
 

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

"Jock" wrote:

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?
--
tia

Jock

If function -
 

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

--
Regards,

Sebation.G
"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?
--
tia

Jock

If function -
 

Thanks very much
--
tia

Jock


"Toppers" wrote:

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

"Jock" wrote:

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?
--
tia

Jock