If Statement

[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

 

[joeu2004]

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

One way:

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

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Alex]

Thanks Both