Funcion SI con varias variables en una sola letra

%3CLINGO-SUB%20id%3D%22lingo-sub-2939624%22%20slang%3D%22es-ES%22%3EYES%20function%20with%20multiple%20variables%20in%20a%20single%20letter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2939624%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20I%20would%20like%20to%20know%20if%20there%20is%20any%20way%20for%20a%20if%20to%20have%20several%20possible%20answers%20without%20needing%20to%20nest%20so%20many%20SI's%20in%20a%20single%20function%3F%20For%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESI(J2%3DX*%3B%20%22TRUE%22%3B%22%20FALSE%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*where%20X%20can%20be%20worth%20for%20example%20the%20following%20characters%3A%20A%2CB%2CC%2CD%2CE%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2939624%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2939743%22%20slang%3D%22en-US%22%3ERe%3A%20Funcion%20SI%20con%20varias%20variables%20en%20una%20sola%20letra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2939743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1211439%22%20target%3D%22_blank%22%3E%40Pablo0626%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSI(O(J2%3D%7B%22A%22%3B%22B%22%3B%22C%22%3B%22D%22%3B%22E%22%7D)%3B%22VERDADERO%22%3B%22FALSO%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2939805%22%20slang%3D%22en-US%22%3ERe%3A%20Funcion%20SI%20con%20varias%20variables%20en%20una%20sola%20letra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2939805%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20IF%20will%20not%20be%20possible%20with%20wildcards.%20You%20need%20instead%20use%20another%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3D%40IF(COUNTIF(J2%3B%7B%22A*%22%3B%22B*%22%3B%22C*%22%3B%22D*%22%3B%22E*%22%7D)%3B%22Verdadeiro%22%3B%22Falso%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIt%20is%20one%20of%20many%20approaches%20you%20can%20try.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2940072%22%20slang%3D%22es-ES%22%3ERe%3A%20Yes%20function%20with%20several%20variables%20in%20a%20single%20letter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2940072%22%20slang%3D%22es-ES%22%3Eand%20what%20if%20for%20example%20I%20wanted%20to%20have%202%20conditions%20for%20something%20to%20be%20true%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3DSI(O(J2%3D%7B%22A%22%3B%22%20B%22%3B%22%20C%22%3B%22%20D%22%3B%22%20E%22%7D%3B%20K3%3D%7B%22Q%22%3B%22%20R%22%3B%22%20S%22%3B%22%20T%22%7D%20)%3B%22%20TRUE%22%3B%22%20FALSE%22)%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20where%20for%20it%20to%20be%20true%20both%20J2%20and%20K3%20conditions%20must%20be%20met%3F%3C%2FLINGO-BODY%3E
New Contributor

Buenas quisiera saber si hay alguna forma de que un si tenga varias posibles respuestas sin necesidad de anidar tantos SI's en una sola funcion? por ejemplo:

 

SI(J2=X*; "VERDADERO";"FALSO")

 

*donde X pueda valer por ejemplo los siguientes caracteres: A,B,C,D,E 

5 Replies

@Pablo0626 

 

=SI(O(J2={"A";"B";"C";"D";"E"});"VERDADERO";"FALSO")

Using IF will not be possible with wildcards. You need instead use another formula:

 

 

=@IF(COUNTIF(J2;{"A*";"B*";"C*";"D*";"E*"});"Verdadeiro";"Falso")

 

 


It is one of many approaches you can try.

y que pasa si por ejemplo quisiera tener 2 condiciones para que algo sea verdadero

=SI(O(J2={"A";" B";" C";" D";" E"};K3={"Q";"R";"S";"T"} );" VERDADERO";" FALSO")

donde para que sea verdadero debe cumplirse ambas condiciones tanto la de J2 como la de K3?

=IF(N(@IFERROR((J2={"A";" B";" C";" D";" E"})+(K2={"Q";"R";"S";"T"});0))>1;"Verdadero";"Falso")

Another variant

 

=IF(@ISNUMBER(SEARCH({"A";"B";"C";"D";"E"}; J2)*(SEARCH({"Q";"R";"S"}; K2))); "Verdadero"; "Falso")

@Pablo0626 

 

=SI(Y(O(J2={"A";"B";"C";"D";"E"});O(K3={"Q";"R";"S";"T"}));"VERDADERO";"FALSO")