IF formula help

Copper Contributor

I have the following formula:
=(IF(OR(F2=0,H2=0,J2=0,N2=0,O2=0,S2=0,U2=0,W2=0,Y2=0,AA2=0,AC2=0),"YES",""))

 

This works great as long as each of those referenced cells have a value in them (0 or 1).  But if the referenced cell is blank, the formula is treating it as if it did have a zero in it and bringing in the YES result.   The first part works great - if there are any zeros at all in those cells, then the resulting cell says "YES".  But if all of those cells are made up of 1's and blanks (no zeros), I need the resulting cell to be blank.

1 Reply

@sbcauler1725 

 

=(IF(OR(AND(F2=0,F2<>""),AND(H2=0,H2<>""),AND(J2=0,J2<>""),AND(N2=0,N2<>""),AND(O2=0,O2<>""),AND(S2=0,S2<>""),AND(U2=0,U2<>""),AND(W2=0,W2<>""),AND(Y2=0,Y2<>""),AND(AA2=0,AA2<>""),AND(AC2=0,AC2<>"")),"YES",""))