If Statement

A

Alex

Hi In an If styatement, how would I go about testing to see if a cell
contained a text string please
- If (E2="*Phone","True","False"), which is what I assumed the syntax was,
doesm't work

Thanks
A
 
J

joeu2004

Alex said:
Hi In an If styatement, how would I go about testing to see if a cell
contained a text string please
- If (E2="*Phone","True","False"), which is what I assumed the syntax was,
doesm't work
Click to expand...

One way:

=if(iserror(find("Phone",E2)), "false", "true")

Use SEARCH() if you want a case-insensitive match.
 
B

Bob Phillips

=ISNUMBER(SEARCH("phone",E2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top