Condicional SI

Viendo 1 entrada (de un total de 1)
  • Autor
    Entradas
  • #19757

    Roberto Paga Prieto
    Participante

    <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>

Viendo 1 entrada (de un total de 1)
  • Debes estar registrado para responder a este debate.