If you define L as a defined name with a refers to value of
={"T";"X";"Y";"Z"} that will work, or put those values in a set of cells and
name those cells as L.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nastech" wrote in message
...
hi, have been using this example & works, but would think there would be a
shorter way of using it, especially in a defined name.. example working on

=IF(SUMPRODUCT(--ISNUMBER(FIND(L,CO9)))0,

would think defined name could be as an "OR" ?

for: CO9=L

(L: defined has multiple chars: ={"T";"X";"Y";"Z"}
where T responds, but not any of XYZ


the following is just getting longer & longer... thanks
=IF(ISNUMBER(CP748),CP748+IF(SUMPRODUCT(--ISNUMBER(FIND(L,CO748)))0,IF(SUMPRODUCT(--ISNUMBER(FIND(preA,CQ748)))0,2,IF(SUMPRODUCT(--ISNUMBER(FIND(wav2,CR748)))0,1)),0),0)



"Bob Phillips" wrote:

=SUMPRODUCT(--(ISNUMBER(FIND({"X","H"},A26))))0

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Nastech" wrote in message
...
080425 FIND 1 char in cell of any 3 char =True

been having trouble figuring out SEARCH & FIND, trying to find if a
character in a cell is present. do not see any TRUE/FALSE examples,
just
a
bunch of errors.

finally have following work in a cond. format:
=SEARCH(A9,$A$2)

where only 1 character/number exists in A9, and multiple chars in $A$2

now need to test A9 if has "H" for e.g.: HLA
actually need to test for multiple characters in A9, e.g.: "X","H"
would use fixed cell to test for, to save space
would use smaller functions to save space, FIND instead of SEARCH, but
not
critical
thanks