Help, Help Help

[Guest]

I'm trying to get this result from the formula below and
am ready to throw the computer out the window. If
Appendix B D8 is equal to 47780 and M8 is greater than O
or if Appendix d9 = C, P, or 53S and M8 is greater than O,
result should be -m8 if any are true, or 0 if all are
fals. I cannot figure it out and would be forever
thankful if you could help.



=IF(AND(('Appendix B'!D8="(47780)",M8>0))IF(or(ISNUMBER
(FIND("C",'Appendix B'!d9)),(ISNUMBER(FIND("P",'Appendix
B'!d9))),(ISNUMBER(FIND("53S",'Appendix B'!d9)))),-m8,0))

 

[Andy B]

Hi

Try this:
=IF(OR(AND('APPENDIX B'!D8=47780,M8>0),AND(OR('APPENDIX B'!D9="C",'APPENDIX
B'!D9="P",'APPENDIX B'!D9="53S"),M8>0)),-M8,0)

 

[JulieD]

Hi

=IF(OR(AND('Appendix B'!D8=47780,M8>0),AND(OR('Appendix B'!D9="C",'Appendix
B'!D9="P",'Appendix B'!D9="53S"),M8>0)),-m8,0)

should give you what you need

Cheers
JulieD

 

[Guest]

Handy Andy,

I'm going to have to keep you, it works! Don't be
surprised if you see another posting from me, I wish I
could move you right beside me until I put this monster to
rest........you ARE the best!

 

[Guest]

Thank you Ms. Julie, you too are a keeper!

-----Original Message-----
Hi

=IF(OR(AND('Appendix B'!D8=47780,M8>0),AND(OR('Appendix B'!D9="C",'Appendix
B'!D9="P",'Appendix B'!D9="53S"),M8>0)),-m8,0)

should give you what you need

Cheers
JulieD




.

 

[Guest]

Thank you Ms. Julie, you too are a keeper!

-----Original Message-----
Hi

=IF(OR(AND('Appendix B'!D8=47780,M8>0),AND(OR('Appendix B'!D9="C",'Appendix
B'!D9="P",'Appendix B'!D9="53S"),M8>0)),-m8,0)

should give you what you need

Cheers
JulieD




.

 

[Andy B]

Thanks for the thanks!!

--
Andy.

Handy Andy,

I'm going to have to keep you, it works! Don't be
surprised if you see another posting from me, I wish I
could move you right beside me until I put this monster to
rest........you ARE the best!

 

[JulieD]

glad to help

Thank you Ms. Julie, you too are a keeper!