{"id":3989,"date":"2013-02-28T09:00:01","date_gmt":"2013-02-28T14:00:01","guid":{"rendered":"https:\/\/www.cavsi.com\/blog\/?p=1618"},"modified":"2013-02-28T09:00:01","modified_gmt":"2013-02-28T14:00:01","slug":"funcion-min-excel","status":"publish","type":"post","link":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/","title":{"rendered":"Funci\u00f3n MIN Excel"},"content":{"rendered":"<p>La funci\u00f3n MIN es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MIN representa las tres primeras letras de la palabra MINIMO y se utiliza para encontrar el n\u00famero m\u00e1s peque\u00f1o, menor o m\u00ednimo en una lista de valores o argumentos.<\/p>\n<p>Sintaxis:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" alt=\"Funcion MIN\" src=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg\" width=\"599\" height=\"125\" \/><\/p>\n<p>Argumentos:<\/p>\n<ul>\n<li>Nro1 Valor requerido.<\/li>\n<li>Nro2,&#8230; NroN son valores opcionales.<\/li>\n<\/ul>\n<p>Los argumentos de la funci\u00f3n MIN pueden ser n\u00fameros, rangos con valores num\u00e9ricos, matrices o referencias de celdas. El m\u00e1ximo n\u00famero de argumentos que se pueden colocar en la funci\u00f3n MIN depende de la versi\u00f3n de Excel que est\u00e9s utilizando. En Excel 2007 se pueden ingresar hasta 255 argumentos.<\/p>\n<p>Si el argumento es una matriz o una referencia, s\u00f3lo se utilizar\u00e1n los n\u00fameros contenidos en la matriz o en la referencia. Se pasar\u00e1n por alto las celdas vac\u00edas, los valores l\u00f3gicos o el texto contenidos en la matriz o en la referencia.<\/p>\n<p>Si el argumento contiene celdas vac\u00edas, valores l\u00f3gicos o de texto, la funci\u00f3n MIN devuelve 0.<\/p>\n<p>Si desea incluir valores l\u00f3gicos o de texto utiliza la funci\u00f3n MINA.<\/p>\n<p>Ejemplos de sintaxis de la funci\u00f3n MIN<\/p>\n<table id=\"tblog\">\n<tbody>\n<tr>\n<td><strong>Tipo de Argumento<\/strong><\/td>\n<td><strong>Ejemplo<\/strong><\/td>\n<td><strong>Explicaci\u00f3n<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Referencia a Celdas<\/td>\n<td>=MIN(A1, B1)<\/td>\n<td>Busca el m\u00ednimo \u00a0 \u00a0de los valores de las celdas desde A1 y B1<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Rangos<\/td>\n<td>=MIN(A1:A10)<\/td>\n<td>Busca el m\u00ednimo \u00a0 \u00a0de los valores de las celdas entre las celdas A1 y A10<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Columnas<\/td>\n<td>=MIN(C:C)<\/td>\n<td>Busca el m\u00ednimo \u00a0 \u00a0de los valores de las celdas de la columna C<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Filas<\/td>\n<td>=MIN(1:1)<\/td>\n<td>Busca el m\u00ednimo \u00a0 \u00a0de los valores de las celdas de la fila 1<\/td>\n<\/tr>\n<tr>\n<td>Numeros<\/td>\n<td>=MIN(100, 200, A1)<\/td>\n<td>Busca el m\u00ednimo \u00a0 \u00a0entre 100, 200 y valor de la celda A1<\/td>\n<\/tr>\n<tr>\n<td>Multiple Columnas\/Filas<\/td>\n<td>=MIN(A1:A10, C1:C10)<\/td>\n<td>Busca el m\u00ednimo \u00a0 \u00a0de los valores de las celdas desde A1 a A10 y desde C1 a C10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Ejemplos de uso de la funci\u00f3n MIN<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" alt=\"Funcion MIN\" src=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-02.jpg\" width=\"569\" height=\"185\" \/><\/p>\n<p><b>Excluir valores de la funci\u00f3n MIN<\/b><\/p>\n<p>Para excluir cierto valor que puede ser irrelevante en el c\u00e1lculo, debes aplicar un argumento condicional. Por ejemplo, para excluir las celdas que contiene ceros, es decir quieres obtener el menor valor mayor a cero, aplica la siguiente f\u00f3rmula:<\/p>\n<p>=MIN(SI(A1:A10&gt;0; A1:A10))<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n MIN es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MIN representa las tres primeras letras de la palabra MINIMO y se utiliza para encontrar el n\u00famero m\u00e1s peque\u00f1o, menor o m\u00ednimo en una lista de valores o argumentos.<\/p>\n<p>Sintaxis:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[185],"tags":[182],"class_list":["post-3989","post","type-post","status-publish","format-standard","hentry","category-formulas-funciones","tag-formulas-funciones-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Funci\u00f3n MIN Excel - CAVSI<\/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:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n MIN Excel - CAVSI\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n MIN es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MIN representa las tres primeras letras de la palabra MINIMO y se utiliza para encontrar el n\u00famero m\u00e1s peque\u00f1o, menor o m\u00ednimo en una lista de valores o argumentos. Sintaxis:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CAVSI\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-28T14:00:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\"},\"headline\":\"Funci\u00f3n MIN Excel\",\"datePublished\":\"2013-02-28T14:00:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\"},\"wordCount\":398,\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg\",\"keywords\":[\"F\u00f3rmulas y Funciones de Excel\"],\"articleSection\":[\"Excel: Formulas y Funciones\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\",\"name\":\"Funci\u00f3n MIN Excel - CAVSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg\",\"datePublished\":\"2013-02-28T14:00:01+00:00\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"name\":\"CAVSI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\",\"name\":\"CAVSI\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"width\":300,\"height\":70,\"caption\":\"CAVSI\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.cavsi.com\/espanol\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n MIN Excel - CAVSI","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:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n MIN Excel - CAVSI","og_description":"La funci\u00f3n MIN es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MIN representa las tres primeras letras de la palabra MINIMO y se utiliza para encontrar el n\u00famero m\u00e1s peque\u00f1o, menor o m\u00ednimo en una lista de valores o argumentos. Sintaxis:","og_url":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/","og_site_name":"CAVSI","article_published_time":"2013-02-28T14:00:01+00:00","og_image":[{"url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#article","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/"},"author":{"name":"admin","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff"},"headline":"Funci\u00f3n MIN Excel","datePublished":"2013-02-28T14:00:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/"},"wordCount":398,"publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg","keywords":["F\u00f3rmulas y Funciones de Excel"],"articleSection":["Excel: Formulas y Funciones"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/","url":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/","name":"Funci\u00f3n MIN Excel - CAVSI","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg","datePublished":"2013-02-28T14:00:01+00:00","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-min-excel\/#primaryimage","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-min-01.jpg"},{"@type":"WebSite","@id":"https:\/\/www.cavsi.com\/espanol\/#website","url":"https:\/\/www.cavsi.com\/espanol\/","name":"CAVSI","description":"","publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.cavsi.com\/espanol\/#organization","name":"CAVSI","url":"https:\/\/www.cavsi.com\/espanol\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","width":300,"height":70,"caption":"CAVSI"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.cavsi.com\/espanol"]}]}},"_links":{"self":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/3989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/comments?post=3989"}],"version-history":[{"count":0,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/3989\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/media?parent=3989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/categories?post=3989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/tags?post=3989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}