ayuda con esta formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2082003%22%20slang%3D%22es-ES%22%3Ehelp%20with%20this%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2082003%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20problems%20with%20this%20formula%20because%20of%3A%20%22SI(G2%22No%22%20and(H2%22yes%22)%3B%22%20orange%22%3Byes(G2%22Yes%22%20and(H2%22No%22)%3B%22%20green%22%3Byellow%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2082003%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2082121%22%20slang%3D%22en-US%22%3ERe%3A%20ayuda%20con%20esta%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2082121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F937401%22%20target%3D%22_blank%22%3E%40pablosalinas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20it%20shall%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%20SI(%20(G2%3D%22No%22)*(H2%3D%22yes%22)%3B%22orange%22%3BSI(%20(G2%3D%22Yes%22)*(H2%3D%22No%22)%3B%22green%22%3B%22yellow%22))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E(not%20tested)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

tengo problemas con esta formula a que se debe::         =SI(G2="No" y(H2="yes");"naranjo";si(G2="Yes" y(H2="No");"verde";amarillo"))

2 Replies

@pablosalinas 

Perhaps it shall be

= SI( (G2="No")*(H2="yes");"orange";SI( (G2="Yes")*(H2="No");"green";"yellow"))

(not tested)

@pablosalinas 

Y is a function in Excel:

 

=SI(Y(G2="No";H2="Yes");"naranjo";SI(Y(G2="Yes";H2="No");"verde";amarillo"))