{"id":14091,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/minversa\/"},"modified":"2021-02-26T08:53:58","modified_gmt":"2021-02-26T08:53:58","slug":"minverse","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/minverse\/","title":{"rendered":"MINVERSA"},"content":{"rendered":"

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

La funci\u00f3n MINVERSA en Excel y Google Sheets sirve para calcular la matriz inversa de una matriz cuadrada. Este c\u00e1lculo es esencial en an\u00e1lisis num\u00e9rico y en la soluci\u00f3n de ecuaciones lineales, donde la inversi\u00f3n de matrices es fundamental. Para que una matriz sea invertible, debe ser cuadrada (es decir, tener igual n\u00famero de filas que de columnas) y su determinante no debe ser cero.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

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

MINVERSA(matriz)<\/code><\/pre>\n
Donde matriz<\/strong> es la matriz que deseamos invertir y debe ingresarse como un rango de celdas que conformen una matriz cuadrada.<\/p>\n\n\n\n\n
Ejemplo<\/th>\nDescripci\u00f3n<\/th>\n<\/tr>\n
\n
=MINVERSA(A1:B2)<\/code><\/pre>\n<\/td>\n
Calcula la inversa de la matriz 2×2 ubicada en el rango A1:B2.<\/td>\n<\/tr>\n
\n
=MINVERSA({1,2;3,4})<\/code><\/pre>\n<\/td>\n
Calcula la inversa de una matriz espec\u00edfica insertada directamente en la f\u00f3rmula de Excel.<\/td>\n<\/tr>\n<\/table>\n
Aplicaciones Pr\u00e1cticas<\/h2>\n
A continuaci\u00f3n, se explorar\u00e1n dos escenarios pr\u00e1cticos donde la funci\u00f3n MINVERSA resulta especialmente \u00fatil:<\/p>\n
Resoluci\u00f3n de Sistemas de Ecuaciones<\/h2>\n
Uno de los empleos m\u00e1s comunes de la inversi\u00f3n de matrices es la resoluci\u00f3n de sistemas de ecuaciones lineales. Por ejemplo, tomemos el siguiente sistema:<\/p>\n
    \n
  • x + 2y = 8<\/li>\n
  • 3x + 4y = 18<\/li>\n<\/ul>\n
    Este sistema se puede representar de forma matricial como AX = B, donde A es la matriz de coeficientes, X la matriz de variables y B la matriz de constantes:<\/p>\n
    A = {1, 2; 3, 4} X = {x; y} B = {8; 18}<\/code><\/pre>\n
    Para hallar X, utilizamos la inversa de A:<\/p>\n
    X = MINVERSA(A) * B<\/code><\/pre>\n
    Primero, es necesario calcular la inversa de A (se asume que A est\u00e1 en el rango A1:B2 y B en C1:C2):<\/p>\n
    =MMULT(MINVERSA(A1:B2), C1:C2)<\/code><\/pre>\n
    Este procedimiento nos proporcionar\u00e1 los valores de x e y que resuelven el sistema.<\/p>\n
    An\u00e1lisis de Redes El\u00e9ctricas<\/h2>\n
    En el campo de la ingenier\u00eda, la inversi\u00f3n de matrices se emplea para analizar redes el\u00e9ctricas complejas. Supongamos que necesitamos determinar los potenciales en diversos puntos de una red. Las resistencias entre los nodos forman una matriz y los potenciales pueden calcularse invirtiendo dicha matriz.<\/p>\n
    Si definimos la matriz de resistencias (por ejemplo, en el rango A1:D4) junto con una matriz de corrientes en los nodos (en E1:E4), el c\u00e1lculo de los potenciales V ser\u00eda:<\/p>\n
    V = MINVERSA(A1:D4) * E1:E4<\/code><\/pre>\n
    Este m\u00e9todo es vital para el dise\u00f1o y mantenimiento de redes el\u00e9ctricas.<\/p>\n
    Estos ejemplos evidencian la importancia de la funci\u00f3n MINVERSA en campos que requieren manipulaci\u00f3n matricial para la resoluci\u00f3n de problemas complejos, desde \u00e1lgebra lineal hasta ingenier\u00eda el\u00e9ctrica.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la matriz inversa de una matriz<\/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-14091","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n MINVERSE (MINVERSA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n MINVERSE (MINVERSA) 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\/minverse\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n MINVERSE (MINVERSA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n MINVERSE (MINVERSA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/minverse\/\" \/>\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:53:58+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 MINVERSE (MINVERSA) 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\/minverse\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/minverse\/\",\"name\":\"Funci\u00f3n MINVERSE (MINVERSA) 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:53:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n MINVERSE (MINVERSA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/minverse\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/minverse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/minverse\/#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\":\"MINVERSA\"}]},{\"@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 MINVERSE (MINVERSA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n MINVERSE (MINVERSA) 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\/minverse\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n MINVERSE (MINVERSA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n MINVERSE (MINVERSA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/minverse\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:53:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n MINVERSE (MINVERSA) 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\/minverse\/","url":"https:\/\/functiontranslator.com\/es\/minverse\/","name":"Funci\u00f3n MINVERSE (MINVERSA) 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:53:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n MINVERSE (MINVERSA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/minverse\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/minverse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/minverse\/#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":"MINVERSA"}]},{"@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\/14091","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=14091"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14091\/revisions"}],"predecessor-version":[{"id":30184,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14091\/revisions\/30184"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}