Michael,

Because of your note, I had to re-think what I was doing
and Lo and Behold, I got the formula to work It's
below for your future reference. Thanks a million times
over.

=IF(OR(AND('Appendix B'!D8="(47780)",J19-K190),(ISNUMBER
(FIND("53",'Appendix B'!D9))),(ISNUMBER(FIND("C",'Appendix
B'!D9))),(ISNUMBER(FIND("P",'Appendix B'!D9)))*AND(J19-
K190)),0,+J19-K19)


-----Original Message-----
If 47780 is in D8 and C, P, or 53S is in D9, what do you
expect the result
to be? Your current formula evaluates as TRUE if D8
contains 47780 and/or
D9 contains C, P, or 53S. For any of these combinations,
the result, in
accordance with your formula, will be 0. If D8 does not
contain 47780 and
D9 does not contain C, P, or 53S then the formula
evaluates as FALSE and
J19-K19 will be returned. Are you trying to come up with
something else?

Also, how do you want to incorporate the ISNUMBER formula
into your original
formula? What is the purpose?

Post back and maybe we can find the right answer.


--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

wrote in message
...
This formula works when 47780 is input into D8, however,
it does not work if C,P or 53S is in D9:
=IF(OR(AND('Appendix B'!D8="(47780)",J19-K190),AND(OR
('Appendix B'!D9="C",'Appendix B'!D9="P",'Appendix B'!
D9="53S"),J19-K190)),0,+J19-K19)

This OTHER formula works when P (just an example--same
formula is used for C and 53S.
=IF(ISNUMBER(FIND("P",'Appendix B'!D9)),'Appendix B'!
D42,0)

I need to incorporte the IF(ISNUMBER(FIND("P",'Appendix
B'!
D9... formula into the existing 1st formula for C,P, 53S
and can't do it.

Please help if you can. Thanks in advance.



.