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










"Kpercy" wrote:

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
, 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