If function with text & wildcards

  • Thread starter Thread starter Kpercy
  • Start date Start date
K

Kpercy

Sorry if this is a stupid q but I'm just not getting it...What's formula that
matches this description? I'm stuck on the "contains" or "starts with" for
evaluating text with an IF function... Also, if you can please email me at
(e-mail address removed), my passport acct always returns an error when I
follow an email link back to post.

If A4 contains "mobile broadband" return "data card" otherwise return "cell
phone".

Thanks, Katie
 
try

=IF(A4="mobile broadband","data card","cell phone")

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis
 
Francis - that would work for EQUALS but I need it to be CONTAINS or STARTS
WITH. There's several diff entries that start with mobile broadband and I
want to include them all.
 
Back
Top