{"id":15538,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/dcarp\/"},"modified":"2021-02-25T16:31:56","modified_gmt":"2021-02-25T16:31:56","slug":"mmult","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/mmult\/","title":{"rendered":"D\u00c7ARP"},"content":{"rendered":"

MMULT veya T\u00fcrk\u00e7e ad\u0131yla D\u00c7ARP fonksiyonu, Excel ve Google Sheets’te iki matrisin \u00e7arp\u0131m\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131lan temel fonksiyonlardan biridir. Bu fonksiyonun uygulanabilmesi i\u00e7in, ilk matrisin s\u00fctun say\u0131s\u0131n\u0131n ikinci matrisin sat\u0131r say\u0131s\u0131yla e\u015fle\u015fmesi gerekmektedir. Fonksiyon, ilk matrisin sat\u0131r say\u0131s\u0131 kadar sat\u0131ra ve ikinci matrisin s\u00fctun say\u0131s\u0131 kadar s\u00fctuna sahip bir sonu\u00e7 matrisi \u00fcretir.<\/p>\n

D\u00c7ARP Fonksiyonunun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

D\u00c7ARP fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=D\u00c7ARP(matris1, matris2)<\/code><\/pre>\n
\u2018matris1\u2019 ve \u2018matris2\u2019, \u00e7arp\u0131lacak olan iki matrisi temsil eden h\u00fccre aral\u0131klar\u0131d\u0131r. \u00d6rne\u011fin, A1:B2 ve C1:D2 h\u00fccre aral\u0131klar\u0131 \u015fu \u015fekilde iki matrisi temsil edebilir:<\/p>\n
    \n
  • \n
    A1: 1 B1: 2 A2: 3 B2: 4<\/code><\/pre>\n<\/li>\n
  • \n
    C1: 5 D1: 6 C2: 7 D2: 8<\/code><\/pre>\n<\/li>\n<\/ul>\n
    Bu \u00f6rnekte, =D\u00c7ARP(A1:B2, C1:D2)<\/code> form\u00fcl\u00fc ile iki matris \u00e7arp\u0131l\u0131r ve sonu\u00e7 olarak yeni bir matris elde edilir:<\/p>\n
      \n
    • \n
      E1: 19 F1: 22 E2: 43 F2: 50<\/code><\/pre>\n<\/li>\n<\/ul>\n
      Pratik Uygulama Senaryolar\u0131<\/h2>\n
      Matris \u00e7arp\u0131m\u0131, \u00e7e\u015fitli pratik problemlerin \u00e7\u00f6z\u00fcm\u00fcnde kullan\u0131labilir. \u0130\u015fte birka\u00e7 \u00f6rnek:<\/p>\n
      Senaryo 1: Not Ortalamalar\u0131n\u0131n Hesaplanmas\u0131<\/h2>\n
      A s\u00fctununda \u00f6\u011frencilerin vize notlar\u0131, B s\u00fctununda ise final notlar\u0131 bulunmakta olsun. C s\u00fctununda vize i\u00e7in a\u011f\u0131rl\u0131k %40, D s\u00fctununda ise final i\u00e7in a\u011f\u0131rl\u0131k %60 olarak belirlensin:<\/p>\n
      A1: 70 B1: 80 A2: 90 B2: 85<\/code><\/pre>\n
      C1: 0.4 D1: 0.6<\/code><\/pre>\n
      A\u011f\u0131rl\u0131kl\u0131 not ortalamalar\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131l\u0131r:<\/p>\n
      =D\u00c7ARP(A1:B2, TRANSPOZE(C1:D1))<\/code><\/pre>\n
      Bu sonu\u00e7, \u00f6\u011frencilerin a\u011f\u0131rl\u0131kl\u0131 ortalama notlar\u0131n\u0131 verir:<\/p>\n
        \n
      • \n
        E1: 76 E2: 86.0<\/code><\/pre>\n<\/li>\n<\/ul>\n
        Senaryo 2: \u00dcretim Maliyetlerinin Hesaplanmas\u0131<\/h2>\n
        A2:A4 h\u00fccreleri, \u00fc\u00e7 farkl\u0131 \u00fcr\u00fcn i\u00e7in gereken hammadde miktarlar\u0131n\u0131, B1:D1 h\u00fccreleri ise bu hammaddelerin birim fiyatlar\u0131n\u0131 i\u00e7ermektedir:<\/p>\n
        A2: 5 A3: 3 A4: 7 B1: 2 C1: 3 D1: 4<\/code><\/pre>\n
        Toplam \u00fcretim maliyetini hesaplamak i\u00e7in \u015fu form\u00fcl kullan\u0131l\u0131r:<\/p>\n
        =D\u00c7ARP(TRANSPOZE(A2:A4), B1:D1)<\/code><\/pre>\n
        Bu form\u00fcl, farkl\u0131 hammaddeler i\u00e7in toplam \u00fcretim maliyetini hesaplar:<\/p>\n
          \n
        • \n
          E1: 56<\/code><\/pre>\n<\/li>\n<\/ul>\n
          Excel ve Google Sheets’te D\u00c7ARP fonksiyonu, finans, m\u00fchendislik ve e\u011fitim gibi bir\u00e7ok alanda verilerin i\u015flenmesi ve analiz edilmesi i\u00e7in etkili bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
          \u0130ki dizinin matris \u00e7arp\u0131m\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[577],"tags":[],"class_list":["post-15538","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MMULT (D\u00c7ARP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/mmult\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MMULT (D\u00c7ARP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/mmult\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:31:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/mmult\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/mmult\/\",\"name\":\"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:31:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MMULT (D\u00c7ARP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/mmult\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/mmult\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/mmult\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"D\u00c7ARP\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MMULT (D\u00c7ARP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/mmult\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MMULT (D\u00c7ARP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/mmult\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/mmult\/","url":"https:\/\/functiontranslator.com\/tr\/mmult\/","name":"Excel'de MMULT (D\u00c7ARP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:31:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MMULT (D\u00c7ARP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/mmult\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/mmult\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/mmult\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"D\u00c7ARP"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15538"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15538\/revisions"}],"predecessor-version":[{"id":26806,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15538\/revisions\/26806"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}