Isnumbersearch

**SdavisCBN** · 07-15-2011, 09:25 AM

Help! I need to create a formula that allows for the following conditions:

If cell A1
contains a parenthesis then = chat
If any other data without parenthesis then cell = Callcenter
If cell is empty then = direct

**Colin Legg** · 07-15-2011, 09:28 AM

Welcome to the forum. Give this a whirl:

=IF(ISBLANK(A1),"direct",IF(OR(ISNUMBER(SEARCH({"{","}"},A1))),"chat","Callcenter"))

**tigertiger** · 07-15-2011, 09:35 AM

try to test:
=IF(ISBLANK(A1),"direct",IF(A1="parenthesis","chat","Callcenter"))

or
=IF(A1="","direct",IF(A1="parenthesis","chat","Callcenter"))

**SdavisCBN** · 07-15-2011, 12:41 PM

That doesn't seem to work it is not pulling the chat

The parenthesis is only part of the other content in the cell for example and entry and be either of the following:

ITS - Joy Whited (1289)
or
JoyMarie Minichelli

First would be chat
Second would be CallCenter
If field blank it is Direct

**Colin Legg** · 07-15-2011, 12:47 PM

By "parentheses" I thought you meant { }, rather than ( )

To pick out ( ) amend the formula to this:

Please Login or Register  to view this content.

**SdavisCBN** · 07-15-2011, 12:57 PM

Colin it worked! You are fabulous!!!

**Colin Legg** · 07-15-2011, 12:59 PM

Hi,

If you are happy with the solution provided, please mark your thread as solved.

To mark your thread as solved, please click EDIT in your first post, click GO ADVANCED and set the PREFIX box to SOLVED.