{"id":15525,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/mak\/"},"modified":"2021-02-25T16:31:27","modified_gmt":"2021-02-25T16:31:27","slug":"max","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/max\/","title":{"rendered":"MAK"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, verilerle \u00e7al\u0131\u015fmam\u0131za yard\u0131mc\u0131 olan pop\u00fcler elektronik tablo programlar\u0131d\u0131r. Bu ara\u00e7lardaki en yayg\u0131n kullan\u0131lan fonksiyonlardan biri, bir dizi de\u011fer veya liste i\u00e7erisindeki maksimum de\u011feri bulmam\u0131za olanak tan\u0131yan MAK (Excel) ya da MAX (Google Sheets) fonksiyonudur. Bu makalede, MAK\/MAX fonksiyonunun kullan\u0131m\u0131n\u0131 detayl\u0131 bir \u015fekilde ele alaca\u011f\u0131z.<\/p>\n

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

MAK veya MAX fonksiyonu, belirli bir dizi ya da liste aras\u0131ndaki en y\u00fcksek de\u011feri bulmak i\u00e7in kullan\u0131l\u0131r. Fonksiyonun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  MAK(say\u01311, [say\u01312], ...) MAX(number1, [number2], ...) <\/code> <\/pre>\n
Parametreler:<\/p>\n
    \n
  • say\u01311, say\u01312, …<\/strong> – En y\u00fcksek de\u011feri hesaplamak \u00fczere de\u011ferlendirilecek say\u0131lar veya h\u00fccre aral\u0131klar\u0131. Excel ve Google Sheets’te en az bir de\u011fer girmek zorunludur.<\/li>\n<\/ul>\n
    Pratik \u00d6rnekler<\/h2>\n
    \u00d6rnek 1: S\u0131n\u0131f\u0131n En Y\u00fcksek Notunu Hesaplama<\/h3>\n
    Bir \u00f6\u011fretmen, s\u0131n\u0131f\u0131ndaki \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131 i\u00e7eren bir veri setine sahiptir ve bu s\u0131nav\u0131n en y\u00fcksek notunu bulmak istiyor. Diyelim ki notlar, Excel’de A1:A30 h\u00fccreleri aras\u0131nda bulunmaktad\u0131r. En y\u00fcksek notu bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<\/p>\n
      =MAK(A1:A30) <\/code> <\/pre>\n
    Bu form\u00fcl, A1’den A30’a kadar olan h\u00fccreler aras\u0131ndaki en y\u00fcksek notu d\u00f6nd\u00fcrecektir.<\/p>\n
    \u00d6rnek 2: Birden Fazla \u00dcr\u00fcn Kategorisindeki En Y\u00fcksek Sat\u0131\u015flar\u0131 Bulma<\/h3>\n
    Bir i\u015fletme sahibi, farkl\u0131 \u00fcr\u00fcn kategorileri aras\u0131nda g\u00fcnl\u00fck en y\u00fcksek sat\u0131\u015flar\u0131 tespit etmek istiyor. E\u011fer C s\u00fctunu g\u00fcnl\u00fck sat\u0131\u015flar\u0131 ve D s\u00fctunu \u00fcr\u00fcn kategorilerini i\u00e7eriyorsa, bu fark\u0131 g\u00f6rmek i\u00e7in pivot tablo kullan\u0131labilir veya alternatif olarak MAX fonksiyonunu \u015fu \u015fekilde kullanabiliriz:<\/p>\n
      =MAKIFS(C:C, D:D, \"Elektronik\") <\/code> <\/pre>\n
    Bu form\u00fcl, “Elektronik” kategorisine ait en y\u00fcksek sat\u0131\u015f miktar\u0131n\u0131 verecektir.<\/p>\n
    Tablo Bi\u00e7iminde Kullan\u0131m \u00d6rnekleri<\/h2>\n\n\n\n\n
    A\u00e7\u0131klama<\/th>\nForm\u00fcl<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
    En y\u00fcksek maa\u015f\u0131 bul<\/td>\n=MAK(B2:B10)<\/td>\nB2’den B10’a kadar olan maa\u015f verileri aras\u0131nda en y\u00fcksek de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/td>\n<\/tr>\n
    \u0130ki farkl\u0131 \u00fcr\u00fcn kategorisinin maksimum sat\u0131\u015flar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131r<\/td>\n=MAKS\u0130MUM(MAKIFS(C:C, D:D, “Elektronik”), MAKIFS(C:C, D:D, “Giyim”))<\/td>\nElektronik ve Giyim kategorilerindeki en y\u00fcksek sat\u0131\u015f de\u011ferlerini kar\u015f\u0131la\u015ft\u0131r\u0131r.<\/td>\n<\/tr>\n<\/table>\n
    MAK\/MAX fonksiyonlar\u0131, veri analizi ve raporlama s\u00fcre\u00e7lerinde olduk\u00e7a \u00f6nemlidir, \u00f6zellikle b\u00fcy\u00fck veri setlerinde en y\u00fcksek de\u011ferleri belirlemek i\u00e7in bu fonksiyonlar hayati rol oynamaktad\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ba\u011f\u0131ms\u0131z de\u011fi\u015fken listesindeki en b\u00fcy\u00fck de\u011feri verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15525","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de MAX (MAK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da MAX (MAK) 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\/max\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de MAX (MAK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da MAX (MAK) 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\/max\/\" \/>\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:27+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 MAX (MAK) 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\/max\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/max\/\",\"name\":\"Excel'de MAX (MAK) 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:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da MAX (MAK) 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\/max\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/max\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/max\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MAK\"}]},{\"@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 MAX (MAK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da MAX (MAK) 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\/max\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de MAX (MAK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da MAX (MAK) 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\/max\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de MAX (MAK) 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\/max\/","url":"https:\/\/functiontranslator.com\/tr\/max\/","name":"Excel'de MAX (MAK) 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:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da MAX (MAK) 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\/max\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/max\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/max\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"MAK"}]},{"@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\/15525","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=15525"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15525\/revisions"}],"predecessor-version":[{"id":26793,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15525\/revisions\/26793"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}