{"id":6666,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/inversemat\/"},"modified":"2021-02-26T08:10:25","modified_gmt":"2021-02-26T08:10:25","slug":"minverse","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/minverse\/","title":{"rendered":"INVERSEMAT"},"content":{"rendered":"

La fonction MINVERSE<\/strong> (ou INVERSEMAT<\/strong> dans certains logiciels) est essentielle dans Excel et Google Sheets pour le calcul de l’inverse d’une matrice carr\u00e9e, \u00e0 condition que la matrice ait un nombre \u00e9gal de lignes et de colonnes et un d\u00e9terminant non nul. L’inversion de matrices est fondamentale dans des domaines comme l’alg\u00e8bre lin\u00e9aire, la statistique et l’ing\u00e9nierie.<\/p>\n

Syntaxe et exemples d’utilisation<\/h2>\n

La syntaxe de la fonction est :<\/p>\n

=MINVERSE(matrice)<\/code><\/pre>\n
o\u00f9 matrice<\/em> est la matrice carr\u00e9e \u00e0 inverser, sp\u00e9cifi\u00e9e par une plage de cellules dans votre feuille de calcul.<\/p>\n
Exemple :<\/p>\n
Consid\u00e9rez la matrice A dans Excel d\u00e9finie par les cellules A1:B2 : | 1 2 | | 3 4 | Pour obtenir l'inverse de cette matrice, utilisez : =MINVERSE(A1:B2)<\/code><\/pre>\n
Ce qui retournera : | -2 1 | | 1.5 -0.5 |<\/p>\n
Cas pratiques d’application<\/h2>\n
1. R\u00e9solution de syst\u00e8mes d’\u00e9quations lin\u00e9aires<\/h2>\n
Consid\u00e9rez le syst\u00e8me d’\u00e9quations suivant :<\/p>\n
    \n
  • x + 2y = 5<\/li>\n
  • 3x + 4y = 11<\/li>\n<\/ul>\n
    Ce syst\u00e8me peut \u00eatre repr\u00e9sent\u00e9 sous forme matricielle Ax = B :<\/p>\n
    A = | 1 2 | | 3 4 | B = | 5 | | 11 |<\/code><\/pre>\n
    Inversez A en utilisant MINVERSE :<\/p>\n
    A_inv = MINVERSE(A1:B2)<\/code><\/pre>\n
    Multiplication de A_inv par B pour obtenir x et y :<\/p>\n
    R\u00e9sultat = MMULT(A_inv, B)<\/code><\/pre>\n
    Les valeurs r\u00e9sultantes sont :<\/p>\n
    x = 1 y = 2<\/code><\/pre>\n
    2. Analyse en composantes principales (PCA)<\/h2>\n
    Dans le domaine de l’apprentissage automatique, l’inversion de matrices est fr\u00e9quemment utilis\u00e9e pour l’analyse en composantes principales afin de r\u00e9duire la dimensionnalit\u00e9 des donn\u00e9es. Supposons que la matrice de covariance des caract\u00e9ristiques soit :<\/p>\n
    | 1 0.9 | | 0.9 1 |<\/code><\/pre>\n
    L’inversion de cette matrice peut \u00eatre obtenue avec :<\/p>\n
    =MINVERSE(A1:B2)<\/code><\/pre>\n
    Le r\u00e9sultat est :<\/p>\n
    | 5 -4.5 | | -4.5 5 |<\/code><\/pre>\n
    Cette matrice invers\u00e9e est ult\u00e9rieurement utilisable pour d’autres calculs dans le cadre de PCA.<\/p>\n
    En somme, l’utilisation de la fonction MINVERSE est inestimable pour manipuler des matrices en math\u00e9matiques appliqu\u00e9es et en analyse de donn\u00e9es, offrant des solutions efficaces pour une vari\u00e9t\u00e9 de probl\u00e8mes complexes.<\/p>\n
     This revised version maintains the HTML structure while improving language accuracy, terminology, and cohesion, suitable for professional documentation.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la matRice inveRse d\u2019une matRice<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6666","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MINVERSE (INVERSEMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/minverse\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MINVERSE (INVERSEMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/minverse\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:10:25+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/minverse\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/minverse\/\",\"name\":\"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:10:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MINVERSE (INVERSEMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/minverse\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/minverse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/minverse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"INVERSEMAT\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MINVERSE (INVERSEMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/minverse\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MINVERSE (INVERSEMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/minverse\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/minverse\/","url":"https:\/\/functiontranslator.com\/fr\/minverse\/","name":"Fonction MINVERSE (INVERSEMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:10:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MINVERSE (INVERSEMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/minverse\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/minverse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/minverse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"INVERSEMAT"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6666"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6666\/revisions"}],"predecessor-version":[{"id":29677,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6666\/revisions\/29677"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}