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.