Forum Discussion

Ivn_CE's avatar
Ivn_CE
Copper Contributor
Aug 29, 2020

A3 (lista desplegable con Masculino y Femenino), masculino funciona bien, femenino arroja falso.

=SI(Y(A3="Masculino","Femenino"),SI(A11<=5%,"Escencial",SI(A11<=13%,"Atleta",SI(A11<=17%,"En Forma",SI(A11<=24%,"Aceptable",SI(A11>24%,"Excesivo",SI(A11<=13%,"Escencial",SI(A11<=20%,"Atleta",SI(A11<=...
office 365
HansVogelaar's avatar
HansVogelaar
MVP
Aug 29, 2020

Ivn_CE 

A direct correction would be

 

=SI(Y(A3="Masculino", A3="Femenino"), SI(A11<=5%, "Escencial", SI(A11<=13%, "Atleta", SI(A11<=17%, "En Forma", SI(A11<=24%, "Aceptable", SI(A11>24%, "Excesivo", SI(A11<=13%, "Escencial", SI(A11<=20%, "Atleta", SI(A11<=24%, "En Forma", SI(A11<=31%, "Aceptable", SI(A11>31%, "Excesivo")))))))))))

 

But I don't think that is what you want. Perhaps it should be

 

=SI(Y(A3="Masculino", A3="Femenino"), SI(A11<=5%, "Escencial", SI(A11<=13%, "Atleta", SI(A11<=17%, "En Forma", SI(A11<=24%, "Aceptable", "Excesivo")))), SI(A11<=13%, "Escencial", SI(A11<=20%, "Atleta", SI(A11<=24%, "En Forma", SI(A11<=31%, "Aceptable", "Excesivo")))))

 

Or else

 

=SI(A3="Masculino", SI(A11<=5%, "Escencial", SI(A11<=13%, "Atleta", SI(A11<=17%, "En Forma", SI(A11<=24%, "Aceptable", "Excesivo")))), SI(A3="Femenino", SI(A11<=13%, "Escencial", SI(A11<=20%, "Atleta", SI(A11<=24%, "En Forma", SI(A11<=31%, "Aceptable", "Excesivo")))), ""))

 

That is for you to decide.