I apologize for slow reply!
I ended up using: =IF(AND(C$54=0,C$55=1),1,IF(C49=0,0,1))
which obviously far from my original issue.
Simon4s: It still doesn't work. On my screen now are 2 1s in that range and the value for the formula is 0 (entered as an array formula).
Everyone else: I appreciate your suggestions; I learned some new approaches to the same issue, always a plus!