Hello,

I'm going to break down the problem a little bit.

Starting with row 1 I have:

=IF(AND(A1<>"",B1>0,C1<>"Y"),1,0)

No problem.

But what I want is a formula that will check this row by row to see if it's ever true and then return 1 else 0. Basically, I want a more compact form of:

=IF(OR(AND(A1<>"",B1>0,C1<>"Y"),AND(A2<>"",B2>0,C2<>"Y"),...,AND(A100<>"",B100>0,C100<>"Y")),1,0)

Any ideas?

Thanks,
Nik