Thread: If function -
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sebation.G[_2_] Sebation.G[_2_] is offline
external usenet poster
 
Posts: 37
Default 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