Forum Discussion
IF formula help
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...
=(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",""))