If function with text & wildcards
 

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

If function with text & wildcards
 

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

If function with text & wildcards
 

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.

"francis" wrote:

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

If function with text & wildcards
 

Hi,

Try this:

=IF(ISNUMBER(FIND("mobile broadband",C16,1)),"Data card","cell phone")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Kpercy" wrote in message
...
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