if =search() doesn't find it, it doesn't return a 0, it returns an error
(#value).

So you could rewrite your formula to just look for errors in both searches. (If
there are two errors, then you want an F, else put a T.

=IF(AND(ISERROR(SEARCH("live",J1&N1&R1)),
ISERROR(SEARCH("appoint",J1&N1&R1))),"F","T")

(all one cell)

Another way is to just look to see if one (or both) of the searches returned a
number:

=IF(OR(ISNUMBER(SEARCH("live",J1&N1&R1)),
ISNUMBER(SEARCH("appoint",J1&N1&R1))),"T","F")

And another way to write this is:
=IF(OR(ISNUMBER(SEARCH({"live","appoint"},J1&N1&R1 ))),"T","F")

(Yeah, I'm too lazy to type concatenate (well, except in this sentence!).)

You may even want to change J1&n1&r1 to j1&"."&n1&"."r1 just in case the values
could be concatenated (ouch, that hurt) to form one of your words.


Bruccce wrote:

I have the following

=IF(SEARCH("live",CONCATENATE(J1,N1,R1))0,"T",IF( SEARCH("appoint",CONCATENA
TE(J1,N1,R1))0,"T","F"))

in one of my cells.

What I am trying to do is to determine if cells, J,N or R have either of the
following words "live" or "appointment".
Each section seem to work OK by themselves however, when I put the test for
the appoint in the "false" spot of the first if statement, I get a #value!
even if there is an appoint in one of the 3 cells.

What would be the best way to code this?
I would also like to NOT get the #value! at all, even if neither string is
found.

Thanks
Bruce

--

Dave Peterson