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 cell:"=SE(H2=I2;SE(J2=K2;SE(L2=M2;SE(N2=O2;SE(P2=Q2;SE(R2=S2;"Integrante Kitado";"Integrante Devendo"))))))", the "SE" being the expression if of excel. What happens is that if I put a "-" in the column for the month of December, it shows "Member owed", or "Integrante devendo" in portuguese, but if I put in the month of January it shows "FALSE" and I don't know how to solve it, can someone help me?? what did i go wrong??

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.

2 Replies

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

Resources