{"id":15309,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/eleman\/"},"modified":"2021-02-25T16:23:39","modified_gmt":"2021-02-25T16:23:39","slug":"choose","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/choose\/","title":{"rendered":"ELEMAN"},"content":{"rendered":"

MS Excel ve Google E-Tablolar\u2019da ELEMAN Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n

MS Excel ve Google E-Tablolar, veri analizi ve i\u015flem s\u00fcre\u00e7lerini kolayla\u015ft\u0131ran iki g\u00fc\u00e7l\u00fc ara\u00e7t\u0131r. Bu ara\u00e7lardaki ELEMAN<\/code> (veya \u0130ngilizce ad\u0131yla CHOOSE<\/code>) fonksiyonu, belirtilen indeks numaras\u0131na uygun olarak bir dizi i\u00e7erisinden de\u011fer se\u00e7menizi sa\u011flar. Fonksiyon, dinamik raporlar\u0131n veya kullan\u0131c\u0131ya \u00f6zel bilgilerin sunulmas\u0131nda olduk\u00e7a i\u015flevseldir.<\/p>\n

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

ELEMAN<\/code> fonksiyonunun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=ELEMAN(index_num, value1, [value2], ...)<\/code><\/pre>\n
    \n
  • index_num<\/strong>: Hangi de\u011ferin se\u00e7ilece\u011fini belirleyen pozisyon numaras\u0131. 1’den ba\u015flar.<\/li>\n
  • value1, value2, \u2026<\/strong>: Se\u00e7ilebilecek de\u011ferlerin listesi. En az bir de\u011fer sa\u011flanmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =ELEMAN(2, \"Elma\", \"Muz\", \"\u00c7ilek\")<\/code><\/pre>\n
    Bu \u00f6rnekte, fonksiyon “Muz” sonucunu d\u00f6nd\u00fcrecektir \u00e7\u00fcnk\u00fc ikinci s\u0131radaki eleman se\u00e7ilmi\u015ftir.<\/p>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmler<\/h2>\n
    Veri Setinin Durumuna G\u00f6re Metin G\u00f6sterimi<\/h3>\n
    Diyelim ki bir e-ticaret firman\u0131z var ve sto\u011funuzdaki \u00fcr\u00fcn say\u0131s\u0131na g\u00f6re bilgi mesaj\u0131 g\u00f6stermek istiyorsunuz:<\/p>\n
    =ELEMAN(A1, \"Stokta t\u00fckenmi\u015f!\", \"Az say\u0131da kald\u0131!\", \"Stokta yeterli miktarda var!\")<\/code><\/pre>\n
    Burada A1<\/code> h\u00fccresinde \u00fcr\u00fcn miktar\u0131 baz\u0131nda bir say\u0131 olacak (1: t\u00fckendi, 2: az kald\u0131, 3: yeterli) ve bu say\u0131ya g\u00f6re uygun mesaj\u0131 g\u00f6sterecektir.<\/p>\n
    Finansal Senaryo Analizi<\/h3>\n
    Bir di\u011fer \u00f6rnek, farkl\u0131 finansal senaryolar i\u00e7in projeksiyon g\u00f6stermek olabilir:<\/p>\n
    =ELEMAN(B1, \"Temel senaryo sonucu\", \"\u0130yimser senaryo sonucu\", \"K\u00f6t\u00fcmser senaryo sonucu\")<\/code><\/pre>\n
    Bu durumda B1<\/code> h\u00fccresi, 1, 2 veya 3 de\u011ferlerini alabilir ve bu de\u011ferlere g\u00f6re belirlenen senaryonun sonucunu g\u00f6sterir.<\/p>\n
    Yorum ve \u00d6neriler<\/h2>\n
    ELEMAN<\/code> fonksiyonu basit g\u00f6r\u00fcnse de, raporlama ve veri analizi konusunda olduk\u00e7a esnek \u00e7\u00f6z\u00fcmler sunar. Esas de\u011feri, se\u00e7im yetene\u011fi ve ko\u015fullu mant\u0131k i\u00e7erisindeki \u00e7al\u0131\u015fma kapasitesinden gelir. Dinamik dashboard ve interaktif raporlar olu\u015ftururken bu t\u00fcr fonksiyonlar\u0131 kullanarak veri sunumu yapabilirsiniz.<\/p>\n
    Bu fonksiyonun kullan\u0131m\u0131n\u0131 maksimize etmek i\u00e7in, her kullan\u0131lacak de\u011feri net ve anla\u015f\u0131l\u0131r yapmaya \u00f6zen g\u00f6sterin. Ayr\u0131ca, kullan\u0131c\u0131 girdilerine ba\u011fl\u0131 olarak sonu\u00e7lar \u00fcretmek i\u00e7in bu fonksiyonu, di\u011fer Excel veya Google E-Tablolar fonksiyonlar\u0131 ile birle\u015ftirebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    De\u011fer listesinden bir de\u011fer se\u00e7er<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15309","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de CHOOSE (ELEMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da CHOOSE (ELEMAN) 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\/choose\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de CHOOSE (ELEMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da CHOOSE (ELEMAN) 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\/choose\/\" \/>\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:39+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 CHOOSE (ELEMAN) 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\/choose\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/choose\/\",\"name\":\"Excel'de CHOOSE (ELEMAN) 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:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CHOOSE (ELEMAN) 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\/choose\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/choose\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/choose\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arama ve ba\u015fvuru\",\"item\":\"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ELEMAN\"}]},{\"@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 CHOOSE (ELEMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CHOOSE (ELEMAN) 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\/choose\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CHOOSE (ELEMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CHOOSE (ELEMAN) 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\/choose\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CHOOSE (ELEMAN) 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\/choose\/","url":"https:\/\/functiontranslator.com\/tr\/choose\/","name":"Excel'de CHOOSE (ELEMAN) 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:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CHOOSE (ELEMAN) 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\/choose\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/choose\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/choose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Arama ve ba\u015fvuru","item":"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/"},{"@type":"ListItem","position":3,"name":"ELEMAN"}]},{"@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\/15309","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=15309"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15309\/revisions"}],"predecessor-version":[{"id":26577,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15309\/revisions\/26577"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}