Forum Discussion
I got something wrong in the excel "if" formula, but I don't know what
=IF(AND(H2=I2,J2=K2,L2=M2,N2=O2,P2=Q2,R2=S2),"Integrante Kitado","Integrante Devendo")
Are you looking for the formula above?
=IF(H2=I2,IF(J2=K2,IF(L2=M2,IF(N2=O2,IF(P2=Q2,IF(R2=S2,"Integrante Kitado","Integrante Devendo"))))))
In this formula there is no else part entered in case that the condition H2=I2 is false. Therefore the formula returns false if you enter "-" for january and "ok" for february as shown in attached file.
=IF(AND(H2=I2,J2=K2,L2=M2,N2=O2,P2=Q2,R2=S2),"Integrante Kitado","Integrante Devendo")
Are you looking for the formula above?
=IF(H2=I2,IF(J2=K2,IF(L2=M2,IF(N2=O2,IF(P2=Q2,IF(R2=S2,"Integrante Kitado","Integrante Devendo"))))))
In this formula there is no else part entered in case that the condition H2=I2 is false. Therefore the formula returns false if you enter "-" for january and "ok" for february as shown in attached file.