{"id":14093,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/mmult\/"},"modified":"2021-02-26T08:54:00","modified_gmt":"2021-02-26T08:54:00","slug":"mmult","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/mmult\/","title":{"rendered":"MMULT"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n de Multiplicaci\u00f3n de Matrices<\/h2>\n

La funci\u00f3n MMULT es utilizada tanto en Microsoft Excel como en Google Sheets para calcular el producto de dos matrices. Es esencial en an\u00e1lisis de datos, \u00e1lgebra lineal y diversas aplicaciones en negocios y ciencias.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n es la siguiente:<\/p>\n

MMULT(matriz1, matriz2)<\/code><\/pre>\n
Donde matriz1<\/code> y matriz2<\/code> son las matrices que se multiplicar\u00e1n. Es crucial que el n\u00famero de columnas en matriz1<\/code> sea igual al n\u00famero de filas en matriz2<\/code>.<\/p>\n
Ejemplo b\u00e1sico:<\/p>\n
    \n
  • Considera matriz1<\/code> como A, que es una matriz 2×3:<\/li>\n
    | 1 2 3 | | 4 5 6 |<\/code><\/pre>\n
  • Y matriz2<\/code> como B, que es una matriz 3×2:<\/li>\n
    | 7 8 | | 9 10 | | 11 12 |<\/code><\/pre>\n
  • El resultado de MMULT(A, B) ser\u00e1:<\/li>\n
    | 58 64 | | 139 154 |<\/code><\/pre>\n<\/ul>\n
    Aplicaciones Pr\u00e1cticas de la Funci\u00f3n<\/h2>\n
    1. An\u00e1lisis econ\u00f3mico de combinaci\u00f3n de productos<\/h2>\n
    Imagina que necesitas evaluar el impacto de producir diferentes combinaciones de productos en los ingresos. Supongamos que produces dos tipos de productos usando dos m\u00e1quinas, cada una con una capacidad de producci\u00f3n limitada y diferente:<\/p>\n\n\n\n\n
    M\u00e1quina\/Producto<\/th>\nProducto 1<\/th>\nProducto 2<\/th>\n<\/tr>\n
    M\u00e1quina A<\/td>\n10<\/td>\n20<\/td>\n<\/tr>\n
    M\u00e1quina B<\/td>\n15<\/td>\n25<\/td>\n<\/tr>\n<\/table>\n
    La matriz de ingresos por producto es:<\/p>\n\n\n\n\n
    Producto<\/th>\nIngreso<\/th>\n<\/tr>\n
    Producto 1<\/td>\n5<\/td>\n<\/tr>\n
    Producto 2<\/td>\n8<\/td>\n<\/tr>\n<\/table>\n
    Para encontrar el ingreso total por m\u00e1quina, multiplicas las matrices:<\/p>\n
    Ingresos totales = MMULT( |10 20|, |5| |15 25| |8| )<\/code><\/pre>\n
    Resultando en:<\/p>\n
    | 10*5 + 20*8 | = | 210 | | 15*5 + 25*8 | | 335 |<\/code><\/pre>\n
    As\u00ed, la m\u00e1quina A generar\u00e1 $210 y la m\u00e1quina B $335 en ingresos.<\/p>\n
    2. An\u00e1lisis de redes sociales<\/h2>\n
    En un an\u00e1lisis de redes sociales, puedes utilizar la MMULT para calcular el n\u00famero potencial de terceras conexiones (amigos de amigos de amigos) que una persona puede tener.<\/p>\n
    Considera esta matriz de adyacencia, donde un ‘1’ indica una conexi\u00f3n directa entre dos personas:<\/p>\n
    | 0 1 1 | | 1 0 1 | | 1 1 0 |<\/code><\/pre>\n
    Multiplicando esta matriz por s\u00ed misma dos veces obtienes una cuenta de cu\u00e1ntas terceras conexiones tiene cada persona:<\/p>\n
    Conexiones de tercer nivel = MMULT(MMULT(matriz, matriz), matriz)<\/code><\/pre>\n
    Esto te permite identificar las personas con mayor influencia o centralidad en una red, bas\u00e1ndote en sus conexiones de nivel tercero.<\/p>\n
    Con estas herramientas, MMULT se convierte en una funci\u00f3n poderosa para an\u00e1lisis matricial en diversas aplicaciones tanto en Excel como en Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el producto matricial de dos matrices<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[535],"tags":[],"class_list":["post-14093","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n MMULT en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n MMULT 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\/mmult\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n MMULT en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n MMULT de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/mmult\/\" \/>\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:54:00+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 MMULT 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\/mmult\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/mmult\/\",\"name\":\"Funci\u00f3n MMULT 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:54:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n MMULT de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/mmult\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/mmult\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/mmult\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1ticas y trigonometr\u00eda\",\"item\":\"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MMULT\"}]},{\"@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 MMULT en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n MMULT 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\/mmult\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n MMULT en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n MMULT de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/mmult\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:54:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n MMULT 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\/mmult\/","url":"https:\/\/functiontranslator.com\/es\/mmult\/","name":"Funci\u00f3n MMULT 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:54:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n MMULT de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/mmult\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/mmult\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/mmult\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1ticas y trigonometr\u00eda","item":"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/"},{"@type":"ListItem","position":3,"name":"MMULT"}]},{"@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\/14093","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=14093"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14093\/revisions"}],"predecessor-version":[{"id":30186,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14093\/revisions\/30186"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}