Home

Función SI

%3CLINGO-SUB%20id%3D%22lingo-sub-847985%22%20slang%3D%22en-US%22%3EFunci%C3%B3n%20SI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847985%22%20slang%3D%22en-US%22%3E%3CP%3EBuen%20d%C3%ADa%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETengo%20el%20siguiente%20inconveniente%2C%20tengo%20una%20celda%20donde%20tengo%20varias%20funciones%20SI%20dentro%20de%20otras%2C%20sin%20embargo%20me%20podr%C3%ADa%20ahorrar%20algo%20de%20espacio%2C%20si%20pudiera%20saber%20cuando%20la%20funci%C3%B3n%20l%C3%B3gica%20es%20falso%2C%20continuar%20a%20la%20primera%20funci%C3%B3n%20SI%20anterior(donde%20se%20cumpli%C3%B3).%3C%2FP%3E%3CP%3EEjemplo%3C%2FP%3E%3CP%3ESI(A1%3D1%2CSI(D1%3D1%2C1%2C%5Baqu%C3%AD%20es%20donde%20quiero%20poner%20algo%20para%20continuar%20con%20la%20primera%20funci%C3%B3n%5D)%2CSI(A1%3D2%2CSI(C1%3D1%2C1%2C%5Bfunci%C3%B3n%20o%20formula%5D)%2C0))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEspero%20se%20entienda%3C%2FP%3E%3CP%3ESaludos%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847985%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
PacoHuerta
Occasional Visitor

Buen día

 

Tengo el siguiente inconveniente, tengo una celda donde tengo varias funciones SI dentro de otras, sin embargo me podría ahorrar algo de espacio, si pudiera saber cuando la función lógica es falso, continuar a la primera función SI anterior(donde se cumplió).

Ejemplo

SI(A1=1,SI(D1=1,1,[aquí es donde quiero poner algo para continuar con la primera función]),SI(A1=2,SI(C1=1,1,[función o formula]),0))

 

Espero se entienda

Saludos

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies