If Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex - 24 Sep 2006 18:52 GMT

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

Reply to this Message

joeu2004@hotmail.com - 24 Sep 2006 19:11 GMT

> 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.

Reply to this Message

Bob Phillips - 24 Sep 2006 20:19 GMT

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

Signature

HTH

Bob Phillips

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

> Hi In an If styatement, how would I go about testing to see if a cell
> contained a text string please
[quoted text clipped - 3 lines]
> Thanks
> A

Reply to this Message

Alex - 26 Sep 2006 19:25 GMT

Thanks Both

> Hi In an If styatement, how would I go about testing to see if a cell
> contained a text string please
[quoted text clipped - 3 lines]
> Thanks
> A

Reply to this Message