{"id":4020,"date":"2018-04-26T17:00:30","date_gmt":"2018-04-26T22:00:30","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=4020"},"modified":"2024-11-02T10:20:23","modified_gmt":"2024-11-02T15:20:23","slug":"libre-office-calc-capitulo-3","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/","title":{"rendered":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si"},"content":{"rendered":"\n<div class=\"wp-block-uagb-advanced-heading uagb-block-0eecb036\"><h2 class=\"uagb-heading-text\">Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si<\/h2><\/div>\n\n\n\n<p>La funci\u00f3n \u00abSI\u00bb es fundamental para trabajar con hojas de c\u00e1lculo, ya que permite automatizar respuestas basadas en condiciones espec\u00edficas. En este blog, te ense\u00f1aremos c\u00f3mo configurarla para que tus resultados var\u00eden seg\u00fan los datos ingresados, lo cual es \u00fatil para evaluaciones, c\u00e1lculos de descuentos y m\u00e1s.<\/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=\"Curso LibreOffice Calc, Capitulo 3 - Funci\u00f3n Si\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/kytNB1r5MFg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-b503e38c\"><h2 class=\"uagb-heading-text\">\u00bfQu\u00e9 es la Funci\u00f3n \u00abSI\u00bb y C\u00f3mo se Aplica?<\/h2><\/div>\n\n\n\n<p>La funci\u00f3n \u00abSI\u00bb permite establecer una condici\u00f3n l\u00f3gica que genera un resultado basado en si esta condici\u00f3n se cumple o no. Un ejemplo com\u00fan en el que se usa esta funci\u00f3n es para evaluar notas de estudiantes, determinando si aprueban o reprueban seg\u00fan un puntaje m\u00ednimo.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Establecer una Condici\u00f3n L\u00f3gica<\/strong>: Primero, identifica una pregunta que pueda responderse como verdadero o falso. En nuestro caso, queremos saber si una nota es mayor o igual a 6 para indicar aprobaci\u00f3n.<\/li>\n\n\n\n<li><strong>Configurar Respuestas para Verdadero y Falso<\/strong>: La funci\u00f3n necesita dos respuestas: una si se cumple la condici\u00f3n y otra si no. Por ejemplo:\n<ul class=\"wp-block-list\">\n<li>Si la nota es mayor o igual a 6, el resultado mostrar\u00e1 \u201cAprobado\u201d.<\/li>\n\n\n\n<li>Si es menor, el resultado ser\u00e1 \u201cReprobado\u201d.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Sintaxis de la Funci\u00f3n SI<\/strong>: En LibreOffice Calc, la f\u00f3rmula se estructura como <code>=SI(prueba l\u00f3gica; valor_si_verdadero; valor_si_falso) <\/code>Por ejemplo, para nuestra evaluaci\u00f3n de notas, podr\u00edamos usar <code>=SI(A2>=6; \"Aprobado\"; \"Reprobado\")<\/code>, donde A2 representa la celda con la nota del estudiante.<\/li>\n\n\n\n<li><strong>Ejemplo con Descuentos<\/strong>: La funci\u00f3n tambi\u00e9n se aplica para establecer descuentos. Si el pago es en efectivo, se puede aplicar un 20% de descuento. Usar\u00edamos una prueba l\u00f3gica similar para definir si el descuento se aplica o no, usando la estructura <code>=SI(B2=\"Contado\"; descuento; sin_descuento)<\/code>.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Beneficios de Usar la Funci\u00f3n \u00abSI\u00bb en LibreOffice Calc<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Automatizaci\u00f3n de Resultados<\/strong>: Reduce errores humanos al evitar el ingreso manual de datos repetitivos.<\/li>\n\n\n\n<li><strong>Flexibilidad y Adaptabilidad<\/strong>: Permite ajustar las condiciones seg\u00fan las necesidades del proyecto o la tarea espec\u00edfica.<\/li>\n\n\n\n<li><strong>Ahorro de Tiempo<\/strong>: Ideal para usuarios que manejan grandes vol\u00famenes de datos y necesitan respuestas r\u00e1pidas y precisas.<\/li>\n<\/ul>\n\n\n<h3 style=\"text-align: center;\">\u00a0<\/h3>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR MATERIAL DE APOYO<\/strong><\/h5>\n<h6 style=\"text-align: center;\">Descarga el archivo que vemos en el v\u00eddeo desde los siguientes enlaces<\/h6>\n<p style=\"text-align: center;\"><a href=\"https:\/\/mega.nz\/#!C8gSkCAa!W8vdvjvmvGA8_lYEWWnVqp2Orquncy2Q_6SuDrGlRpo\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-3936 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_mega.png\" alt=\"Descargar desde Mega\" width=\"185\" height=\"47\" \/><\/a>\u00a0<a href=\"http:\/\/www.mediafire.com\/file\/k10m7g3cjma2x8t\/curso_libre_office_calc_capitulo_3.zip\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-3938 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_mediafire.png\" alt=\"Descargar desde MediaFire\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_libre_office_calc\/curso_libre_office_calc_capitulo_3.zip\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-3937 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"Descarga Directa\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<h6 style=\"text-align: center;\"><strong><a href=\"https:\/\/mega.nz\/#!C8gSkCAa!W8vdvjvmvGA8_lYEWWnVqp2Orquncy2Q_6SuDrGlRpo\" target=\"_blank\" rel=\"noopener noreferrer\">Mega<\/a> | <a href=\"http:\/\/www.mediafire.com\/file\/k10m7g3cjma2x8t\/curso_libre_office_calc_capitulo_3.zip\" target=\"_blank\" rel=\"noopener noreferrer\">MediaFire <\/a>| <a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_libre_office_calc\/curso_libre_office_calc_capitulo_3.zip\" target=\"_blank\" rel=\"noopener noreferrer\">Descarga Directa<\/a><\/strong><\/h6>\n<hr \/>\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-65b3b648 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-de57a65a \" 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\">\u00bfEs posible combinar la funci\u00f3n \u00abSI\u00bb con otras funciones en LibreOffice Calc?<\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, la funci\u00f3n \u00abSI\u00bb puede combinarse con otras funciones, como SUMA, PROMEDIO y CONTAR, para crear f\u00f3rmulas m\u00e1s complejas. Por ejemplo, puedes usar \u00abSI\u00bb para definir criterios en una f\u00f3rmula de suma, sumando solo valores que cumplan con ciertas condiciones. Esto es \u00fatil para an\u00e1lisis avanzados en hojas de c\u00e1lculo, como calcular promedios espec\u00edficos o contar valores seg\u00fan distintos criterios.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-852f8f33 \" 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\">\u00bfC\u00f3mo se pueden aplicar m\u00faltiples condiciones en la funci\u00f3n \u00abSI\u00bb?<\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n \u00abSI\u00bb permite el uso de condiciones m\u00faltiples mediante funciones \u00abSI\u00bb anidadas o utilizando combinaciones con funciones como Y o O. Por ejemplo, si deseas comprobar si una nota es aprobatoria y si adem\u00e1s el estudiante cumpli\u00f3 con la asistencia, puedes anidar la funci\u00f3n \u00abSI\u00bb o usar \u201cY\u201d. Esta t\u00e9cnica es \u00fatil en evaluaciones y procesos donde hay varias reglas que deben cumplirse simult\u00e1neamente.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-2d34aa09 \" 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\">\u00bfCu\u00e1les son los errores comunes en la funci\u00f3n \u00abSI\u00bb y c\u00f3mo puedo solucionarlos?<\/span><\/div><div class=\"uagb-faq-content\"><p>Un error frecuente ocurre cuando se olvida colocar entre comillas los valores de texto en la f\u00f3rmula, lo cual puede generar un error. Tambi\u00e9n es importante revisar el uso de comas o punto y coma seg\u00fan el formato regional. Si la f\u00f3rmula muestra un error, aseg\u00farate de que cada argumento est\u00e9 en el orden correcto y de que no falten par\u00e9ntesis de cierre. Practicar esta revisi\u00f3n te permitir\u00e1 evitar errores y optimizar tu flujo de trabajo.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-3f24f5eb \" 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\">\u00bfFunciona la funci\u00f3n \u00abSI\u00bb de LibreOffice Calc de la misma manera en otras plataformas como Excel o Google Sheets?<\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n \u00abSI\u00bb tiene una estructura similar en Excel y Google Sheets, aunque algunas diferencias menores pueden requerir ajustes. LibreOffice Calc utiliza punto y coma para separar argumentos, mientras que Excel a menudo usa comas, dependiendo de la configuraci\u00f3n regional. Adem\u00e1s, aunque la l\u00f3gica b\u00e1sica es la misma, algunas plataformas tienen funciones avanzadas que pueden no estar disponibles en todas las aplicaciones.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-a93f81bf \" 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\">\u00bfEs posible utilizar la funci\u00f3n \u00abSI\u00bb con texto en lugar de n\u00fameros?<\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, la funci\u00f3n \u00abSI\u00bb puede evaluar condiciones basadas en texto. Por ejemplo, puedes crear una f\u00f3rmula que aplique un descuento si el texto en una celda espec\u00edfica es \u00abContado\u00bb. En estos casos, es fundamental que el texto se escriba entre comillas dentro de la f\u00f3rmula. Esto es especialmente \u00fatil en registros de inventario, ventas o evaluaciones de pagos, donde el criterio no es num\u00e9rico sino literal.<\/p><\/div><\/div><\/div>\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-efc5671c\"><h2 class=\"uagb-heading-text\">Conclusi\u00f3n<\/h2><\/div>\n\n\n\n<p>La funci\u00f3n \u00abSI\u00bb en LibreOffice Calc es ideal para automatizar tareas y mejorar la eficiencia en la gesti\u00f3n de datos. Su capacidad de combinarse con otras funciones, manejar m\u00faltiples condiciones y trabajar con texto o n\u00fameros la convierte en una herramienta vers\u00e1til para usuarios de todos los niveles. Familiarizarse con su uso te permitir\u00e1 realizar c\u00e1lculos complejos y mejorar tu productividad en las hojas de c\u00e1lculo. Practica con ejemplos y ver\u00e1s c\u00f3mo optimizas tu flujo de trabajo y obtienes resultados m\u00e1s precisos.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si La funci\u00f3n \u00abSI\u00bb es fundamental para trabajar con hojas de [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4383,"comment_status":"open","ping_status":"open","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":[63],"tags":[134,260,264,267,318,365],"class_list":["post-4020","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-office-calc","tag-calc","tag-funcion-if","tag-funcion-si","tag-funciones-condicionales","tag-libre-office","tag-office"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si - Dostin Hurtado<\/title>\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-office-calc\/libre-office-calc-capitulo-3\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si La funci\u00f3n \u00abSI\u00bb es fundamental para trabajar con hojas de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-26T22:00:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-02T15:20:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\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=\"2 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-office-calc\\\/libre-office-calc-capitulo-3\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si\",\"datePublished\":\"2018-04-26T22:00:30+00:00\",\"dateModified\":\"2024-11-02T15:20:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/\"},\"wordCount\":486,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/calc_3.jpg\",\"keywords\":[\"Calc\",\"funcion if\",\"funcion si\",\"Funciones Condicionales\",\"Libre Office\",\"office\"],\"articleSection\":[\"Curso de Libre Office Calc\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/\",\"name\":\"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/calc_3.jpg\",\"datePublished\":\"2018-04-26T22:00:30+00:00\",\"dateModified\":\"2024-11-02T15:20:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/calc_3.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/calc_3.jpg\",\"width\":500,\"height\":376,\"caption\":\"Curso de Libre Oficce Calc - Cap\u00edtulo 3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-office-calc\\\/libre-office-calc-capitulo-3\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si\"}]},{\"@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=1779717474\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1779717474\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1779717474\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si - Dostin Hurtado","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-office-calc\/libre-office-calc-capitulo-3\/","og_locale":"es_ES","og_type":"article","og_title":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si - Dostin Hurtado","og_description":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si La funci\u00f3n \u00abSI\u00bb es fundamental para trabajar con hojas de [&hellip;]","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-04-26T22:00:30+00:00","article_modified_time":"2024-11-02T15:20:23+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si","datePublished":"2018-04-26T22:00:30+00:00","dateModified":"2024-11-02T15:20:23+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/"},"wordCount":486,"commentCount":1,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg","keywords":["Calc","funcion if","funcion si","Funciones Condicionales","Libre Office","office"],"articleSection":["Curso de Libre Office Calc"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/","name":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg","datePublished":"2018-04-26T22:00:30+00:00","dateModified":"2024-11-02T15:20:23+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg","width":500,"height":376,"caption":"Curso de Libre Oficce Calc - Cap\u00edtulo 3"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-office-calc\/libre-office-calc-capitulo-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si"}]},{"@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=1779717474","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1779717474","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1779717474","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/calc_3-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":1,"uagb_excerpt":"Curso de LibreOffice Calc \u2013 Cap\u00edtulo 3: Funci\u00f3n Condicional Si La funci\u00f3n \u00abSI\u00bb es fundamental para trabajar con hojas de [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4020","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=4020"}],"version-history":[{"count":0,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4020\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/4383"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=4020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=4020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=4020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}