{"id":206,"date":"2023-11-11T16:10:09","date_gmt":"2023-11-11T16:10:09","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/"},"modified":"2023-12-25T10:32:51","modified_gmt":"2023-12-25T10:32:51","slug":"mediana-si-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/","title":{"rendered":"Criterios condicionales para usar mediana con if"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-388590671\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Para escribir la f\u00f3rmula MEDIANA SI en Excel, debe usar la funci\u00f3n MEDIANA combinada con la funci\u00f3n SI. Primero debe usar la funci\u00f3n MEDIANA, luego, para crear una condici\u00f3n, debe ingresar la funci\u00f3n SI. En el SI, consulte el rango en el que desea probar la condici\u00f3n. Despu\u00e9s de eso, consulte el rango donde tiene los datos. Al final, ingrese la f\u00f3rmula como una f\u00f3rmula matricial. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79414\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"mediana-con-si\" width=\"536\" height=\"386\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para calcular una mediana con una condici\u00f3n.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula condicional para calcular la MEDIANA SI<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n:<\/p>\n<ol>\n<li> Primero ingrese la funci\u00f3n MEDIANA en una celda.<\/li>\n<li> Despu\u00e9s de eso, ingrese a la funci\u00f3n SI con la MEDIANA.<\/li>\n<li> Ahora en el argumento (prueba_l\u00f3gica) haga referencia al rango A1:A1.<\/li>\n<li> A partir de ah\u00ed, en el mismo argumento, ingrese un operador igual e ingrese \u00abD\u00eda 1\u00bb para usarlo como condici\u00f3n a probar.<\/li>\n<li> Luego en (value_if_true) en IF, consulte el rango B1:B12 donde tiene datos para calcular la MEDIANA.<\/li>\n<li> Al final, ingrese par\u00e9ntesis de cierre para cerrar la funci\u00f3n. Y use <strong>Ctrl + Shift + Enter<\/strong> para obtener el resultado de la f\u00f3rmula. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79415\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-calculer-la-mediane-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"calcular-mediana-si\" width=\"642\" height=\"355\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MEDIAN(IF(A1:A12=\"Day 1\",B1:B12))<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> \u00bfC\u00f3mo funciona esta f\u00f3rmula?<\/h2>\n<p> Para comprender esta f\u00f3rmula, debe comprender que cuando ingresa una f\u00f3rmula en forma de tabla, funciona en todo el rango en lugar de solo en una celda. Debes dividir esta f\u00f3rmula en dos partes para entender esto. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79416\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comprend-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"entender-la-f\u00f3rmula\" width=\"675\" height=\"341\"><\/figure>\n<\/div>\n<p> En <strong><strong><mark class=\"has-inline-color\" style=\"background-color: #eedc82; color: #ed573c;\">la PARTE UNO<\/mark><\/strong><\/strong> , tiene una condici\u00f3n para probar en el rango A1:A12. En este rango tenemos dos valores, D\u00eda 1 y D\u00eda 2, queremos probar las celdas donde tenemos la celda del D\u00eda 1. Como puede ver en el ejemplo anterior, tenemos VERDADERO para todas las celdas donde configuramos el D\u00eda 1 y FALSO para el resto de las celdas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79417\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-conditions-a-tester-en-premiere-partie1.png\" sizes=\"auto, \" srcset=\"\" alt=\"condici\u00f3n-a-probar-en-la-primera-parte\" width=\"671\" height=\"329\"><\/figure>\n<\/div>\n<p> Despu\u00e9s de eso, en el segundo argumento de la funci\u00f3n SI, te has referido al rango B1:B12 donde tenemos los datos para calcular la mediana. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fait-reference-a-la-gamme-dans-la-deuxieme-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"referencia-a-la-escala-en-la-segunda-parte\" width=\"705\" height=\"337\"><\/figure>\n<\/div>\n<p> En <strong><mark class=\"has-inline-color\" style=\"background-color: #eedc82; color: #ed573c;\">la PARTE DOS<\/mark><\/strong> , SI devuelve datos para todos los valores para los que tenemos D\u00cdA 1 en el rango A1:A12, y FALSO para el resto de los valores. Y MEDIAN devuelve la mediana s\u00f3lo para estos valores. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mediane-si.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> Marque IF 0 (cero) y luego en blanco en Excel<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/comprobar-si-existe-un-valor-en-un-rango\/\">Comprobar si existe un valor en un rango en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-y-1\/\">Combina funciones IF y AND en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-o-1\/\">Combina funciones SI y O en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-la-celda-esta-vacia\/\">SI la celda est\u00e1 vac\u00eda (en blanco) usando IF + ES EN BLANCO en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-es-negativo-entonces-cero\/\">SI es negativo, entonces cero (0) en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para escribir la f\u00f3rmula MEDIANA SI en Excel, debe usar la funci\u00f3n MEDIANA combinada con la funci\u00f3n SI. Primero debe usar la funci\u00f3n MEDIANA, luego, para crear una condici\u00f3n, debe ingresar la funci\u00f3n SI. En el SI, consulte el rango en el que desea probar la condici\u00f3n. Despu\u00e9s de eso, consulte el rango donde tiene [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-206","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Criterios condicionales para usar mediana con if<\/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:\/\/exceladvisor.org\/es\/mediana-si-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Criterios condicionales para usar mediana con if\" \/>\n<meta property=\"og:description\" content=\"Para escribir la f\u00f3rmula MEDIANA SI en Excel, debe usar la funci\u00f3n MEDIANA combinada con la funci\u00f3n SI. Primero debe usar la funci\u00f3n MEDIANA, luego, para crear una condici\u00f3n, debe ingresar la funci\u00f3n SI. En el SI, consulte el rango en el que desea probar la condici\u00f3n. Despu\u00e9s de eso, consulte el rango donde tiene [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/\",\"name\":\"Criterios condicionales para usar mediana con if\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\",\"datePublished\":\"2023-11-11T16:10:09+00:00\",\"dateModified\":\"2023-12-25T10:32:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Criterios condicionales para usar mediana con if\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Criterios condicionales para usar mediana con if","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:\/\/exceladvisor.org\/es\/mediana-si-2\/","og_locale":"es_ES","og_type":"article","og_title":"Criterios condicionales para usar mediana con if","og_description":"Para escribir la f\u00f3rmula MEDIANA SI en Excel, debe usar la funci\u00f3n MEDIANA combinada con la funci\u00f3n SI. Primero debe usar la funci\u00f3n MEDIANA, luego, para crear una condici\u00f3n, debe ingresar la funci\u00f3n SI. En el SI, consulte el rango en el que desea probar la condici\u00f3n. Despu\u00e9s de eso, consulte el rango donde tiene [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:51+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/","url":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/","name":"Criterios condicionales para usar mediana con if","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png","datePublished":"2023-11-11T16:10:09+00:00","dateModified":"2023-12-25T10:32:51+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/mediana-si-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/mediana-si-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"Criterios condicionales para usar mediana con if"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=206"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/206\/revisions"}],"predecessor-version":[{"id":1441,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/206\/revisions\/1441"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}