Forum Discussion

Julio_Cesar10's avatar
Julio_Cesar10
Copper Contributor
Dec 17, 2021
Solved

I got something wrong in the excel "if" formula, but I don't know what

I made a spreadsheet in which I show the months of the year and the monthly payment of the members of a group. If they paid, I put "OK" if not, I put "-". There, I used the following formula in the c...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Dec 17, 2021

    Julio_Cesar10 

    =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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Dec 17, 2021

Julio_Cesar10 

=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.

  • Julio_Cesar10's avatar
    Julio_Cesar10
    Copper Contributor
    Dec 18, 2021
    THNKS, I LV U

Resources