{"id":1616,"date":"2013-02-27T09:00:17","date_gmt":"2013-02-27T14:00:17","guid":{"rendered":"https:\/\/www.cavsi.com\/blog\/?p=1616"},"modified":"2013-02-27T09:00:17","modified_gmt":"2013-02-27T14:00:17","slug":"funcion-max-excel","status":"publish","type":"post","link":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/","title":{"rendered":"Funci\u00f3n MAX Excel"},"content":{"rendered":"<p>La funci\u00f3n MAX es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MAX representa las tres primeras letras de la palabra MAXIMO y se utiliza para encontrar el n\u00famero m\u00e1s grande, mayor o m\u00e1ximo en una lista de valores o argumentos.<\/p>\n<p>Sintaxis:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" alt=\"Funcion MAX\" src=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-01.jpg\" width=\"598\" height=\"123\" \/><\/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 MAX 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 MAX 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 MAX devuelve 0.<\/p>\n<p>Si desea incluir valores l\u00f3gicos o de texto utiliza la funci\u00f3n MAXA.<\/p>\n<p>Ejemplos de sintaxis de la funci\u00f3n MAX<\/p>\n<table id=\"tblog\">\n<tbody>\n<tr>\n<td width=\"150\"><strong>Tipo de Argumento<\/strong><\/td>\n<td width=\"150\"><strong>Ejemplo<\/strong><\/td>\n<td width=\"300\"><strong>Explicaci\u00f3n<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Referencia a Celdas<\/td>\n<td>=MAX(A1, B1)<\/td>\n<td>Busca el m\u00e1ximo de los valores de las celdas desde A1 y B1<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Rangos<\/td>\n<td>=MAX(A1:A10)<\/td>\n<td>Busca el m\u00e1ximo de los valores de las celdas entre las celdas A1 y A10<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Columnas<\/td>\n<td>=MAX(C:C)<\/td>\n<td>Busca el m\u00e1ximo de los valores de las celdas de la columna C<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Filas<\/td>\n<td>=MAX(1:1)<\/td>\n<td>Busca el m\u00e1ximo de los valores de las celdas de la fila 1<\/td>\n<\/tr>\n<tr>\n<td>Numeros<\/td>\n<td>=MAX(100, 200, A1)<\/td>\n<td>Busca el m\u00e1ximo entre 100, 200 y valor de la celda A1<\/td>\n<\/tr>\n<tr>\n<td>Multiple Columnas\/Filas<\/td>\n<td>=MAX(A1:A10, C1:C10)<\/td>\n<td>Busca el m\u00e1ximo de 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 MAX<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" alt=\"Funcion MAX\" src=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-02.jpg\" width=\"571\" height=\"187\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n MAX es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MAX representa las tres primeras letras de la palabra MAXIMO y se utiliza para encontrar el n\u00famero m\u00e1s grande, mayor o m\u00e1ximo 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-1616","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 MAX 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-max-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n MAX Excel - CAVSI\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n MAX es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MAX representa las tres primeras letras de la palabra MAXIMO y se utiliza para encontrar el n\u00famero m\u00e1s grande, mayor o m\u00e1ximo en una lista de valores o argumentos. Sintaxis:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CAVSI\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-27T14:00:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-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-max-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\"},\"headline\":\"Funci\u00f3n MAX Excel\",\"datePublished\":\"2013-02-27T14:00:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/\"},\"wordCount\":342,\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-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-max-excel\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/\",\"name\":\"Funci\u00f3n MAX Excel - CAVSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-01.jpg\",\"datePublished\":\"2013-02-27T14:00:17+00:00\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-01.jpg\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-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 MAX 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-max-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n MAX Excel - CAVSI","og_description":"La funci\u00f3n MAX es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. MAX representa las tres primeras letras de la palabra MAXIMO y se utiliza para encontrar el n\u00famero m\u00e1s grande, mayor o m\u00e1ximo en una lista de valores o argumentos. Sintaxis:","og_url":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/","og_site_name":"CAVSI","article_published_time":"2013-02-27T14:00:17+00:00","og_image":[{"url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-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-max-excel\/#article","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/"},"author":{"name":"admin","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff"},"headline":"Funci\u00f3n MAX Excel","datePublished":"2013-02-27T14:00:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/"},"wordCount":342,"publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-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-max-excel\/","url":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/","name":"Funci\u00f3n MAX Excel - CAVSI","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-01.jpg","datePublished":"2013-02-27T14:00:17+00:00","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-max-excel\/#primaryimage","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-01.jpg","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-max-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\/1616","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=1616"}],"version-history":[{"count":0,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/1616\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/media?parent=1616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/categories?post=1616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/tags?post=1616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}