Condicional SI

[Roberto Paga Prieto]

<p style=”language: es-VE; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-indent: 0in;”><span style=”font-size: 11.0pt; font-family: Calibri; mso-ascii-font-family: Calibri; mso-fareast-font-family: +mn-ea; mso-bidi-font-family: +mn-cs; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-bidi-theme-font: minor-bidi; color: black; mso-color-index: 13; language: es-VE; font-weight: normal; font-style: normal; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;”>He tratado de construir un condicional en Excel de la siguiente forma:<span style=”mso-spacerun: yes;”>  </span>”=SI(18<=K9<=20;”100%”;”no beca”)” </span><span style=”font-size: 11.0pt; font-family: Calibri; mso-ascii-font-family: Calibri; mso-fareast-font-family: +mn-ea; mso-bidi-font-family: +mn-cs; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-bidi-theme-font: minor-bidi; color: black; mso-color-index: 13; language: es-VE; font-weight: normal; font-style: normal; vertical-align: baseline; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;”><span style=”mso-spacerun: yes;”> </span></span><span style=”font-size: 11.0pt; font-family: Calibri; mso-ascii-font-family: Calibri; mso-fareast-font-family: +mn-ea; mso-bidi-font-family: +mn-cs; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-bidi-theme-font: minor-bidi; color: black; mso-color-index: 13; language: es-VE; font-weight: normal; font-style: normal; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;”>y no me esta funcionando, no se si se</span><span style=”font-size: 11.0pt; font-family: Calibri; mso-ascii-font-family: Calibri; mso-fareast-font-family: +mn-ea; mso-bidi-font-family: +mn-cs; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-bidi-theme-font: minor-bidi; color: black; mso-color-index: 13; language: es-VE; font-weight: normal; font-style: normal; vertical-align: baseline; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;”> debe hacer con condicionales anidados o hay algún error en la formula. Cualquier ayuda es bien recibida. Gracias</span></p>

[Autor]

Entradas