{"id":6668,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/produitmat\/"},"modified":"2021-02-26T08:10:28","modified_gmt":"2021-02-26T08:10:28","slug":"mmult","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/mmult\/","title":{"rendered":"PRODUITMAT"},"content":{"rendered":"

La fonction PRODUITMAT (ou MMULT en anglais) permet de multiplier deux matrices dans Microsoft Excel et Google Sheets. Cette fonction est particuli\u00e8rement pr\u00e9cieuse dans des domaines tels que l’analyse financi\u00e8re, la programmation lin\u00e9aire, les statistiques et les math\u00e9matiques en g\u00e9n\u00e9ral. Bien comprendre et ma\u00eetriser PRODUITMAT peut significativement optimiser le traitement des donn\u00e9es impliquant des op\u00e9rations matricielles.<\/p>\n

Syntaxe de la fonction PRODUITMAT\/MMULT<\/h2>\n

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

=PRODUITMAT(matrice1, matrice2)<\/code><\/pre>\n
    \n
  • matrice1<\/strong> : Premi\u00e8re matrice \u00e0 multiplier.<\/li>\n
  • matrice2<\/strong> : Deuxi\u00e8me matrice \u00e0 multiplier. Le nombre de colonnes dans matrice1<\/em> doit correspondre au nombre de lignes dans matrice2<\/em>.<\/li>\n<\/ul>\n
    Exemple d’application :<\/p>\n
    =PRODUITMAT(A1:B2, C1:C2)<\/code><\/pre>\n
    Cet exemple illustre la multiplication d’une matrice 2×2 (A1:B2) par une matrice 2×1 (C1:C2), produisant une matrice r\u00e9sultante 2×1.<\/p>\n
    Cas pratiques d’utilisation<\/h2>\n
    Calcul de performances de produits<\/h2>\n
    Supposons que vous avez une matrice repr\u00e9sentant des quantit\u00e9s de produits vendus par mois (matrice1) et une seconde matrice avec les prix unitaires de ces produits (matrice2). La fonction PRODUITMAT peut \u00eatre utilis\u00e9e pour calculer les revenus mensuels g\u00e9n\u00e9r\u00e9s par chaque produit.<\/p>\n
    Exemple :<\/strong><\/p>\n
    Quantit\u00e9s (matrice1): | 5 | 10 | | 15 | 20 | Prix (matrice2): | 20 | | 30 |<\/code><\/pre>\n
    Solution :<\/p>\n
    =PRODUITMAT(A1:B2, C1:C2)<\/code><\/pre>\n
    R\u00e9sultat :<\/p>\n\n\n\n
    500<\/td>\n<\/tr>\n
    900<\/td>\n<\/tr>\n<\/table>\n
    Ce r\u00e9sultat montre que les revenus pour les produits de la premi\u00e8re ligne s’\u00e9l\u00e8vent \u00e0 500 \u20ac et ceux de la seconde \u00e0 900 \u20ac.<\/p>\n
    Application en statistique pour le calcul de variances-covariances<\/h2>\n
    En statistique, les matrices sont fr\u00e9quemment utilis\u00e9es pour calculer les variances et les covariances entre diff\u00e9rentes s\u00e9ries de donn\u00e9es. La fonction PRODUITMAT facilite ces calculs.<\/p>\n
    Exemple :<\/strong><\/p>\n
      \n
    • Donn\u00e9es (matrice1): Mesures de trois variables X, Y, Z sur quatre observations.<\/li>\n
    • Donn\u00e9es (matrice2): Correspond \u00e0 la matrice1 mais transpos\u00e9e (\u00e9change des lignes et des colonnes).<\/li>\n<\/ul>\n
      Solution :<\/p>\n
      =PRODUITMAT(A1:C4, D1:F4)<\/code><\/pre>\n
      L’utilisation de cette formule avec des donn\u00e9es centr\u00e9es et normalis\u00e9es permet de produire la matrice des variances-covariances.<\/p>\n
      La fonction PRODUITMAT\/MMULT s’av\u00e8re \u00eatre un outil puissant pour les calculs matriciels, facilitant la r\u00e9solution de probl\u00e9matiques complexes avec efficacit\u00e9 dans Excel et Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le pRoduit de deux matRices<\/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-6668","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction MMULT (PRODUITMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MMULT (PRODUITMAT) 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\/mmult\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MMULT (PRODUITMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MMULT (PRODUITMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/mmult\/\" \/>\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:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MMULT (PRODUITMAT) 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\/mmult\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/mmult\/\",\"name\":\"Fonction MMULT (PRODUITMAT) 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:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MMULT (PRODUITMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/mmult\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/mmult\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/mmult\/#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\":\"PRODUITMAT\"}]},{\"@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 MMULT (PRODUITMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MMULT (PRODUITMAT) 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\/mmult\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MMULT (PRODUITMAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MMULT (PRODUITMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/mmult\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MMULT (PRODUITMAT) 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\/mmult\/","url":"https:\/\/functiontranslator.com\/fr\/mmult\/","name":"Fonction MMULT (PRODUITMAT) 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:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MMULT (PRODUITMAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/mmult\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/mmult\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/mmult\/#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":"PRODUITMAT"}]},{"@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\/6668","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=6668"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6668\/revisions"}],"predecessor-version":[{"id":29679,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6668\/revisions\/29679"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}