{"id":23388,"date":"2025-02-03T12:30:00","date_gmt":"2025-02-03T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=23388"},"modified":"2025-04-04T16:49:59","modified_gmt":"2025-04-04T21:49:59","slug":"funcion-si-conjunto-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/","title":{"rendered":"Funci\u00f3n SI.CONJUNTO en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-domina-la-funcion-si-conjunto-en-excel-guia-completa-con-ejemplos\"><strong>Domina la funci\u00f3n SI.CONJUNTO en Excel: Gu\u00eda completa con ejemplos<\/strong><\/h1>\n\n\n\n<p>La funci\u00f3n <strong>SI.CONJUNTO<\/strong> en Excel es una de las herramientas m\u00e1s \u00fatiles para tomar decisiones basadas en m\u00faltiples condiciones. Desde su introducci\u00f3n en Excel 2019, ha permitido simplificar la anidaci\u00f3n de m\u00faltiples funciones <strong>SI<\/strong>, lo que hace que las hojas de c\u00e1lculo sean m\u00e1s eficientes y f\u00e1ciles de entender. En este art\u00edculo, aprender\u00e1s c\u00f3mo usar la funci\u00f3n SI.CONJUNTO correctamente, ver\u00e1s ejemplos pr\u00e1cticos y responderemos a las preguntas m\u00e1s frecuentes para que domines esta poderosa herramienta.<\/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=\"\ud83d\udd25Domina la Funci\u00f3n SI.CONJUNTO en Excel: Comparativa con SI Anidada y Ejemplos Pr\u00e1cticos\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/J9P9ezON-n0?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-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-4a485c\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-aff56d ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Factura.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es la funci\u00f3n SI.CONJUNTO en Excel?<\/h2>\n\n\n\n<p>La funci\u00f3n <strong>SI.CONJUNTO<\/strong> permite evaluar m\u00faltiples condiciones sin necesidad de anidar varias funciones SI. Funciona de forma secuencial: eval\u00faa cada condici\u00f3n en orden y devuelve el resultado correspondiente a la primera que se cumple. Esta es la esencia de la funci\u00f3n SI.CONJUNTO en Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sintaxis b\u00e1sica:<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>SI.CONJUNTO(prueba_l\u00f3gica1, valor_si_verdadero1, [prueba_l\u00f3gica2, valor_si_verdadero2], ...)<br><\/code><\/pre>\n\n\n\n<p>A diferencia de la funci\u00f3n SI tradicional, <strong>SI.CONJUNTO no requiere definir un \u00abvalor falso\u00bb<\/strong>, lo que hace que las f\u00f3rmulas sean m\u00e1s compactas. Este aspecto \u00fanico de la funci\u00f3n SI.CONJUNTO la hace muy poderosa.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-funcion-si-conjunto-en-excel-comparativa-si-anidada-vs-si-conjunto\">Funci\u00f3n SI.CONJUNTO en Excel-Comparativa:SI anidada vs SI.CONJUNTO<\/h2>\n\n\n\n<p>Antes, para evaluar m\u00faltiples condiciones, us\u00e1bamos la funci\u00f3n SI anidada:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"e9ebed\" data-has-transparency=\"false\" fetchpriority=\"high\" decoding=\"async\" width=\"614\" height=\"363\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-47-png.avif\" alt=\"Comparativa de f\u00f3rmulas de Excel: funci\u00f3n SI anidada vs. funci\u00f3n SI.CONJUNTO para calcular descuentos seg\u00fan la forma de pago.\" class=\"wp-image-25158 not-transparent\" style=\"--dominant-color: #e9ebed; width:411px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-47-png.avif 614w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-47-300x177.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-47-600x355.avif 600w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SI(A2=\"Visa\",15%,SI(A2=\"Amex\",30%,0%))<br><\/code><\/pre>\n\n\n\n<p>Con SI.CONJUNTO, la misma l\u00f3gica se puede escribir de forma m\u00e1s clara:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"e9ebed\" data-has-transparency=\"true\" decoding=\"async\" width=\"610\" height=\"361\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-46-png.avif\" alt=\"Comparativa de f\u00f3rmulas de Excel: uso de la funci\u00f3n SI anidada vs. la funci\u00f3n SI.CONJUNTO para evaluar m\u00faltiples condiciones en una tabla de ventas.\" class=\"wp-image-25157 has-transparency\" style=\"--dominant-color: #e9ebed; width:389px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-46-png.avif 610w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-46-300x178.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-46-600x355.avif 600w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SI.CONJUNTO(A2=\"Visa\",15%, A2=\"Amex\",30%, VERDADERO,0%)<br><\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-funcion-si-conjunto-en-excel-ejemplo-1-descuento-segun-forma-de-pago\">Funci\u00f3n SI.CONJUNTO en Excel-Ejemplo 1: Descuento seg\u00fan forma de pago<\/h2>\n\n\n\n<p>Supongamos que tienes una tienda y quieres aplicar descuentos seg\u00fan la tarjeta usada:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Forma de pago<\/th><th>Descuento<\/th><\/tr><\/thead><tbody><tr><td>Visa<\/td><td>15%<\/td><\/tr><tr><td>American Express<\/td><td>30%<\/td><\/tr><tr><td>Otro<\/td><td>0%<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>F\u00f3rmula con SI.CONJUNTO:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SI.CONJUNTO(A2=\"Visa\",15%, A2=\"Amex\",30%, VERDADERO,0%)<br><\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplo 2: Evaluar desempe\u00f1o laboral<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"eceeef\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"194\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-48-1024x194.avif\" alt=\"\" class=\"wp-image-25159 has-transparency\" style=\"--dominant-color: #eceeef; width:861px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-48-1024x194.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-48-300x57.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-48-768x145.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-48-600x114.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-48-png.avif 1152w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Queremos clasificar el desempe\u00f1o de un empleado seg\u00fan su porcentaje:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>90% o m\u00e1s:<\/strong> Excelente<\/li>\n\n\n\n<li><strong>70% a 89%:<\/strong> Bueno<\/li>\n\n\n\n<li><strong>Menos de 70%:<\/strong> Necesita mejora<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SI.CONJUNTO(C2>=90,\"Excelente\", C2>70,\"Bueno\", VERDADERO,\"Necesita mejora\")<br><\/code><\/pre>\n\n\n\n<p>Este ejemplo demuestra c\u00f3mo manejar rangos num\u00e9ricos de manera efectiva con SI.CONJUNTO.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplo 3: Evaluaci\u00f3n de bono navide\u00f1o<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"ecedee\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"185\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-1024x185.avif\" alt=\"\" class=\"wp-image-25160 has-transparency\" style=\"--dominant-color: #ecedee; width:848px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-1024x185.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-300x54.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-768x138.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-1536x277.avif 1536w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-600x108.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/02\/image-49-png.avif 1708w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Queremos asignar un bono dependiendo de dos factores:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Cumplimiento &gt; 90%<\/strong> y <strong>Asistencia &gt; 95%:<\/strong> Bono completo<\/li>\n\n\n\n<li>Si <strong>uno solo<\/strong> de los dos se cumple: Bono parcial<\/li>\n\n\n\n<li>Si <strong>ninguno<\/strong> se cumple: Sin bono<\/li>\n<\/ul>\n\n\n\n<p>F\u00f3rmula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SI.CONJUNTO(<br>  Y(A2>90, B2>95), \"Bono completo\",<br>  O(A2>90, B2>95), \"Bono parcial\",<br>  VERDADERO, \"Sin bono\"<br>)<br><\/code><\/pre>\n\n\n\n<p>Aqu\u00ed se combinan funciones como <strong>Y()<\/strong> y <strong>O()<\/strong> dentro de SI.CONJUNTO para manejar m\u00faltiples criterios. Esta combinaci\u00f3n en la funci\u00f3n SI.CONJUNTO en Excel es muy \u00fatil.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-ventajas-de-usar-funcion-si-conjunto-en-excel\">Ventajas de usar Funci\u00f3n SI.CONJUNTO en Excel<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mayor claridad:<\/strong> Se entiende f\u00e1cilmente qu\u00e9 condiciones se eval\u00faan y qu\u00e9 se devuelve.<\/li>\n\n\n\n<li><strong>C\u00f3digo m\u00e1s limpio:<\/strong> Menos anidamiento de funciones.<\/li>\n\n\n\n<li><strong>M\u00e1s control:<\/strong> Puedes manejar m\u00faltiples condiciones sin errores de sintaxis.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfTienes una versi\u00f3n antigua de Excel?<\/h2>\n\n\n\n<p>La funci\u00f3n <strong>SI.CONJUNTO<\/strong> solo est\u00e1 disponible desde Excel 2019. Si tienes una versi\u00f3n anterior, puedes actualizar tu Office f\u00e1cilmente. Una excelente opci\u00f3n es comprar licencias vitalicias en <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong>, donde puedes conseguir <strong>Office 2019 o 2021<\/strong> con el c\u00f3digo de descuento <strong>DH66. <\/strong>Actualizar es esencial para aprovechar la funci\u00f3n SI.CONJUNTO en Excel.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>La <strong>funci\u00f3n SI.CONJUNTO en Excel<\/strong> es ideal para reemplazar m\u00faltiples condiciones anidadas. Ya sea que est\u00e9s aplicando descuentos, evaluando desempe\u00f1o o calculando bonificaciones, esta funci\u00f3n mejora significativamente tus f\u00f3rmulas. \u00a1Pru\u00e9bala en tus hojas de c\u00e1lculo y ver\u00e1s la diferencia!<\/p>\n\n\n\n<p>\ud83d\ude31 \u00a1No m\u00e1s dolores de cabeza con Excel! Este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel <\/a><\/strong>te ense\u00f1a paso a paso c\u00f3mo sacarle el m\u00e1ximo provecho a tus hojas de c\u00e1lculo. Ideal si quieres impresionar en el trabajo o tener todo bajo control. \ud83d\udca1\ud83d\udd25 \u00a1No te lo pierdas!<\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-c4fbb4e1\"><h2 class=\"uagb-heading-text\">Preguntas Frecuentes<\/h2><\/div>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-e991e4c5 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-d3502f52 \" 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>\u00bfEn qu\u00e9 versiones de Excel est\u00e1 disponible SI.CONJUNTO?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n <strong>SI.CONJUNTO<\/strong> est\u00e1 disponible en <strong>Excel 2019, Excel 2021 y Microsoft 365<\/strong>. Si usas una versi\u00f3n anterior, tendr\u00e1s que recurrir a <strong>SI anidado<\/strong> o actualizar tu Office.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-9e492ff0 \" 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>\u00bfCu\u00e1l es la diferencia entre SI.CONJUNTO y SI anidado?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La principal diferencia es la simplicidad. Con <strong>SI.CONJUNTO<\/strong>, puedes evaluar m\u00faltiples condiciones sin necesidad de anidar varias funciones SI, lo que hace que la f\u00f3rmula sea m\u00e1s corta y f\u00e1cil de entender. Con <strong>SI anidado<\/strong>, debes escribir una funci\u00f3n SI dentro de otra, lo que puede volverse complejo y dif\u00edcil de mantener.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8ab2cf9d \" 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>\u00bfSe puede usar SI.CONJUNTO con valores num\u00e9ricos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes utilizar valores num\u00e9ricos dentro de las condiciones. Por ejemplo, si quieres clasificar edades en rangos:<br>=SI.CONJUNTO(A2&lt;18, \u00abMenor de edad\u00bb, A2&lt;60, \u00abAdulto\u00bb, VERDADERO, \u00abTercera edad\u00bb)<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-e7f1e408 \" 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>\u00bfQu\u00e9 pasa si ninguna condici\u00f3n se cumple?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si ninguna condici\u00f3n se cumple y no agregaste un caso <strong>VERDADERO<\/strong>, Excel devolver\u00e1 un error <strong>#N\/A<\/strong>. Para evitarlo, siempre es recomendable incluir una \u00faltima condici\u00f3n con <strong>VERDADERO<\/strong> como valor predeterminado.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-c2f86327 \" 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 combinar SI.CONJUNTO con funciones como Y y O?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>\u00a1Claro que s\u00ed! Es com\u00fan combinar funciones como <code>Y()<\/code> o <code>O()<\/code> dentro de las pruebas l\u00f3gicas para evaluar m\u00faltiples criterios.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.<\/p>\n","protected":false},"author":3,"featured_media":23391,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","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":[52],"tags":[1719,225,264,344,365],"class_list":["post-23388","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-aprender-excel","tag-excel","tag-funcion-si","tag-microsoft","tag-office","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Funci\u00f3n SI.CONJUNTO en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.\" \/>\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\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n SI.CONJUNTO en Excel - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-03T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-04T21:49:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"976\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\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=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/4cccf51633cffba81a46211a8ab89daa\"},\"headline\":\"Funci\u00f3n SI.CONJUNTO en Excel\",\"datePublished\":\"2025-02-03T17:30:00+00:00\",\"dateModified\":\"2025-04-04T21:49:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/\"},\"wordCount\":648,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/Funcion-Si-Conjunto-Excel-miniatura-06.avif\",\"keywords\":[\"aprender Excel\",\"Excel\",\"funcion si\",\"Microsoft\",\"office\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/\",\"name\":\"Funci\u00f3n SI.CONJUNTO en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/Funcion-Si-Conjunto-Excel-miniatura-06.avif\",\"datePublished\":\"2025-02-03T17:30:00+00:00\",\"dateModified\":\"2025-04-04T21:49:59+00:00\",\"description\":\"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/Funcion-Si-Conjunto-Excel-miniatura-06.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/Funcion-Si-Conjunto-Excel-miniatura-06.avif\",\"width\":976,\"height\":750,\"caption\":\"Funci\u00f3n Si Conjunto Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/funcion-si-conjunto-en-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funci\u00f3n SI.CONJUNTO en Excel\"}]},{\"@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\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"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\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"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\\\/4cccf51633cffba81a46211a8ab89daa\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1783346535\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1783346535\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1783346535\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/daniel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n SI.CONJUNTO en Excel - Dostin Hurtado","description":"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.","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\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n SI.CONJUNTO en Excel - Dostin Hurtado","og_description":"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-02-03T17:30:00+00:00","article_modified_time":"2025-04-04T21:49:59+00:00","og_image":[{"width":976,"height":750,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/4cccf51633cffba81a46211a8ab89daa"},"headline":"Funci\u00f3n SI.CONJUNTO en Excel","datePublished":"2025-02-03T17:30:00+00:00","dateModified":"2025-04-04T21:49:59+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/"},"wordCount":648,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif","keywords":["aprender Excel","Excel","funcion si","Microsoft","office"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/","name":"Funci\u00f3n SI.CONJUNTO en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif","datePublished":"2025-02-03T17:30:00+00:00","dateModified":"2025-04-04T21:49:59+00:00","description":"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif","width":976,"height":750,"caption":"Funci\u00f3n Si Conjunto Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/funcion-si-conjunto-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Funci\u00f3n SI.CONJUNTO en Excel"}]},{"@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\/6bc1fbb1a73635ac2e186182146d04e9"},"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\/6bc1fbb1a73635ac2e186182146d04e9","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\/4cccf51633cffba81a46211a8ab89daa","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1783346535","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1783346535","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1783346535","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif",976,750,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-300x231.avif",300,231,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-768x590.avif",768,590,true],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif",976,750,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif",976,750,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif",976,750,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06.avif",976,750,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-870x570.avif",870,570,true],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-600x750.avif",600,750,true],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-600x600.avif",600,600,true],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-400x400.avif",400,400,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-600x461.avif",600,461,true],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Funcion-Si-Conjunto-Excel-miniatura-06-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"},"uagb_comment_info":0,"uagb_excerpt":"Aprende a usar la funci\u00f3n SI.CONJUNTO en Excel con ejemplos pr\u00e1cticos y comparativas. Domina su l\u00f3gica paso a paso y mejora tus f\u00f3rmulas.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23388","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=23388"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23388\/revisions"}],"predecessor-version":[{"id":25161,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23388\/revisions\/25161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/23391"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=23388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=23388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=23388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}