Prev: Growth rate
Next: Finding the combination that appears more times
From: Jen_T on 5 Feb 2010 10:01
I was curious if there is a formula that I can use to check if a cell
contains any of the values below?

"Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or
"0409"
From: Jacob Skaria on 5 Feb 2010 10:11
Try

=IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408SL","0408","0109","0209","0309","0409"},A1)),"Exist","Cannot find")

--
Jacob


"Jen_T" wrote:

> I was curious if there is a formula that I can use to check if a cell
> contains any of the values below?
>
> "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or
> "0409"
From: Jen_T on 5 Feb 2010 10:48
What if the cell value ,text, has other tect included, is there a way to
check if the cell value contains the text in the formula below?

"Jacob Skaria" wrote:

> Try
>
> =IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408SL","0408","0109","0209","0309","0409"},A1)),"Exist","Cannot find")
>
> --
> Jacob
>
>
> "Jen_T" wrote:
>
> > I was curious if there is a formula that I can use to check if a cell
> > contains any of the values below?
> >
> > "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or
> > "0409"
 | 
Pages: 1
Prev: Growth rate
Next: Finding the combination that appears more times