FUNCION SI

%3CLINGO-SUB%20id%3D%22lingo-sub-2915727%22%20slang%3D%22es-ES%22%3EFUNCTION%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2915727%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20good%20afternoon%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20with%20the%20%22yes%22%20function%20in%20excel%20and%20what%20I%20want%20to%20do%20is%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(W9%26gt%3B%3D9%2C%229%22%2C%22and%20in%20case%20it%20is%20not%20fulfilled%20do%20nothing%20and%20leave%20the%20value%20of%20W9)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20mean%20what%20I%20want%20to%20do%20which%20is%20with%20the%20YES%20function%2C%20I%20check%20if%20a%20cell%20is%20greater%20than%20or%20equal%20to%20%229%22%20in%20case%20yes%2C%20to%20leave%20it%20at%20%229%22%20but%20if%20it%20is%20not%20greater%20than%20or%20equal%20to%20%229%22%2C%20to%20leave%20the%20same%20value%20of%20the%20cell%2C%20whether%20it%20has%20an%208%20or%20a%207%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2915727%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2915855%22%20slang%3D%22en-US%22%3ERe%3A%20FUNCION%20SI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2915855%22%20slang%3D%22en-US%22%3EIF(W9%26gt%3B%3D9%2C%229%22%2CW9)%3CBR%20%2F%3E%3CBR%20%2F%3ESI(W9%26gt%3B%3D9%3B%229%22%3BW9)%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola buenas tardes,

 

Estoy trabajando con la funcion "si" en excel y lo que quiero hacer es lo siguiente:

 

=SI(W9>=9,"9","y en caso de que no se cumpla que no haga nada y deje el valor de W9)

 

Osea lo que quiero hacer que es con la funcion SI, me verifique si una celda es mayor o igual a "9" en caso de que si, que lo deje en "9" pero si no es mayor o igual a "9", que deje el mismo valor de la celda, ya sea que tenga un 8 o un 7 etc.

 

Gracias de antemano

 

Saludos Cordiales

1 Reply
IF(W9>=9,"9",W9)

SI(W9>=9;"9";W9)