{"id":17791,"date":"2022-02-27T09:40:00","date_gmt":"2022-02-27T14:40:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=17791"},"modified":"2026-02-04T22:08:09","modified_gmt":"2026-02-05T03:08:09","slug":"funcion-si-basica","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/","title":{"rendered":"Funci\u00f3n Si B\u00e1sica"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-funcion-si-excel-aprende-a-usarla-con-4-ejercicios-practicos\">Funci\u00f3n SI Excel: Aprende a Usarla con 4 Ejercicios Pr\u00e1cticos<\/h1>\n\n\n\n<p>La <strong>Funci\u00f3n SI Excel<\/strong> es, sin duda, una de las herramientas m\u00e1s fundamentales y potentes que les ense\u00f1o en <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">mi curso<\/a>. Para quienes inician en el mundo de la <a href=\"https:\/\/dostinhurtado.com\/site\/etiqueta-producto\/ofimatica\/\" target=\"_blank\" rel=\"noreferrer noopener\">ofim\u00e1tica<\/a>, dominarla marca un antes y un despu\u00e9s. Esta funci\u00f3n les permite automatizar decisiones, filtrar resultados y hacer que sus reportes cobren vida, respondiendo autom\u00e1ticamente a las condiciones que ustedes establezcan.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Nuevo Curso de Excel - Cap\u00edtulo 3, Funci\u00f3n Si B\u00e1sica \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/eGpAeHjhMsM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--60)\">En este tutorial, les traigo la soluci\u00f3n completa a la tarea de mi Cap\u00edtulo 3. <strong>Vamos a resolver<\/strong> juntos cuatro ejercicios pr\u00e1cticos que les ense\u00f1ar\u00e1n a manejar los <strong>condicionales en Excel<\/strong>, desde c\u00e1lculos num\u00e9ricos hasta comparaciones de texto.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-629087f1\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-18774c\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-e57a60 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/03\/Capitulo-3.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"currentColor\" viewBox=\"0 0 24 24\">\n  <path d=\"M2 19v-4a1 1 0 1 1 2 0v4c0 .548.452 1 1 1h14a1 1 0 0 0 1-1v-4a1 1 0 1 1 2 0v4a3 3 0 0 1-3 3H5c-1.652 0-3-1.348-3-3Z\"\/>\n  <path d=\"M12 1.5a1 1 0 0 0-1 1V8H7a1 1 0 0 0-.707 1.707l5 5a1 1 0 0 0 1.414 0l5-5A1 1 0 0 0 17 8h-4V2.5a1 1 0 0 0-1-1Z\"\/>\n<\/svg>\n<\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-b62da728\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-como-usar-la-funcion-si-en-excel\">\u00bfC\u00f3mo Usar la Funci\u00f3n SI en Excel?<\/h2>\n\n\n\n<p>La sintaxis b\u00e1sica que siempre les explico es simple:<\/p>\n\n\n\n<p><code>=SI(prueba_l\u00f3gica; valor_si_verdadero; valor_si_falso)<\/code><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Prueba L\u00f3gica:<\/strong> La pregunta o condici\u00f3n que Excel debe evaluar (ej: \u00bfson las ventas mayores a 1 mill\u00f3n?).<\/li>\n\n\n\n<li><strong>Valor_si_verdadero:<\/strong> Lo que Excel debe hacer si la respuesta a la pregunta es S\u00cd.<\/li>\n\n\n\n<li><strong>Valor_si_falso:<\/strong> Lo que Excel debe hacer si la respuesta a la pregunta es NO.<\/li>\n<\/ul>\n\n\n\n<p>Veamos esto en acci\u00f3n con los ejercicios que les dej\u00e9.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-93f2b373\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ejercicio 1: Calcular Comisiones (Mayor que)<\/h2>\n\n\n\n<p><strong>El problema:<\/strong> Si las ventas son mayores a 1.000.000, la comisi\u00f3n es del 10%. De lo contrario (si no), es del 5%.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Paso a Paso:<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-d1a33a20 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-155742-1024x369.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-155742.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-155742.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-155742-1024x369.avif\" alt=\"F\u00f3rmula de la Funci\u00f3n SI Excel siendo escrita en la celda para calcular comisiones del 10% o 5%.\" class=\"uag-image-26885\" width=\"1024\" height=\"369\" title=\"funcion-si-excel-formula-comisiones\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Iniciamos la f\u00f3rmula: En la celda de la comisi\u00f3n, escribimos <code>=SI(<\/code>.<\/li>\n\n\n\n<li><strong>Prueba L\u00f3gica:<\/strong> Hacemos clic en la celda de ventas (ej: <code>B5<\/code>) y escribimos la condici\u00f3n: <code>B5&gt;1000000<\/code>. Como les digo en el video, escriban el mill\u00f3n sin puntos ni comas.\n<ul class=\"wp-block-list\">\n<li><em>Nota importante:<\/em> Un error com\u00fan que veo en quienes inician es intentar seleccionar un rango (ej: <code>B5:B10<\/code>). Recuerden, la funci\u00f3n SI, en su uso b\u00e1sico, solo eval\u00faa una celda a la vez.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Valor_si_verdadero:<\/strong> Escribimos punto y coma (<code>;<\/code>). Si la venta es mayor a 1 mill\u00f3n, calculamos el 10%. La f\u00f3rmula es <code>B5*10%<\/code>.<\/li>\n\n\n\n<li><strong>Valor_si_falso:<\/strong> Escribimos otro punto y coma (<code>;<\/code>). Si la venta no fue mayor, la comisi\u00f3n ser\u00e1 del 5%. La f\u00f3rmula es <code>B5*5%<\/code>.<\/li>\n\n\n\n<li>Cierren la f\u00f3rmula: <code>)<\/code> y presionen Enter.<\/li>\n<\/ol>\n\n\n\n<p>Mi f\u00f3rmula completa se ve as\u00ed: <code>=SI(B5&gt;1000000; B5*10%; B5*5%)<\/code><\/p>\n\n\n\n<p>Al arrastrar la f\u00f3rmula (autorrelleno), notar\u00e1n algo clave que les muestro en el video: un valor de 1.000.000 exacto recibir\u00e1 el 5%, porque 1 mill\u00f3n no es <em>mayor<\/em> a 1 mill\u00f3n, es <em>igual<\/em>.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-e3a961be\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ejercicio 2: Control de Existencias (Menor o igual)<\/h2>\n\n\n\n<p><strong>El problema:<\/strong> Si en las existencias de un producto queda 1 o menos, debemos mostrar un mensaje \u00abS\u00ed\u00bb (comprar). S\u00ed hay m\u00e1s, un \u00abNo\u00bb.<\/p>\n\n\n\n<p>Esta vez, usamos la <strong>Funci\u00f3n SI Excel<\/strong> para devolver texto.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Paso a Paso:<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-263d610f wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160203-1024x400.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160203.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160203.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160203-1024x400.avif\" alt=\"Uso de comillas dobles para devolver el texto &quot;S\u00ed&quot; o &quot;No&quot; usando los condicionales en Excel.\" class=\"uag-image-26886\" width=\"1024\" height=\"400\" title=\"funcion-si-excel-devolver-texto-si-no\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Iniciamos la f\u00f3rmula: <code>=SI(<\/code>.<\/li>\n\n\n\n<li><strong>Prueba L\u00f3gica:<\/strong> Evaluamos si la cantidad (ej: <code>B12<\/code>) es menor o igual a 1. La condici\u00f3n es <code>B12&lt;=1<\/code>.\n<ul class=\"wp-block-list\">\n<li><em>L\u00f3gica alternativa:<\/em> Como les explico, tambi\u00e9n podr\u00edan usar <code>B12&lt;2<\/code> (menor a 2), lo cual funciona exactamente igual para este caso.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Valor_si_verdadero:<\/strong> Si se cumple, queremos que aparezca la palabra \u00abS\u00ed\u00bb. \u00a1Recuerden! Cuando usamos texto en las f\u00f3rmulas, debe ir entre comillas dobles: <code>\"S\u00ed\"<\/code>.<\/li>\n\n\n\n<li><strong>Valor_si_falso:<\/strong> Si hay m\u00e1s de 1 producto (ej: 5 o 30), queremos el texto <code>\"No\"<\/code>.<\/li>\n\n\n\n<li>Cierren la f\u00f3rmula: <code>)<\/code>.<\/li>\n<\/ol>\n\n\n\n<p>La f\u00f3rmula completa es: <code>=SI(B12&lt;=1; \"S\u00ed\"; \"No\")<\/code><\/p>\n\n\n\n<p>Este resultado luego lo podr\u00edamos usar para aplicar un <a href=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/formato-condicional\/\" target=\"_blank\" rel=\"noreferrer noopener\">formato condicional<\/a> (por ejemplo, pintar de rojo las celdas \u00abS\u00ed\u00bb), pero como les digo en el video, eso lo dejaremos para un tema m\u00e1s adelante.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-0f4a1742\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ejercicio 3: Comparar Objetivos (Entre Celdas)<\/h2>\n\n\n\n<p><strong>El problema:<\/strong> Si las ventas son iguales o mayores al objetivo, mostrar \u00abSi cumpli\u00f3\u00bb; de lo contrario, \u00abNo cumpli\u00f3\u00bb.<\/p>\n\n\n\n<p>Aqu\u00ed no usamos n\u00fameros fijos, sino que comparamos dos celdas, lo cual es ideal para tableros de control.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Paso a Paso:<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-85e0c816 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160345.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160345.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160345.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160345.avif\" alt=\"Resultado de la Funci\u00f3n SI Excel que compara una celda de venta contra una celda de objetivo, mostrando &quot;No cumpli\u00f3&quot;.\" class=\"uag-image-26887\" width=\"852\" height=\"446\" title=\"funcion-si-excel-comparar-celdas-objetivo\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Iniciamos la f\u00f3rmula: <code>=SI(<\/code>.<\/li>\n\n\n\n<li><strong>Prueba L\u00f3gica:<\/strong> Comparamos la celda de Venta (ej: <code>B18<\/code>) con la celda de Objetivo (ej: <code>C18<\/code>). La condici\u00f3n es <code>B18&gt;=C18<\/code>.<\/li>\n\n\n\n<li><strong>Valor_si_verdadero:<\/strong> Si la venta es mayor o igual, escribimos (entre comillas) <code>\"Si cumpli\u00f3\"<\/code>.<\/li>\n\n\n\n<li><strong>Valor_si_falso:<\/strong> Si es menor, escribimos <code>\"No cumpli\u00f3\"<\/code>.<\/li>\n\n\n\n<li>Cierren la f\u00f3rmula: <code>)<\/code>.<\/li>\n<\/ol>\n\n\n\n<p>La f\u00f3rmula completa es: <code>=SI(B18&gt;=C18; \"Si cumpli\u00f3\"; \"No cumpli\u00f3\")<\/code><\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-0fd2d2c6\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ejercicio 4: Condicional \u00abDiferente a\u00bb (Texto)<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-89b992b9 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160711-1024x390.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160711.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160711.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/02\/Captura-de-pantalla-2025-11-04-160711-1024x390.avif\" alt=\"F\u00f3rmula &quot;diferente a&quot; (<&gt;) de la Funci\u00f3n SI Excel aplicada para cobrar un recargo en D\u00f3lar o Euro.\" class=\"uag-image-26888\" width=\"1024\" height=\"390\" title=\"funcion-si-excel-diferente-a-recargo\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\"><strong>El problema:<\/strong> Si se paga con una moneda <em>diferente<\/em> a \u00abPesos\u00bb, se cobrar\u00e1 un 5% adicional al total. Este es un excelente ejemplo de los <strong>condicionales en Excel<\/strong> para manejar excepciones.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Paso a Paso:<\/h3>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Iniciamos la f\u00f3rmula: <code>=SI(<\/code>.<\/li>\n\n\n\n<li><strong>Prueba L\u00f3gica:<\/strong> Usamos el operador \u00abdiferente a\u00bb, que son los signos menor y mayor juntos: <code>&lt;&gt;<\/code>. Comparamos la celda de Moneda (ej: <code>C24<\/code>) con el texto \u00abPesos\u00bb. La condici\u00f3n es: <code>C24&lt;&gt;\"Pesos\"<\/code>.\n<ul class=\"wp-block-list\">\n<li><em>Advertencia:<\/em> Como les recalco en el video, \u00a1cuidado con esto! Excel debe encontrar una coincidencia exacta. \u00abPesos\u00bb con Z (\u00abPezos\u00bb), o \u00abPesos \u00bb con un espacio al final, ser\u00e1 considerado \u00abdiferente\u00bb y aplicar\u00e1 el recargo.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Valor_si_verdadero:<\/strong> Si la moneda es D\u00f3lar, Euro, etc., debemos sumar el 5% adicional. Tomamos el valor (ej: <code>B24<\/code>) y le sumamos ese mismo valor por el 5%: <code>B24+(B24*5%)<\/code>.<\/li>\n\n\n\n<li><strong>Valor_si_falso:<\/strong> Si la moneda S\u00cd es \u00abPesos\u00bb, no hay recargo. Simplemente dejamos el valor original: <code>B24<\/code>.<\/li>\n\n\n\n<li>Cierren la f\u00f3rmula: <code>)<\/code>.<\/li>\n<\/ol>\n\n\n\n<p>La f\u00f3rmula completa es: <code>=SI(C24&lt;&gt;\"Pesos\"; B24+(B24*5%); B24)<\/code><\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-b6a81e02\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Descarga el Archivo de Tarea y Compara<\/h2>\n\n\n\n<p>Tal como les menciono al final del video, la mejor forma de aprender es practicar. Les dejo el material de apoyo de este cap\u00edtulo para que puedan descargar el archivo, intentar resolver los ejercicios por su cuenta y luego comparar su soluci\u00f3n con la que acabo de explicarles.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Nuevo Curso de Excel - Cap\u00edtulo 3, Funci\u00f3n Si B\u00e1sica Gr\u00e1ficos Tarea \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/0WWikmQxHKA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-4c8dbe96\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo-0\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-71f829\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-06d018 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2022\/03\/Capitulo-3-tarea.xlsx\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"currentColor\" viewBox=\"0 0 24 24\">\n  <path d=\"M2 19v-4a1 1 0 1 1 2 0v4c0 .548.452 1 1 1h14a1 1 0 0 0 1-1v-4a1 1 0 1 1 2 0v4a3 3 0 0 1-3 3H5c-1.652 0-3-1.348-3-3Z\"\/>\n  <path d=\"M12 1.5a1 1 0 0 0-1 1V8H7a1 1 0 0 0-.707 1.707l5 5a1 1 0 0 0 1.414 0l5-5A1 1 0 0 0 17 8h-4V2.5a1 1 0 0 0-1-1Z\"\/>\n<\/svg>\n<\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-112076e7\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Dominar la <strong>Funci\u00f3n SI Excel<\/strong> les abre un mundo de posibilidades para automatizar sus hojas de c\u00e1lculo. Hoy aprendimos a usarla para:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Calcular comisiones con condiciones num\u00e9ricas (<code>&gt;<\/code>).<\/li>\n\n\n\n<li>Devolver texto de advertencia (<code>&lt;=<\/code> y <code>\"\"<\/code>).<\/li>\n\n\n\n<li>Comparar celdas din\u00e1micamente (<code>&gt;=<\/code>).<\/li>\n\n\n\n<li>Aplicar recargos usando la condici\u00f3n \u00abdiferente a\u00bb (<code>&lt;&gt;<\/code>).<\/li>\n<\/ul>\n\n\n\n<p>Este es solo el comienzo. <strong>Los invito<\/strong> a seguir practicando con <strong>mi<\/strong> <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">curso completo de Excel<\/a> y explorar otras herramientas de <a href=\"https:\/\/dostinhurtado.com\/site\/etiqueta-producto\/ofimatica\/\" target=\"_blank\" rel=\"noreferrer noopener\">ofim\u00e1tica<\/a> como <a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/curso-de-word-basico\/\" target=\"_blank\" rel=\"noreferrer noopener\">Word<\/a> que complementar\u00e1n su formaci\u00f3n. Para una gu\u00eda oficial, siempre pueden consultar la <a href=\"https:\/\/support.microsoft.com\/es-es\/office\/si-funci%C3%B3n-si-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2\" target=\"_blank\" rel=\"noreferrer noopener\">documentaci\u00f3n de Microsoft sobre la Funci\u00f3n SI<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-7c3afa8a uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-0d4bd963 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo usar un rango de celdas en la prueba l\u00f3gica de la Funci\u00f3n SI?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No para una prueba l\u00f3gica simple, como les explico en el video. La Funci\u00f3n SI est\u00e1 dise\u00f1ada para evaluar una sola condici\u00f3n (una celda) a la vez. Si necesitan evaluar rangos, deber\u00e1n combinarla con funciones como Y, O, o usar funciones m\u00e1s avanzadas como SUMAR.SI.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ef0196e4 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPor qu\u00e9 mi f\u00f3rmula SI me da error con el texto?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>El error m\u00e1s com\u00fan es olvidar las comillas dobles (<code>\"<\/code>). Como les muestro en el ejercicio 2, cualquier texto que quieran que la f\u00f3rmula eval\u00fae o devuelva (como \u00abS\u00ed\u00bb, \u00abNo\u00bb, o \u00abPesos\u00bb) debe estar encapsulado entre comillas.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-5e4db3b1 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo se escribe \u00abdiferente a\u00bb en Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Usamos los s\u00edmbolos menor que y mayor que juntos: <code>&lt;&gt;<\/code>. Por ejemplo, <code>A1&lt;&gt;\"Pesos\"<\/code> significa \u00absi A1 es diferente a Pesos\u00bb.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ce93783f \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>En el Ejercicio 1, si la venta es exactamente 1.000.000, \u00bfqu\u00e9 comisi\u00f3n recibe?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Recibe el 5%. La condici\u00f3n que puse fue <code>&gt;1000000<\/code> (mayor que). Como 1.000.000 no es <em>mayor<\/em> que 1.000.000 (es igual), la prueba l\u00f3gica da FALSO y aplica la comisi\u00f3n del 5%. Si quisi\u00e9ramos incluirlo, usar\u00edamos \u00abmayor o igual\u00bb (<code>&gt;=<\/code>).<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-c1f525f9 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo poner una Funci\u00f3n SI dentro de otra Funci\u00f3n SI?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>\u00a1S\u00ed! A eso le llamamos \u00abFunciones SI anidadas\u00bb y es una t\u00e9cnica poderosa para manejar m\u00faltiples condiciones (ej: si la venta es &gt; 1M, 10%; si es &gt; 500k, 7%; si no, 5%). Es uno de los siguientes pasos para dominar los <strong>condicionales en Excel<\/strong>.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n Si b\u00e1sica es una de las m\u00e1s importantes y usadas del Excel, es una funci\u00f3n condicional que funciona a partir de dos preguntas, una verdadera y otra falsa, es algo muy sencillo, pero con un sin fin de usos pr\u00e1cticos, es fundamental aprenderla y manejar todas sus condiciones (Mayor, Menor, Igual, Diferente, Mayor Igual, Menor Igual) Le ense\u00f1ar\u00e9 a escribirla correctamente y les mostrar\u00e9 un ejemplo pr\u00e1ctico de esta funci\u00f3n.<\/p>\n","protected":false},"author":4,"featured_media":27273,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1714],"tags":[1805,1719,540,562,225,1755,232,550,260,264,277,539,1812,1769,404,570,486],"class_list":["post-17791","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-curso-basico-intermedio","tag-1805","tag-aprender-excel","tag-basico","tag-curso","tag-excel","tag-excel-facil","tag-facil","tag-factura","tag-funcion-if","tag-funcion-si","tag-gratis","tag-gratuito","tag-microsoft-excel","tag-nuevo-curso","tag-principiantes","tag-recomendado","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Funci\u00f3n Si B\u00e1sica - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a usar la Funci\u00f3n SI Excel con 4 ejercicios pr\u00e1cticos. Domina las condiciones, comisiones y validaciones de texto para principiantes\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n Si B\u00e1sica\" \/>\n<meta property=\"og:description\" content=\"Aprende a usar la Funci\u00f3n SI Excel con 4 ejercicios pr\u00e1cticos. Domina las condiciones, comisiones y validaciones de texto para principiantes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-27T14:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-05T03:08:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Funci\u00f3n Si B\u00e1sica\",\"datePublished\":\"2022-02-27T14:40:00+00:00\",\"dateModified\":\"2026-02-05T03:08:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\"},\"wordCount\":1080,\"commentCount\":19,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif\",\"keywords\":[\"2022\",\"aprender Excel\",\"B\u00e1sico\",\"Curso\",\"Excel\",\"Excel f\u00e1cil\",\"Facil\",\"Factura\",\"funcion if\",\"funcion si\",\"Gratis\",\"Gratuito\",\"Microsoft Excel\",\"nuevo curso\",\"Principiantes\",\"recomendado\",\"Tutorial\"],\"articleSection\":[\"Nuevo Curso de Excel B\u00e1sico e Intermedio\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\",\"name\":\"Funci\u00f3n Si B\u00e1sica - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif\",\"datePublished\":\"2022-02-27T14:40:00+00:00\",\"dateModified\":\"2026-02-05T03:08:09+00:00\",\"description\":\"Aprende a usar la Funci\u00f3n SI Excel con 4 ejercicios pr\u00e1cticos. Domina las condiciones, comisiones y validaciones de texto para principiantes\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif\",\"width\":500,\"height\":375,\"caption\":\"funci\u00f3n si b\u00e1sica en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funci\u00f3n Si B\u00e1sica\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\",\"url\":\"https:\/\/dostinhurtado.com\/site\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\/\/dostinhurtado.com\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Funci\u00f3n Si B\u00e1sica - Dostin Hurtado","description":"Aprende a usar la Funci\u00f3n SI Excel con 4 ejercicios pr\u00e1cticos. Domina las condiciones, comisiones y validaciones de texto para principiantes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n Si B\u00e1sica","og_description":"Aprende a usar la Funci\u00f3n SI Excel con 4 ejercicios pr\u00e1cticos. Domina las condiciones, comisiones y validaciones de texto para principiantes","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/","og_site_name":"Dostin Hurtado","article_published_time":"2022-02-27T14:40:00+00:00","article_modified_time":"2026-02-05T03:08:09+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Funci\u00f3n Si B\u00e1sica","datePublished":"2022-02-27T14:40:00+00:00","dateModified":"2026-02-05T03:08:09+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/"},"wordCount":1080,"commentCount":19,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif","keywords":["2022","aprender Excel","B\u00e1sico","Curso","Excel","Excel f\u00e1cil","Facil","Factura","funcion if","funcion si","Gratis","Gratuito","Microsoft Excel","nuevo curso","Principiantes","recomendado","Tutorial"],"articleSection":["Nuevo Curso de Excel B\u00e1sico e Intermedio"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/","name":"Funci\u00f3n Si B\u00e1sica - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif","datePublished":"2022-02-27T14:40:00+00:00","dateModified":"2026-02-05T03:08:09+00:00","description":"Aprende a usar la Funci\u00f3n SI Excel con 4 ejercicios pr\u00e1cticos. Domina las condiciones, comisiones y validaciones de texto para principiantes","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif","width":500,"height":375,"caption":"funci\u00f3n si b\u00e1sica en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funcion-si-basica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Funci\u00f3n Si B\u00e1sica"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-3-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":19,"uagb_excerpt":"La funci\u00f3n Si b\u00e1sica es una de las m\u00e1s importantes y usadas del Excel, es una funci\u00f3n condicional que funciona a partir de dos preguntas, una verdadera y otra falsa, es algo muy sencillo, pero con un sin fin de usos pr\u00e1cticos, es fundamental aprenderla y manejar todas sus condiciones (Mayor, Menor, Igual, Diferente, Mayor&hellip;","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/17791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=17791"}],"version-history":[{"count":7,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/17791\/revisions"}],"predecessor-version":[{"id":27467,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/17791\/revisions\/27467"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/27273"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=17791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=17791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=17791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}