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
Bookmarks