Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function and wildcards | Excel Worksheet Functions | |||
Wildcards in SUMIF Function | Excel Worksheet Functions | |||
using wildcards on text | Excel Worksheet Functions | |||
Can wildcards be used in the Logic Test of an Excel "IF" function? | Excel Worksheet Functions | |||
Problems with SUMIF function and Wildcards (* and ?) | Excel Worksheet Functions |