If(AND(OR... Statement works on half of the equation

[Deshaine]

Good Day to all...

Please assist. I've compiled the following formula, with accurate results generating from the left OR statement; however, the right OR statement generates a blank answer.

=IF(OR((AND(OR(A2="C",A2=""),B2="BK")),(AND(OR(B2="0",B2="59"),A2="A"))),"Bankruptcy","")

Thank you for your assistance. Your time is appreciated.

 

[mikerickson]

I'd restate it
=IF(OR(B2=0,B2=59), IF(A2="A","Bankruptcy",""), IF(OR(A2="C",A2=""), IF(B2="BK","Bankruptcy",""),""))

 

[CharlesChuckieCharles]

Are the values text or numeric

=IF(OR((AND(OR(A2="C",A2=""),B2="BK")),(AND(OR(B2="0",B2="59"),A2="A"))),"Bankruptcy","")

should it be

=IF(OR((AND(OR(A2="C",A2=""),B2="BK")),(AND(OR(B2=0,B2=59),A2="A"))),"Bankruptcy","")

 

[Deshaine]

Removing the quotes worked! Many thanks! MANY, MANY, MANY thanks!!ray: