{"id":15666,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ilkeslenen\/"},"modified":"2021-02-25T16:37:12","modified_gmt":"2021-02-25T16:37:12","slug":"switch","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/switch\/","title":{"rendered":"\u0130LKE\u015eLENEN"},"content":{"rendered":"

SWITCH, ya da T\u00fcrk\u00e7e ad\u0131yla \u0130LKE\u015eLEME fonksiyonu,<\/strong> belirli bir de\u011feri dizi i\u00e7erisinde yer alan \u00e7e\u015fitli durumlarla kar\u015f\u0131la\u015ft\u0131rarak e\u015fle\u015fen duruma ba\u011fl\u0131 bir sonu\u00e7 \u00fcreten olduk\u00e7a faydal\u0131 bir fonksiyondur. Hem Microsoft Excel hem de Google Sheets i\u00e7erisinde kullan\u0131labilir ve farkl\u0131 ko\u015fullar\u0131n cevaplar\u0131n\u0131 y\u00f6netmek amac\u0131yla m\u00fckemmeldir.<\/p>\n

\u0130LKE\u015eLEME Fonksiyonunun S\u00f6zdizimi<\/h2>\n

SWITCH fonksiyonunun genel form\u00fcl yap\u0131s\u0131 \u015fu \u015fekildedir:<\/p>\n

SWITCH (expression, value1, result1, [default_or_value2, result2, ...]) <\/code><\/pre>\n
Buradaki elemanlar:<\/p>\n
    \n
  • expression:<\/strong> Kar\u015f\u0131la\u015ft\u0131rma yap\u0131lacak ana de\u011fer.<\/li>\n
  • valueX:<\/strong> Kar\u015f\u0131la\u015ft\u0131rma i\u00e7in tan\u0131mlanan potansiyel de\u011ferler.<\/li>\n
  • resultX:<\/strong> Belirtilen valueX de\u011feri ile expression e\u015fle\u015firse d\u00f6nd\u00fcr\u00fclecek sonu\u00e7lar.<\/li>\n
  • default:<\/strong> Opsiyonel. Hi\u00e7bir de\u011ferle e\u015fle\u015fme olmazsa d\u00f6nd\u00fcr\u00fclecek sonu\u00e7.<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, bir \u00f6\u011frencinin notunu harf kar\u015f\u0131l\u0131\u011f\u0131na \u00e7evirmek amac\u0131yla kullanabiliriz:<\/p>\n
    =SWITCH(D2, \"A\", \"M\u00fckemmel\", \"B\", \"\u0130yi\", \"C\", \"Orta\", \"D\", \"Yeterli\", \"E\", \"K\u00f6t\u00fc\", \"Bilinmiyor\") <\/code><\/pre>\n
    Bu form\u00fcl, D2 h\u00fccresindeki not de\u011ferine g\u00f6re uygun olan yorumu d\u00f6nd\u00fcrecektir.<\/p>\n
    Pratik Kullan\u0131m Durumlar\u0131<\/h2>\n
    Bir Ma\u011fazan\u0131n Sat\u0131\u015f Bonuslar\u0131 Hesaplamas\u0131<\/h2>\n
    Bir ma\u011faza, \u00e7al\u0131\u015fanlar\u0131n\u0131n ger\u00e7ekle\u015ftirdikleri sat\u0131\u015f miktar\u0131na g\u00f6re bonuslar sa\u011flar. Bu hesaplamay\u0131 yapmak i\u00e7in SWITCH fonksiyonundan yararlanabiliriz:<\/p>\n
    =SWITCH(B2, 10000, \"1000 TL Bonus\", 5000, \"500 TL Bonus\", 1000, \"100 TL Bonus\", \"No Bonus\" ) <\/code><\/pre>\n
    Burada B2<\/code> h\u00fccresi sat\u0131\u015f miktar\u0131n\u0131 temsil etmekte ve miktar\u0131na g\u00f6re belirlenen bonusu d\u00f6nd\u00fcrmektedir.<\/p>\n
    \u00dcr\u00fcn Kategorilerine G\u00f6re Fiyatland\u0131rma<\/h2>\n
    Farkl\u0131 \u00fcr\u00fcn kategorileri i\u00e7in \u00e7e\u015fitli fiyatland\u0131rma stratejileri bu fonksiyonla y\u00f6netilebilir. \u00d6rnek vermek gerekirse:<\/p>\n
    =SWITCH(A2, \"Elektronik\", 29.99, \"Kitap\", 9.99, \"Giyim\", 19.99, \"Di\u011fer\", 14.99 ) <\/code><\/pre>\n
    A2<\/code> h\u00fccresi \u00fcr\u00fcn kategorisini temsil etmekte ve her kategori i\u00e7in ilgili fiyat\u0131 d\u00f6nd\u00fcrmektedir.<\/p>\n
    Bu \u00f6rnekler, SWITCH fonksiyonunun \u00e7e\u015fitli durumlar kar\u015f\u0131s\u0131nda nas\u0131l belirlenmi\u015f g\u00f6revler i\u00e7in otomatik hesaplamalar yapabildi\u011fini g\u00f6stermektedir, bu da veri analiz s\u00fcre\u00e7lerini daha etkin ve h\u0131zl\u0131 bir \u015fekilde y\u00f6netmeye olanak tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    De\u011ferler listesindeki bir ifadeyi de\u011ferlendirir ve e\u015fle\u015fen ilk de\u011fere kar\u015f\u0131l\u0131k gelen sonucu d\u00f6nd\u00fcr\u00fcr E\u015fle\u015fme yoksa, iste\u011fe ba\u011fl\u0131 bir varsay\u0131lan de\u011fer d\u00f6nd\u00fcr\u00fclebilir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[580],"tags":[],"class_list":["post-15666","post","type-post","status-publish","format-standard","hentry","category-mantiksal"],"acf":[],"yoast_head":"\nExcel'de SWITCH (\u0130LKE\u015eLENEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SWITCH (\u0130LKE\u015eLENEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/\" \/>\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:37:12+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 SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/switch\/\",\"name\":\"Excel'de SWITCH (\u0130LKE\u015eLENEN) 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:37:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/switch\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/switch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mant\u0131ksal\",\"item\":\"https:\/\/functiontranslator.com\/tr\/mantiksal\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0130LKE\u015eLENEN\"}]},{\"@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 SWITCH (\u0130LKE\u015eLENEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SWITCH (\u0130LKE\u015eLENEN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/","url":"https:\/\/functiontranslator.com\/tr\/switch\/","name":"Excel'de SWITCH (\u0130LKE\u015eLENEN) 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:37:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SWITCH (\u0130LKE\u015eLENEN) 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\/switch\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/switch\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/switch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Mant\u0131ksal","item":"https:\/\/functiontranslator.com\/tr\/mantiksal\/"},{"@type":"ListItem","position":3,"name":"\u0130LKE\u015eLENEN"}]},{"@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\/15666","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=15666"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15666\/revisions"}],"predecessor-version":[{"id":27064,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15666\/revisions\/27064"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}