{"id":13930,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/bdmax\/"},"modified":"2021-02-26T08:45:43","modified_gmt":"2021-02-26T08:45:43","slug":"dmax","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/dmax\/","title":{"rendered":"BDMAX"},"content":{"rendered":"

La funci\u00f3n DMAX, tambi\u00e9n referida como BDMAX en ciertas versiones de Microsoft Excel, es una herramienta esencial para encontrar el valor m\u00e1ximo en un campo espec\u00edfico de un conjunto de registros que satisfacen determinados criterios. Esta funci\u00f3n es de gran utilidad para el an\u00e1lisis de datos, permitiendo filtrar y examinar grandes cantidades de informaci\u00f3n de manera eficiente.<\/p>\n

Sintaxis y ejemplos pr\u00e1cticos<\/h2>\n

La sintaxis de DMAX se describe de la siguiente manera:<\/p>\n

DMAX(base_de_datos, campo, criterios)<\/code><\/pre>\n
    \n
  • base_de_datos<\/strong>: Es el rango de celdas que act\u00faa como la base de datos. Debe incluir las etiquetas de columnas en la primera fila.<\/li>\n
  • campo<\/strong>: Corresponde al campo del cual se desea obtener el valor m\u00e1ximo. Puede especificarse mediante el n\u00famero de \u00edndice de la columna o el nombre de la columna entre comillas.<\/li>\n
  • criterios<\/strong>: Es el rango de celdas que contienen los criterios que los registros deben cumplir. Este rango debe incluir al menos una etiqueta de columna que coincida con una en la base_de_datos en su primera fila.<\/li>\n<\/ul>\n
    Ejemplo de uso en un caso real<\/h2>\n
    Supongamos que dispones de una base de datos de empleados con la estructura siguiente:<\/p>\n\n\n\n\n\n\n
    Empleado<\/td>\nDepartamento<\/td>\nSalario<\/td>\n<\/tr>\n
    Juan P\u00e9rez<\/td>\nMarketing<\/td>\n3000<\/td>\n<\/tr>\n
    Lucia G\u00f3mez<\/td>\nVentas<\/td>\n3850<\/td>\n<\/tr>\n
    Mario Bros<\/td>\nTI<\/td>\n4500<\/td>\n<\/tr>\n
    Anna Kowalsky<\/td>\nMarketing<\/td>\n3200<\/td>\n<\/tr>\n<\/table>\n
    Para encontrar el salario m\u00e1s alto en el departamento de Marketing, puedes emplear la funci\u00f3n DMAX de la siguiente manera:<\/p>\n
    =DMAX(A1:C5, \"Salario\", A7:B8)<\/code><\/pre>\n
    El rango de criterios (A7:B8) deber\u00eda configurarse as\u00ed:<\/p>\n\n\n\n
    Departamento<\/td>\n<\/td>\n<\/tr>\n
    Marketing<\/td>\n<\/td>\n<\/tr>\n<\/table>\n
    Esta funci\u00f3n retornar\u00e1 3200<\/code>, el cual es el salario m\u00e1s alto dentro del departamento de Marketing.<\/p>\n
    Otro escenario de aplicaci\u00f3n<\/h2>\n
    Si gestionas una base de datos de productos y sus ventas, podr\u00edas querer identificar el precio m\u00e1s alto de un producto que se ha vendido m\u00e1s de 100 unidades. La base de datos podr\u00eda tener este aspecto:<\/p>\n\n\n\n\n\n
    Producto<\/td>\nPrecio<\/td>\nUnidades Vendidas<\/td>\n<\/tr>\n
    Laptop XYZ<\/td>\n1200<\/td>\n150<\/td>\n<\/tr>\n
    M\u00f3vil ABC<\/td>\n800<\/td>\n200<\/td>\n<\/tr>\n
    Tablet DEF<\/td>\n600<\/td>\n90<\/td>\n<\/tr>\n<\/table>\n
    Para este prop\u00f3sito, configura DMAX de la siguiente manera:<\/p>\n
    =DMAX(A1:C4, \"Precio\", A6:C7)<\/code><\/pre>\n
    El rango de criterios se establecer\u00eda as\u00ed:<\/p>\n\n\n\n
    Unidades Vendidas<\/td>\n<\/td>\n<\/tr>\n
    >100<\/td>\n<\/td>\n<\/tr>\n<\/table>\n
    Este criterio filtra los productos con m\u00e1s de 100 unidades vendidas y la funci\u00f3n identificar\u00e1 el m\u00e1ximo precio entre ellos, que en este caso es 1200<\/code> para el Laptop XYZ.<\/p>\n
    As\u00ed, utilizando DMAX, puedes simplificar de manera significativa la tarea de encontrar valores m\u00e1ximos bajo condiciones espec\u00edficas, lo que resulta extremadamente \u00fatil en el an\u00e1lisis y la generaci\u00f3n de informes de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el valor m\u00e1ximo de las entradas seleccionadas de la base de datos<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[547],"tags":[],"class_list":["post-13930","post","type-post","status-publish","format-standard","hentry","category-base-de-datos"],"acf":[],"yoast_head":"\nFunci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DMAX (BDMAX) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/dmax\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DMAX (BDMAX) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/dmax\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:45:43+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/dmax\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/dmax\/\",\"name\":\"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:45:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n DMAX (BDMAX) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/dmax\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/dmax\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/dmax\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de datos\",\"item\":\"https:\/\/functiontranslator.com\/es\/base-de-datos\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDMAX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n DMAX (BDMAX) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/dmax\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n DMAX (BDMAX) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/dmax\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:45:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/dmax\/","url":"https:\/\/functiontranslator.com\/es\/dmax\/","name":"Funci\u00f3n DMAX (BDMAX) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:45:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n DMAX (BDMAX) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/dmax\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/dmax\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/dmax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Base de datos","item":"https:\/\/functiontranslator.com\/es\/base-de-datos\/"},{"@type":"ListItem","position":3,"name":"BDMAX"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13930"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13930\/revisions"}],"predecessor-version":[{"id":29993,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13930\/revisions\/29993"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}