{"id":15315,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kombinasyona\/"},"modified":"2021-02-25T16:23:45","modified_gmt":"2021-02-25T16:23:45","slug":"combina","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/combina\/","title":{"rendered":"KOMB\u0130NASYONA"},"content":{"rendered":"

Tan\u0131m ve Kullan\u0131m: KOMB\u0130NASYONA Fonksiyonu<\/h2>\n

Microsoft Excel ve Google Sheets’teki KOMB\u0130NASYONA fonksiyonu, belirli bir say\u0131da nesnenin tekrarlar\u0131na izin verilerek yap\u0131lan kombinasyonlar\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, belirlenen nesne say\u0131s\u0131ndan belirlenen miktar kadar nesnenin ka\u00e7 farkl\u0131 \u015fekilde se\u00e7ilebilece\u011fini belirtir. Fonksiyonun genel yap\u0131s\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 KOMB\u0130NASYONA(n, k) <\/code><\/pre>\n
Buradaki parametreler \u015funlard\u0131r:<\/p>\n
    \n
  • n<\/strong>: Toplam nesne say\u0131s\u0131 olup, pozitif bir tam say\u0131 olmal\u0131d\u0131r.<\/li>\n
  • k<\/strong>: Her kombinasyonda yer alacak nesne say\u0131s\u0131 olup, yine pozitif bir tam say\u0131 olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, 10 farkl\u0131 kitaptan rastgele 3 tanesi se\u00e7ildi\u011finde ve her kitap birden fazla kez se\u00e7ilebildi\u011finde, olu\u015facak kombinasyonlar\u0131n say\u0131s\u0131n\u0131 hesaplamak i\u00e7in \u015fu form\u00fcl kullan\u0131l\u0131r:<\/p>\n
     =KOMB\u0130NASYONA(10, 3) <\/code><\/pre>\n
    Bu form\u00fcl, 10 kitap aras\u0131ndan tekrarlamal\u0131 \u015fekilde 3 kitab\u0131n ka\u00e7 farkl\u0131 \u015fekilde se\u00e7ilebilece\u011fini g\u00f6sterir.<\/p>\n
    Pratik Uygulama: Fuar Organizasyonu<\/h2>\n
    Bir fuar organizasyonunda 15 farkl\u0131 bro\u015f\u00fcr bulunmakta ve ziyaret\u00e7ilere 3 farkl\u0131 bro\u015f\u00fcr da\u011f\u0131t\u0131lacak. Her bro\u015f\u00fcr birden fazla kez se\u00e7ilebilir durumda oldu\u011fundan, m\u00fcmk\u00fcn olan farkl\u0131 bro\u015f\u00fcr kombinasyonlar\u0131n\u0131 belirlemek i\u00e7in:<\/p>\n
     =KOMB\u0130NASYONA(15, 3) <\/code><\/pre>\n
    Bu hesaplama, da\u011f\u0131tabilece\u011finiz farkl\u0131 bro\u015f\u00fcr setlerinin say\u0131s\u0131n\u0131 belirtir.<\/p>\n
    Pratik Uygulama: Yemek Tarifi Se\u00e7imi<\/h2>\n
    Bir yemek kursunda, \u00f6\u011fretmen kursiyerlere toplam 8 farkl\u0131 malzemeden 5 tanesini kullanarak farkl\u0131 yemek tarifleri haz\u0131rlamalar\u0131n\u0131 istiyor. Malzemelerin her biri tekrar se\u00e7ilebilece\u011finden, olu\u015facak farkl\u0131 yemek tarifi kombinasyonlar\u0131 \u015fu \u015fekilde hesaplan\u0131r:<\/p>\n
     =KOMB\u0130NASYONA(8, 5) <\/code><\/pre>\n
    Bu form\u00fcl, kursiyerlerin 8 malzeme i\u00e7inden tekrarlamal\u0131 olarak 5 malzeme se\u00e7erek haz\u0131rlayabilece\u011fi yemek tariflerinin say\u0131s\u0131n\u0131 verir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Verilen \u00f6\u011felerin say\u0131s\u0131 i\u00e7in kombinasyon say\u0131s\u0131n\u0131 (yinelemelerle birlikte) 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-15315","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de COMBINA (KOMB\u0130NASYONA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COMBINA (KOMB\u0130NASYONA) 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\/combina\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COMBINA (KOMB\u0130NASYONA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COMBINA (KOMB\u0130NASYONA) 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\/combina\/\" \/>\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:23:45+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 COMBINA (KOMB\u0130NASYONA) 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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/combina\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/combina\/\",\"name\":\"Excel'de COMBINA (KOMB\u0130NASYONA) 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:23:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COMBINA (KOMB\u0130NASYONA) 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\/combina\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/combina\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/combina\/#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\":\"KOMB\u0130NASYONA\"}]},{\"@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 COMBINA (KOMB\u0130NASYONA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COMBINA (KOMB\u0130NASYONA) 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\/combina\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COMBINA (KOMB\u0130NASYONA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COMBINA (KOMB\u0130NASYONA) 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\/combina\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COMBINA (KOMB\u0130NASYONA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/combina\/","url":"https:\/\/functiontranslator.com\/tr\/combina\/","name":"Excel'de COMBINA (KOMB\u0130NASYONA) 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:23:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COMBINA (KOMB\u0130NASYONA) 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\/combina\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/combina\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/combina\/#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":"KOMB\u0130NASYONA"}]},{"@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\/15315","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=15315"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15315\/revisions"}],"predecessor-version":[{"id":27041,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15315\/revisions\/27041"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}