LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function and wildcards Chacky Excel Worksheet Functions 6 September 6th 07 08:48 AM
Wildcards in SUMIF Function Ron Excel Worksheet Functions 9 February 13th 07 08:17 PM
using wildcards on text scott Excel Worksheet Functions 1 September 21st 06 05:45 PM
Can wildcards be used in the Logic Test of an Excel "IF" function? Monte Excel Worksheet Functions 3 August 15th 05 01:25 PM
Problems with SUMIF function and Wildcards (* and ?) J1J Excel Worksheet Functions 4 June 27th 05 04:25 PM


All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"