{"id":24291,"date":"2025-03-19T12:00:22","date_gmt":"2025-03-19T17:00:22","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=24291"},"modified":"2025-04-02T02:09:12","modified_gmt":"2025-04-02T07:09:12","slug":"wps-sheets-capitulo-4-funciones-condicionales","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/","title":{"rendered":"WPS Sheets Cap\u00edtulo 4: funciones condicionales"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-wps-sheets-capitulo-4-domina-las-funciones-condicionales-funcion-si-contar-si-sumar-si-y-mas\">WPS Sheets Cap\u00edtulo 4: Domina las Funciones Condicionales (Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y M\u00e1s)<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">En este cap\u00edtulo de&nbsp;<strong>WPS Sheets Cap\u00edtulo 4: funciones condicionales<\/strong>, exploraremos las&nbsp;<strong>funciones condicionales<\/strong>, una herramienta esencial para optimizar tus hojas de c\u00e1lculo. Aprender\u00e1s a utilizar la funci\u00f3n&nbsp;<strong>SI<\/strong>,&nbsp;<strong>CONTAR.SI<\/strong>,&nbsp;<strong>SUMAR.SI<\/strong>&nbsp;y otras funciones l\u00f3gicas que te permitir\u00e1n automatizar c\u00e1lculos y tomar decisiones basadas en condiciones espec\u00edficas. \u00a1Sigue leyendo para dominar estas funciones y llevar tus habilidades con WPS Sheets al siguiente nivel!<\/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=\"wps capitulo 4\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/oiWuxOTt4tE?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 wp-block-paragraph\">\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-544fd5\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-500587 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-Sheet-capitulo-4.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<p class=\"wp-block-paragraph\">\ud83d\udce2 <strong>\u00a1No te pierdas el cap\u00edtulo anterior!<\/strong> En <strong><a href=\"https:\/\/dostinhurtado.com\/site\/cursos\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/\" target=\"_blank\" rel=\"noreferrer noopener\">WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas<\/a><\/strong>, aprendimos a utilizar las herramientas esenciales para manejar datos de manera eficiente. Si a\u00fan no lo has visto, te recomiendo revisarlo antes de continuar, ya que te dar\u00e1 una base s\u00f3lida para sacarle el m\u00e1ximo provecho a WPS Sheets. \u00a1Ve a verlo ahora y sigue avanzando con nosotros!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">WPS Sheets Cap\u00edtulo 4: \u00bfQu\u00e9 Son las Funciones Condicionales?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Las funciones condicionales son f\u00f3rmulas que permiten realizar acciones espec\u00edficas basadas en condiciones predefinidas. Estas funciones son ideales para automatizar tareas repetitivas, como calcular comisiones, aplicar descuentos o filtrar datos seg\u00fan criterios espec\u00edficos. En este cap\u00edtulo, nos enfocaremos en las siguientes funciones:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Funci\u00f3n SI<\/strong>: Eval\u00faa una condici\u00f3n y devuelve un valor si es verdadera y otro si es falsa.<\/li>\n\n\n\n<li><strong>CONTAR.SI<\/strong>: Cuenta el n\u00famero de celdas que cumplen con una condici\u00f3n espec\u00edfica.<\/li>\n\n\n\n<li><strong>SUMAR.SI<\/strong>: Suma los valores de un rango que cumplen con una condici\u00f3n determinada.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-wps-sheets-capitulo-4-funciones-condicionales-guia-practica\">WPS Sheets Cap\u00edtulo 4: funciones condicionales: Gu\u00eda Pr\u00e1ctica<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">En este cap\u00edtulo de WPS Office, se explican las <strong>funciones l\u00f3gicas y condicionales<\/strong>, con un enfoque especial en la funci\u00f3n <strong>SI<\/strong> y otras herramientas esenciales para trabajar con datos en hojas de c\u00e1lculo.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">1. <strong>WPS Sheets Cap\u00edtulo 4: Funci\u00f3n SI y el an\u00e1lisis condicional<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"c9d7e1\" data-has-transparency=\"true\" style=\"--dominant-color: #c9d7e1;\" fetchpriority=\"high\" decoding=\"async\" width=\"603\" height=\"207\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-45.png\" alt=\"Uso de la funci\u00f3n SI en WPS Sheets\/Excel para calcular comisiones basadas en las ventas totales.\" class=\"wp-image-24306 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-45.png 603w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-45-300x103.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-45-600x206.avif 600w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">La funci\u00f3n <strong>SI<\/strong> permite evaluar una condici\u00f3n y devolver un resultado en funci\u00f3n de si esta es <strong>verdadera o falsa<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ejemplo pr\u00e1ctico:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si un vendedor tiene ventas superiores a 5 millones, su comisi\u00f3n ser\u00e1 del 10%; de lo contrario, ser\u00e1 del 5%.<\/li>\n\n\n\n<li>La sintaxis b\u00e1sica es:<code>=SI(B5&gt;5000000, 10%, 5%)<\/code><\/li>\n\n\n\n<li>Se pueden usar operadores como <code>&gt;<\/code>, <code>&lt;<\/code>, <code>&gt;=<\/code>, <code>&lt;=<\/code>, <code>&lt;&gt;<\/code> (diferente a).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">2. <strong>WPS Sheets Cap\u00edtulo 4: Uso de la funci\u00f3n SI con texto<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"d3dfe6\" data-has-transparency=\"true\" style=\"--dominant-color: #d3dfe6;\" decoding=\"async\" width=\"446\" height=\"167\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-46-png.avif\" alt=\" Uso de la funci\u00f3n SI en WPS Sheets\/Excel para aplicar un descuento basado en el m\u00e9todo de pago (texto &quot;contado&quot;).\" class=\"wp-image-24308 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-46-png.avif 446w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-46-300x112.avif 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Si un cliente paga en \u00abcontado\u00bb, se aplica un <strong>5% de descuento<\/strong>. En este caso, se debe comparar el texto usando comillas:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SI(H4=\"contado\", subtotal*5%, 0)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f <strong>Importante<\/strong>: La comparaci\u00f3n debe ser exacta (ejemplo: \u00abContado\u00bb \u2260 \u00abcontado\u00bb).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3. <strong>WPS Sheets Cap\u00edtulo 4: Funciones condicionales avanzadas<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Adem\u00e1s de la funci\u00f3n <strong>SI<\/strong>, existen otras funciones condicionales que permiten realizar c\u00e1lculos m\u00e1s espec\u00edficos:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>CONTAR.SI<\/strong>: Cuenta los elementos que cumplen una condici\u00f3n.<code>=CONTAR.SI (A2:A10, \"M\")<\/code> (Ejemplo: contar empleados masculinos).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e2e4e7\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"359\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-47-1024x359.avif\" alt=\"Uso de la funci\u00f3n CONTAR.SI en WPS Sheets\/Excel para contar empleados hombres (criterio &quot;M&quot;).\" class=\"wp-image-24309 has-transparency\" style=\"--dominant-color: #e2e4e7; width:711px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-47-1024x359.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-47-300x105.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-47-768x269.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-47-600x210.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-47-png.avif 1371w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PROMEDIO.SI<\/strong>: Calcula el promedio de un grupo de datos seg\u00fan una condici\u00f3n.<code>=PROMEDIO.SI (B2:B10, \"Ingenier\u00eda\", C2:C10) <\/code>(Ejemplo: sueldo promedio de ingenieros).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e3e3e7\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"322\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-48-1024x322.avif\" alt=\"Uso de la funci\u00f3n PROMEDIO.SI en WPS Sheets\/Excel para calcular el promedio de sueldos de un departamento espec\u00edfico (Ingenier\u00eda).\" class=\"wp-image-24310 has-transparency\" style=\"--dominant-color: #e3e3e7; width:711px\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-48-1024x322.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-48-300x94.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-48-768x241.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-48-600x189.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-48-png.avif 1530w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><b>SI<\/b><strong>. ERROR<\/strong>: Permite manejar errores en funciones. <code>=SI.ERROR(A2\/B2, \"Error en divisi\u00f3n\")<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e1e3e7\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"345\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-49-1024x345.avif\" alt=\"\" class=\"wp-image-24311 has-transparency\" style=\"--dominant-color: #e1e3e7; width:711px\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-49-1024x345.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-49-300x101.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-49-768x259.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-49-600x202.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-49-png.avif 1429w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MAX.SI<\/strong>: Obtiene el valor m\u00e1ximo seg\u00fan un criterio.<code>=MAX.SI (B2:B10, A2:A10, \"F\") <\/code>(Ejemplo: sueldo m\u00e1ximo entre mujeres).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e1e2e6\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"350\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-50-1024x350.avif\" alt=\" Uso de la funci\u00f3n MAX.SI.CONJUNTO (MAXIFS) en WPS Sheets\/Excel para encontrar el sueldo m\u00e1ximo de las mujeres.\" class=\"wp-image-24312 has-transparency\" style=\"--dominant-color: #e1e2e6; width:711px\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-50-1024x350.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-50-300x102.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-50-768x262.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-50-600x205.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-50-png.avif 1394w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SUMAR.SI<\/strong>: Suma los valores que cumplen con una condici\u00f3n.<code>=SUMAR.SI (A2:A10, \"Ventas\", B2:B10) <\/code>(Ejemplo: total de sueldos del departamento de ventas).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e1e1e4\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"339\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-51-1024x339.avif\" alt=\" Uso de la funci\u00f3n SUMAR.SI en WPS Sheets\/Excel para sumar los sueldos de los empleados hombres (criterio &quot;M&quot;).\" class=\"wp-image-24313 has-transparency\" style=\"--dominant-color: #e1e1e4; width:711px\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-51-1024x339.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-51-300x99.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-51-768x254.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-51-600x198.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-51-png.avif 1418w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\ude80 Optimiza tu trabajo con<strong><em><a href=\"https:\/\/template.wps.com\/excel\/\" target=\"_blank\" rel=\"noreferrer noopener\"> Plantillas WPS Sheets<\/a><\/em><\/strong>! Si necesitas hojas de c\u00e1lculo \ud83d\udcca listas para usar, dise\u00f1adas para facilitar tareas como presupuestos \ud83d\udcb0, control de gastos o gesti\u00f3n de proyectos \ud83d\udcc5,Las Plantillas WPS Sheets son la mejor opci\u00f3n. Ahorra tiempo y esfuerzo con formatos profesionales y personalizables. \u00a1Descarga una ahora y trabaja de manera m\u00e1s eficiente! \u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Consejos para Usar Funciones Condicionales en WPS Sheets<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Combina Funciones<\/strong>: Puedes combinar funciones condicionales con otras f\u00f3rmulas para crear c\u00e1lculos m\u00e1s complejos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Practica con Ejemplos Reales<\/strong>: Aplica estas funciones en tus propias hojas de c\u00e1lculo para familiarizarte con su uso.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Usa Comillas para Textos<\/strong>: Cuando trabajes con textos, aseg\u00farate de usar comillas para evitar errores.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udce2 <strong>\u00a1Aprende a dominar WPS Sheets con este curso imperdible!<\/strong> Si buscas mejorar tu productividad y dominar hojas de c\u00e1lculo sin complicaciones, el <strong><em><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/curso-wps-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso WPS Sheets<\/a><\/em><\/strong> es justo lo que necesitas. Desde lo b\u00e1sico hasta funciones avanzadas, aprender\u00e1s de forma pr\u00e1ctica y sencilla.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusi\u00f3n<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">En este&nbsp;<strong>WPS Sheets Cap\u00edtulo 4: funciones condicionales<\/strong>, hemos explorado las herramientas m\u00e1s poderosas para automatizar y optimizar tus hojas de c\u00e1lculo. Desde la funci\u00f3n&nbsp;<strong>SI<\/strong>, que te permite tomar decisiones basadas en condiciones, hasta&nbsp;<strong>CONTAR.SI<\/strong>&nbsp;y&nbsp;<strong>SUMAR.SI<\/strong>, que simplifican el conteo y la suma de datos espec\u00edficos, estas funciones son esenciales para cualquier usuario de WPS Sheets. Con pr\u00e1ctica y aplicaci\u00f3n en ejemplos reales, podr\u00e1s dominar estas funciones y ahorrar tiempo en tus tareas diarias. \u00a1No olvides practicar y experimentar con tus propios datos para sacar el m\u00e1ximo provecho de estas herramientas!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\"><strong>Preguntas Frecuentes (FAQ)<\/strong><\/h3>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-3e68e0de 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-130e1b64 \" 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>\u00bfPara qu\u00e9 sirve la funci\u00f3n SI en WPS Sheets?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n SI permite evaluar una condici\u00f3n y devolver un valor si la condici\u00f3n es verdadera y otro si es falsa. Es \u00fatil para aplicar reglas y c\u00e1lculos condicionales en hojas de c\u00e1lculo.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-1188b9ad \" 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 evitar errores al usar la funci\u00f3n SI con texto?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p><br>Para comparar texto en la funci\u00f3n SI, es necesario escribirlo entre comillas. Adem\u00e1s, la comparaci\u00f3n debe ser exacta, ya que \u00abContado\u00bb y \u00abcontado\u00bb son diferentes en Excel y WPS Sheets.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-b8492d8b \" 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 diferencia hay entre CONTAR.SI y SUMAR.SI?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>CONTAR.SI cuenta cu\u00e1ntos elementos cumplen una condici\u00f3n, mientras que SUMAR.SI suma los valores de un rango que cumplen con un criterio espec\u00edfico.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-7b9157b2 \" 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 combinar varias funciones SI en una misma f\u00f3rmula?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Se pueden anidar varias funciones SI usando la sintaxis: excelCopiarEditar<code>=SI(A1&gt;90, \"Excelente\", SI(A1&gt;=60, \"Aprobado\", \"Reprobado\"))<\/code> Esto permite evaluar m\u00faltiples condiciones en una misma celda.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-c876a5bf \" 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 PROMEDIO.SI y MAX.SI?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>PROMEDIO.SI calcula el promedio de un conjunto de datos basado en un criterio, mientras que MAX.SI devuelve el valor m\u00e1ximo dentro de un rango que cumple con una condici\u00f3n espec\u00edfica.<\/p><\/div><\/div><\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!<\/p>\n","protected":false},"author":4,"featured_media":24293,"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":[4151],"tags":[562,225,529],"class_list":["post-24291","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-wps-sheets","tag-curso","tag-excel","tag-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WPS Sheets Cap\u00edtulo 4: funciones condicionales - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!\" \/>\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\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WPS Sheets Cap\u00edtulo 4: funciones condicionales - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-19T17:00:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T07:09:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\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=\"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\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"WPS Sheets Cap\u00edtulo 4: funciones condicionales\",\"datePublished\":\"2025-03-19T17:00:22+00:00\",\"dateModified\":\"2025-04-02T07:09:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/\"},\"wordCount\":853,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-4-1.avif\",\"keywords\":[\"Curso\",\"Excel\",\"Sheets\"],\"articleSection\":[\"Curso WPS Sheets\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/\",\"name\":\"WPS Sheets Cap\u00edtulo 4: funciones condicionales - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-4-1.avif\",\"datePublished\":\"2025-03-19T17:00:22+00:00\",\"dateModified\":\"2025-04-02T07:09:12+00:00\",\"description\":\"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-4-1.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-4-1.avif\",\"width\":1000,\"height\":750},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-4-funciones-condicionales\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WPS Sheets Cap\u00edtulo 4: funciones condicionales\"}]},{\"@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\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WPS Sheets Cap\u00edtulo 4: funciones condicionales - Dostin Hurtado","description":"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!","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\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/","og_locale":"es_ES","og_type":"article","og_title":"WPS Sheets Cap\u00edtulo 4: funciones condicionales - Dostin Hurtado","og_description":"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-03-19T17:00:22+00:00","article_modified_time":"2025-04-02T07:09:12+00:00","og_image":[{"width":1000,"height":750,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.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\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"WPS Sheets Cap\u00edtulo 4: funciones condicionales","datePublished":"2025-03-19T17:00:22+00:00","dateModified":"2025-04-02T07:09:12+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/"},"wordCount":853,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif","keywords":["Curso","Excel","Sheets"],"articleSection":["Curso WPS Sheets"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/","name":"WPS Sheets Cap\u00edtulo 4: funciones condicionales - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif","datePublished":"2025-03-19T17:00:22+00:00","dateModified":"2025-04-02T07:09:12+00:00","description":"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif","width":1000,"height":750},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-4-funciones-condicionales\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"WPS Sheets Cap\u00edtulo 4: funciones condicionales"}]},{"@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\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif",1000,750,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-768x576.avif",768,576,true],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif",1000,750,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif",1000,750,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif",1000,750,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1.avif",1000,750,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-870x570.avif",870,570,true],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-600x750.avif",600,750,true],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-600x600.avif",600,600,true],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-400x400.avif",400,400,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-600x450.avif",600,450,true],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-4-1-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"WPS Sheets Cap\u00edtulo 4: funciones condicionales. Funci\u00f3n SI, CONTAR.SI, SUMAR.SI y m\u00e1s. \u00a1Optimiza tus hojas de c\u00e1lculo!","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/24291","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=24291"}],"version-history":[{"count":7,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/24291\/revisions"}],"predecessor-version":[{"id":24322,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/24291\/revisions\/24322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/24293"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=24291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=24291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=24291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}