{"id":510,"date":"2025-01-11T16:23:47","date_gmt":"2025-01-11T16:23:47","guid":{"rendered":"https:\/\/eipnet.net\/?p=510"},"modified":"2025-01-11T16:48:44","modified_gmt":"2025-01-11T16:48:44","slug":"libreoffice-calc-condicional","status":"publish","type":"post","link":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/","title":{"rendered":"LibreOffice Calc &#8211; Condicional"},"content":{"rendered":"\n<p>Est\u00e1 el primero, que se suele poner al final. O solo<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=CONTAR.SI($D$2:$D$501; \">=6\")<\/code><\/pre>\n\n\n\n<p>Y esta el doble, que es con el que empiezas, cuando se quiere buscar en un rango de valores (celdas) una salida concreta m\u00e1s peque\u00f1a.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=CONTAR.SI.CONJUNTO($D$2:$D$501; \">=0\"; $D$2:$D$501; \"&lt;1\")<\/code><\/pre>\n\n\n\n<p>En el siguiente ejemplo, se mira en un rango de 500 valores. Se pone lo que se busca, el resultado y la f\u00f3rmula en el primero y el \u00faltimo. Los de en medio son casi id\u00e9nticos al primero, casi.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img  title=\"\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"123\" src=\"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png\"  alt=\"image-2 LibreOffice Calc - Condicional\"  class=\"wp-image-512\" srcset=\"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png 640w, https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2-300x58.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Est\u00e1 el primero, que se suele poner al final. O solo Y esta el doble, que es con el que empiezas, cuando se quiere buscar en un rango de valores (celdas) una salida concreta m\u00e1s peque\u00f1a. En el siguiente ejemplo, se mira en un rango de 500 valores. Se pone lo que se busca, el [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":512,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96],"tags":[98,100,99,97],"class_list":["post-510","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ofimatica","tag-calc","tag-condicionales","tag-formulas","tag-libreoffice"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LibreOffice Calc - Condicional - Tentenpie digital<\/title>\n<meta name=\"description\" content=\"Aplicar condicionales en LibreOffice Calc para saber en un rango de valores si hay dos valores determinados\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LibreOffice Calc - Condicional - Tentenpie digital\" \/>\n<meta property=\"og:description\" content=\"Aplicar condicionales en LibreOffice Calc para saber en un rango de valores si hay dos valores determinados\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/\" \/>\n<meta property=\"og:site_name\" content=\"Tentenpie digital\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-11T16:23:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-11T16:48:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"123\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"FranVal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"FranVal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/\"},\"author\":{\"name\":\"FranVal\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/#\\\/schema\\\/person\\\/e576543b89789e8d5aa564db3fea2bb4\"},\"headline\":\"LibreOffice Calc &#8211; Condicional\",\"datePublished\":\"2025-01-11T16:23:47+00:00\",\"dateModified\":\"2025-01-11T16:48:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/\"},\"wordCount\":82,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/eipnet.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/image-2.png\",\"keywords\":[\"Calc\",\"Condicionales\",\"F\u00f3rmulas\",\"LibreOffice\"],\"articleSection\":[\"Ofim\u00e1tica\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/\",\"url\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/\",\"name\":\"LibreOffice Calc - Condicional - Tentenpie digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/eipnet.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/image-2.png\",\"datePublished\":\"2025-01-11T16:23:47+00:00\",\"dateModified\":\"2025-01-11T16:48:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/#\\\/schema\\\/person\\\/e576543b89789e8d5aa564db3fea2bb4\"},\"description\":\"Aplicar condicionales en LibreOffice Calc para saber en un rango de valores si hay dos valores determinados\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#primaryimage\",\"url\":\"https:\\\/\\\/eipnet.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/image-2.png\",\"contentUrl\":\"https:\\\/\\\/eipnet.net\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/image-2.png\",\"width\":640,\"height\":123},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/2025\\\/01\\\/11\\\/libreoffice-calc-condicional\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/eipnet.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"LibreOffice Calc &#8211; Condicional\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/#website\",\"url\":\"https:\\\/\\\/eipnet.net\\\/\",\"name\":\"Tentenpie digital\",\"description\":\"Tapillas de unos y... de ceros\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/eipnet.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eipnet.net\\\/#\\\/schema\\\/person\\\/e576543b89789e8d5aa564db3fea2bb4\",\"name\":\"FranVal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e476950eea7d0564025f79cd217e6c3105fac8bb6b68a0f01a5116c964eb4da?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e476950eea7d0564025f79cd217e6c3105fac8bb6b68a0f01a5116c964eb4da?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e476950eea7d0564025f79cd217e6c3105fac8bb6b68a0f01a5116c964eb4da?s=96&d=mm&r=g\",\"caption\":\"FranVal\"},\"sameAs\":[\"https:\\\/\\\/eipnet.net\\\/\"],\"url\":\"https:\\\/\\\/eipnet.net\\\/index.php\\\/author\\\/franval\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LibreOffice Calc - Condicional - Tentenpie digital","description":"Aplicar condicionales en LibreOffice Calc para saber en un rango de valores si hay dos valores determinados","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:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/","og_locale":"es_ES","og_type":"article","og_title":"LibreOffice Calc - Condicional - Tentenpie digital","og_description":"Aplicar condicionales en LibreOffice Calc para saber en un rango de valores si hay dos valores determinados","og_url":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/","og_site_name":"Tentenpie digital","article_published_time":"2025-01-11T16:23:47+00:00","article_modified_time":"2025-01-11T16:48:44+00:00","og_image":[{"width":640,"height":123,"url":"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png","type":"image\/png"}],"author":"FranVal","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"FranVal","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#article","isPartOf":{"@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/"},"author":{"name":"FranVal","@id":"https:\/\/eipnet.net\/#\/schema\/person\/e576543b89789e8d5aa564db3fea2bb4"},"headline":"LibreOffice Calc &#8211; Condicional","datePublished":"2025-01-11T16:23:47+00:00","dateModified":"2025-01-11T16:48:44+00:00","mainEntityOfPage":{"@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/"},"wordCount":82,"commentCount":0,"image":{"@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#primaryimage"},"thumbnailUrl":"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png","keywords":["Calc","Condicionales","F\u00f3rmulas","LibreOffice"],"articleSection":["Ofim\u00e1tica"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/","url":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/","name":"LibreOffice Calc - Condicional - Tentenpie digital","isPartOf":{"@id":"https:\/\/eipnet.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#primaryimage"},"image":{"@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#primaryimage"},"thumbnailUrl":"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png","datePublished":"2025-01-11T16:23:47+00:00","dateModified":"2025-01-11T16:48:44+00:00","author":{"@id":"https:\/\/eipnet.net\/#\/schema\/person\/e576543b89789e8d5aa564db3fea2bb4"},"description":"Aplicar condicionales en LibreOffice Calc para saber en un rango de valores si hay dos valores determinados","breadcrumb":{"@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#primaryimage","url":"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png","contentUrl":"https:\/\/eipnet.net\/wp-content\/uploads\/2025\/01\/image-2.png","width":640,"height":123},{"@type":"BreadcrumbList","@id":"https:\/\/eipnet.net\/index.php\/2025\/01\/11\/libreoffice-calc-condicional\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/eipnet.net\/"},{"@type":"ListItem","position":2,"name":"LibreOffice Calc &#8211; Condicional"}]},{"@type":"WebSite","@id":"https:\/\/eipnet.net\/#website","url":"https:\/\/eipnet.net\/","name":"Tentenpie digital","description":"Tapillas de unos y... de ceros","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eipnet.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/eipnet.net\/#\/schema\/person\/e576543b89789e8d5aa564db3fea2bb4","name":"FranVal","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/7e476950eea7d0564025f79cd217e6c3105fac8bb6b68a0f01a5116c964eb4da?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e476950eea7d0564025f79cd217e6c3105fac8bb6b68a0f01a5116c964eb4da?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e476950eea7d0564025f79cd217e6c3105fac8bb6b68a0f01a5116c964eb4da?s=96&d=mm&r=g","caption":"FranVal"},"sameAs":["https:\/\/eipnet.net\/"],"url":"https:\/\/eipnet.net\/index.php\/author\/franval\/"}]}},"_links":{"self":[{"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/posts\/510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/comments?post=510"}],"version-history":[{"count":2,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/posts\/510\/revisions"}],"predecessor-version":[{"id":514,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/posts\/510\/revisions\/514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/media\/512"}],"wp:attachment":[{"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/media?parent=510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/categories?post=510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eipnet.net\/index.php\/wp-json\/wp\/v2\/tags?post=510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}