Thread
:
If function -
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
external usenet poster
Posts: 4,624
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?
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey