{"id":24070,"date":"2025-03-12T12:00:00","date_gmt":"2025-03-12T17:00:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=24070"},"modified":"2025-04-02T02:09:12","modified_gmt":"2025-04-02T07:09:12","slug":"wps-sheets-capitulo-3-funciones-basicas","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/","title":{"rendered":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-wps-sheets-capitulo-3-funciones-y-condicionales-aprende-a-optimizar-tus-calculos\">WPS Sheets Cap\u00edtulo 3: Funciones y Condicionales &#8211; Aprende a Optimizar tus C\u00e1lculos<\/h1>\n\n\n\n<p>Las funciones son una herramienta clave en cualquier hoja de c\u00e1lculo, ya que nos permiten realizar c\u00e1lculos y an\u00e1lisis de datos de manera eficiente. En este art\u00edculo, aprender\u00e1s las funciones m\u00e1s utilizadas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas y c\u00f3mo aplicarlas correctamente.<\/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=\"Aprende Funciones B\u00e1sicas y Condicionales en WPS Sheet | Curso Completo (Cap. 3)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/A8VrgOsmPLs?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\">\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-d35af0\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-2c0906 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-Sheet-capitulo-3.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\">Diferencia entre Funciones y F\u00f3rmulas en WPS Sheets<\/h2>\n\n\n\n<p>Antes de entrar en detalle con las funciones, es importante diferenciar entre funciones y f\u00f3rmulas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>F\u00f3rmulas<\/strong>: Utilizan operadores matem\u00e1ticos como suma (+), resta (-), multiplicaci\u00f3n (*) y divisi\u00f3n (\/).<\/li>\n\n\n\n<li><strong>Funciones<\/strong>: Ejecutan operaciones m\u00e1s complejas, como encontrar un promedio, calcular la fecha actual o determinar el valor m\u00e1ximo en un conjunto de datos.<\/li>\n<\/ul>\n\n\n\n<p>\u00bfQuieres ahorrar tiempo y mejorar la presentaci\u00f3n de tus hojas de c\u00e1lculo? \ud83d\udcca\u2728 Las <strong><em><a href=\"https:\/\/template.wps.com\/excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">Plantillas de WPS Sheets<\/a><\/em><\/strong> son la soluci\u00f3n perfecta. Con dise\u00f1os profesionales y personalizables, te permiten organizar datos de forma eficiente sin empezar desde cero. \u00a1No pierdas horas formateando! \u23f3\ud83d\ude80 Descarga ahora una plantilla y optimiza tu trabajo al m\u00e1ximo. \u2705\ud83d\udd25<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Funciones B\u00e1sicas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-funcion-hoy-en-wps-sheets\">Funci\u00f3n HOY () en WPS Sheets<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"dbe1df\" data-has-transparency=\"true\" style=\"--dominant-color: #dbe1df;\" decoding=\"async\" width=\"207\" height=\"25\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-29.png\" alt=\"Funci\u00f3n HOY() en WPS Sheets mostrando la fecha actual 3\/11\/2025.\" class=\"wp-image-24072 has-transparency\"\/><\/figure>\n\n\n\n<p>La funci\u00f3n H<strong>OY ()<\/strong> se usa para obtener la fecha actual del sistema sin necesidad de par\u00e1metros. Solo necesitas escribir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=HOY ()<\/code><\/pre>\n\n\n\n<p>Esta funci\u00f3n se actualiza autom\u00e1ticamente cada d\u00eda.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-funcion-ahora-en-wps-sheets\">Funci\u00f3n AHORA () en WPS Sheets<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"dce3e1\" data-has-transparency=\"true\" style=\"--dominant-color: #dce3e1;\" decoding=\"async\" width=\"252\" height=\"33\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-30.png\" alt=\"Funci\u00f3n AHORA() en WPS Sheets mostrando fecha y hora actual: 3\/11\/2025 8:59.\" class=\"wp-image-24073 has-transparency\"\/><\/figure>\n\n\n\n<p>Si adem\u00e1s de la fecha quieres obtener la hora actual, usa la funci\u00f3n AHO<strong>RA ()<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=AHORA ()<\/code><\/pre>\n\n\n\n<p>Si el resultado muestra solo n\u00fameros, ajusta el formato de la celda para mostrar fecha y hora correctamente.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-funciones-matematicas-esenciales-en-wps-sheets-capitulo-3-funciones-basicas\">Funciones Matem\u00e1ticas Esenciales en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SUMA en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e5e8ec\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"524\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-31-1024x524.avif\" alt=\"Funci\u00f3n SUMA en WPS Sheets para totalizar ventas en hoja de c\u00e1lculo.\" class=\"wp-image-24076 has-transparency\" style=\"--dominant-color: #e5e8ec; width:598px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-31-1024x524.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-31-300x153.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-31-768x393.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-31-600x307.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-31-png.avif 1032w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Para obtener la suma de un rango de celdas, utiliza la funci\u00f3n SU<strong>MA ()<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUMA (A1:A10)<\/code><\/pre>\n\n\n\n<p>Esto es m\u00e1s eficiente que escribir manualmente cada celda a sumar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">PROMEDIO en WPS Sheets<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e6e8ec\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"509\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-32-1024x509.avif\" alt=\"Funci\u00f3n PROMEDIO en WPS Sheets para calcular el promedio de ventas.\" class=\"wp-image-24077 has-transparency\" style=\"--dominant-color: #e6e8ec; width:610px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-32-1024x509.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-32-300x149.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-32-768x382.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-32-600x298.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-32-png.avif 1062w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Para calcular el promedio de un conjunto de valores, usa:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=PROMEDIO (A1:A10)<\/code><\/pre>\n\n\n\n<p>Esta funci\u00f3n simplifica el c\u00e1lculo sin necesidad de dividir manualmente la suma entre el n\u00famero de elementos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-funciones-estadisticas-en-wps-sheets-capitulo-3-funciones-basicas\">Funciones Estad\u00edsticas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00c1XIMO Y M\u00cdNIMO<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"e3e6ea\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1006\" height=\"525\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-34-png.avif\" alt=\"Funci\u00f3n M\u00cdNIMO en WPS Sheets para encontrar el valor m\u00ednimo de ventas.\" class=\"wp-image-24079 has-transparency\" style=\"--dominant-color: #e3e6ea; width:565px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-34-png.avif 1006w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-34-300x157.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-34-768x401.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-34-600x313.avif 600w\" sizes=\"(max-width: 1006px) 100vw, 1006px\" \/><\/figure>\n\n\n\n<p>Para encontrar el valor m\u00e1s alto en un conjunto de datos:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MAX (A1:A10)<\/code><\/pre>\n\n\n\n<p>Para hallar el valor m\u00e1s bajo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MIN (A1:A10)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">MODA en WPS Sheets<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"e4e6eb\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1019\" height=\"522\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-35-png.avif\" alt=\"Funci\u00f3n MODA en WPS Sheets para encontrar el valor m\u00e1s frecuente en ventas.\" class=\"wp-image-24080 has-transparency\" style=\"--dominant-color: #e4e6eb; width:605px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-35-png.avif 1019w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-35-300x154.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-35-768x393.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-35-600x307.avif 600w\" sizes=\"(max-width: 1019px) 100vw, 1019px\" \/><\/figure>\n\n\n\n<p>Si necesitas encontrar el n\u00famero que m\u00e1s se repite en un rango:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=MODA (A1:A10)<\/code><\/pre>\n\n\n\n<p>Si no hay valores repetidos, la funci\u00f3n arrojar\u00e1 un error.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Funciones de Conteo en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">CONTARA en WPS Sheets<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e3e6eb\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"509\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-36-1024x509.avif\" alt=\"Funci\u00f3n CONTARA en WPS Sheets para contar productos en hoja de c\u00e1lculo.\" class=\"wp-image-24081 has-transparency\" style=\"--dominant-color: #e3e6eb; width:662px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-36-1024x509.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-36-300x149.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-36-768x382.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-36-600x298.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/image-36-png.avif 1048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Para contar el n\u00famero de celdas que contienen datos en un rango:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=CONTARA (A1:A10)<\/code><\/pre>\n\n\n\n<p>Si eliminas un dato, la funci\u00f3n se actualizar\u00e1 autom\u00e1ticamente.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Manejo de Errores con Funciones Condicionales en WPS Sheets<\/h2>\n\n\n\n<p>Algunas funciones pueden generar errores cuando no hay datos en las celdas. Para evitar estos errores, podemos usar <strong>SI. ERROR().<\/strong><\/p>\n\n\n\n<p>Ejemplo con la funci\u00f3n MODA:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SI.ERROR(MODA (A1:A10), \"No hay datos repetidos\")<\/code><\/pre>\n\n\n\n<p>Si no hay valores repetidos, en lugar de un error, aparecer\u00e1 el mensaje \u00abNo hay datos repetidos\u00bb.<\/p>\n\n\n\n<p>Ejemplo con la funci\u00f3n PROMEDIO:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SI.ERROR(PROMEDIO (A1:A10), \"No hay datos\")<\/code><\/pre>\n\n\n\n<p>Si todas las celdas est\u00e1n vac\u00edas, en vez de un error de divisi\u00f3n por cero, se mostrar\u00e1 \u00abNo hay datos\u00bb.<\/p>\n\n\n\n<p>Quieres dominar <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/curso-wps-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso WPS Sheets<\/a><\/strong> y mejorar tu productividad? \ud83d\ude80\ud83d\udcca Con este curso aprender\u00e1s a usar funciones avanzadas, crear tablas din\u00e1micas y optimizar tus hojas de c\u00e1lculo como un profesional. \u00a1Deja de perder tiempo con f\u00f3rmulas complicadas! \u23f3\u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Aprender a utilizar funciones en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas te permitir\u00e1 trabajar de manera m\u00e1s eficiente con hojas de c\u00e1lculo. Desde c\u00e1lculos b\u00e1sicos hasta manejo de errores, estas herramientas te ahorrar\u00e1n tiempo y mejorar\u00e1n la precisi\u00f3n de tus an\u00e1lisis de datos.<\/p>\n\n\n\n<p>Si tienes dudas o quieres aprender sobre una funci\u00f3n espec\u00edfica, d\u00e9jalo en los comentarios. \u00a1Nos vemos en el pr\u00f3ximo cap\u00edtulo!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-321e69e1 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-3e3ebfec \" 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\">1. \u00bfLas funciones en WPS Sheets son iguales a las de Excel?<\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, las funciones en WPS Sheet son pr\u00e1cticamente id\u00e9nticas a las de Excel.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-2e9938ea \" 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\">2. \u00bfC\u00f3mo soluciono el error \u00ab#DIV\/0!\u00bb en WPS Sheets?<\/span><\/div><div class=\"uagb-faq-content\"><p>Este error ocurre cuando intentas dividir por cero. Usa <strong>SI.ERROR()<\/strong> para evitarlo.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-cbe4b1b6 \" 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\">3. \u00bfSe actualizan las funciones de fecha autom\u00e1ticamente en WPS Sheets?<\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, tanto HOY<strong> ()<\/strong> como AHO<strong>RA ()<\/strong> se actualizan cada vez que abres la hoja de c\u00e1lculo.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-74d48d7b \" 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\">4. \u00bfQu\u00e9 funci\u00f3n debo usar para contar celdas vac\u00edas en WPS Sheets?<\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes usar la funci\u00f3n <strong>CONTAR.BLANCO()<\/strong>:<br><code>=CONTAR.BLANCO(A1:A10)<\/code><\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-2d55b16a \" 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\">5. \u00bfC\u00f3mo aplicar funciones condicionales en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas?<\/span><\/div><div class=\"uagb-faq-content\"><p>Las funciones condicionales como S<strong>I ()<\/strong> permiten tomar decisiones seg\u00fan ciertos criterios. Lo veremos en el pr\u00f3ximo cap\u00edtulo.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Aprende en WPS Sheets Cap\u00edtulo 3: Funciones y Condicionales c\u00f3mo aplicar estas herramientas para optimizar c\u00e1lculos y an\u00e1lisis de datos.<\/p>\n","protected":false},"author":4,"featured_media":24071,"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,568,277,529],"class_list":["post-24070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-wps-sheets","tag-curso","tag-funciones-basicas","tag-gratis","tag-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas c\u00f3mo utilizar sumas, promedios y m\u00e1s para optimizar tus hojas de c\u00e1lculo f\u00e1cilmente.\" \/>\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-3-funciones-basicas\/\" \/>\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 3: Funciones b\u00e1sicas para ti\" \/>\n<meta property=\"og:description\" content=\"Aprende a utilizar las funciones m\u00e1s efectivas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas y optimiza tus tareas diarias.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-12T17:00:00+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-3.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:title\" content=\"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas para principiantes\" \/>\n<meta name=\"twitter:description\" content=\"Aprende las funciones m\u00e1s utilizadas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas. Mejora tus c\u00e1lculos y an\u00e1lisis hoy mismo.\" \/>\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=\"5 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-3-funciones-basicas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas\",\"datePublished\":\"2025-03-12T17:00:00+00:00\",\"dateModified\":\"2025-04-02T07:09:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/\"},\"wordCount\":706,\"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-3-funciones-basicas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-3.avif\",\"keywords\":[\"Curso\",\"Funciones b\u00e1sicas\",\"Gratis\",\"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-3-funciones-basicas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/\",\"name\":\"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-3.avif\",\"datePublished\":\"2025-03-12T17:00:00+00:00\",\"dateModified\":\"2025-04-02T07:09:12+00:00\",\"description\":\"Aprende en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas c\u00f3mo utilizar sumas, promedios y m\u00e1s para optimizar tus hojas de c\u00e1lculo f\u00e1cilmente.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-3.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/WPS-curso-capitulo-3.avif\",\"width\":1000,\"height\":750},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-wps-sheets\\\/wps-sheets-capitulo-3-funciones-basicas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas\"}]},{\"@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=1782136890\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1782136890\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1782136890\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas - Dostin Hurtado","description":"Aprende en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas c\u00f3mo utilizar sumas, promedios y m\u00e1s para optimizar tus hojas de c\u00e1lculo f\u00e1cilmente.","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-3-funciones-basicas\/","og_locale":"es_ES","og_type":"article","og_title":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas para ti","og_description":"Aprende a utilizar las funciones m\u00e1s efectivas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas y optimiza tus tareas diarias.","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-03-12T17:00:00+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-3.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas para principiantes","twitter_description":"Aprende las funciones m\u00e1s utilizadas en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas. Mejora tus c\u00e1lculos y an\u00e1lisis hoy mismo.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas","datePublished":"2025-03-12T17:00:00+00:00","dateModified":"2025-04-02T07:09:12+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/"},"wordCount":706,"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-3-funciones-basicas\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif","keywords":["Curso","Funciones b\u00e1sicas","Gratis","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-3-funciones-basicas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/","name":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif","datePublished":"2025-03-12T17:00:00+00:00","dateModified":"2025-04-02T07:09:12+00:00","description":"Aprende en WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas c\u00f3mo utilizar sumas, promedios y m\u00e1s para optimizar tus hojas de c\u00e1lculo f\u00e1cilmente.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif","width":1000,"height":750},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-wps-sheets\/wps-sheets-capitulo-3-funciones-basicas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"WPS Sheets Cap\u00edtulo 3: Funciones b\u00e1sicas"}]},{"@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=1782136890","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1782136890","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1782136890","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-3.avif",1000,750,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-768x576.avif",768,576,true],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif",1000,750,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif",1000,750,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif",1000,750,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3.avif",1000,750,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-870x570.avif",870,570,true],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-600x750.avif",600,750,true],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-600x600.avif",600,600,true],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-400x400.avif",400,400,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-600x450.avif",600,450,true],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/03\/WPS-curso-capitulo-3-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":"Aprende en WPS Sheets Cap\u00edtulo 3: Funciones y Condicionales c\u00f3mo aplicar estas herramientas para optimizar c\u00e1lculos y an\u00e1lisis de datos.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/24070","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=24070"}],"version-history":[{"count":7,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/24070\/revisions"}],"predecessor-version":[{"id":24315,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/24070\/revisions\/24315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/24071"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=24070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=24070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=24070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}