{"id":15457,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/ifs\/"},"modified":"2021-02-25T16:28:43","modified_gmt":"2021-02-25T16:28:43","slug":"ifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/ifs\/","title":{"rendered":"IFS"},"content":{"rendered":"

IFS \u0130\u015flevine Giri\u015f<\/h2>\n

IFS<\/code> i\u015flevi, belirtilen ko\u015fullara dayanarak farkl\u0131 sonu\u00e7lar d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. MS Excel ve Google E-Tablolar’da, birden fazla ko\u015ful ve sonuca izin veren bu i\u015flev, kullan\u0131c\u0131lar\u0131n birden \u00e7ok IF()<\/code> i\u015flevini i\u00e7 i\u00e7e kullanmas\u0131n\u0131n \u00f6n\u00fcne ge\u00e7erek daha temiz ve anla\u015f\u0131l\u0131r form\u00fcller yazmas\u0131na olanak tan\u0131r.<\/p>\n

\u0130\u015flevin temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

IFS(ko\u015ful1, sonu\u00e71, ko\u015ful2, sonu\u00e72, ..., ko\u015ful_n, sonu\u00e7_n)<\/code><\/pre>\n
Burada ko\u015ful1, ko\u015ful2, ..., ko\u015ful_n<\/code> s\u0131rayla de\u011ferlendirilir ve ilk TRUE de\u011ferini (do\u011fru) veren ko\u015fulun kar\u015f\u0131l\u0131k gelen sonucu geri d\u00f6nd\u00fcr\u00fcl\u00fcr. E\u011fer hi\u00e7bir ko\u015ful TRUE de\u011ferine ula\u015fmazsa, i\u015flev hata verir.<\/p>\n
Kullan\u0131m Senaryolar\u0131 ve \u00d6rnekler<\/h2>\n
\u0130\u015fte IFS<\/code> i\u015flevinin pratikte nas\u0131l kullan\u0131labilece\u011fine dair birka\u00e7 \u00f6rnek:<\/p>\n
\u00d6\u011frenci Notlar\u0131na G\u00f6re Harf De\u011ferlendirmesi<\/h2>\n
Bir \u00f6\u011fretmenin \u00f6\u011frencilerin s\u0131nav puanlar\u0131na g\u00f6re harf notu atamas\u0131 gerekiyor:<\/p>\n
IFS(A1>=90, \"A\", A1>=80, \"B\", A1>=70, \"C\", A1>=60, \"D\", TRUE, \"F\")<\/code><\/pre>\n
    \n
  • A1<\/code> h\u00fccresindeki puan 90 veya daha y\u00fcksekse “A”, 80 ile 89 aras\u0131ndaysa “B”, 70 ile 79 aras\u0131ndaysa “C”, 60 ile 69 aras\u0131ndaysa “D”, bunlar\u0131n alt\u0131ndaysa “F” harfi atanacakt\u0131r.<\/li>\n<\/ul>\n
    \u015eirket Sat\u0131\u015f Bonuslar\u0131<\/h2>\n
    Bir \u015firkette, \u00e7al\u0131\u015fanlar\u0131n elde ettikleri toplam sat\u0131\u015fa g\u00f6re bonus hesaplama i\u015flemi:<\/p>\n
    IFS(A1>=20000, \"500 Bonus\", A1>=15000, \"300 Bonus\", A1>=10000, \"200 Bonus\", A1<10000, \"Bonus Yok\")<\/code><\/pre>\n
      \n
    • Bu \u00f6rnekte A1<\/code> h\u00fccresindeki sat\u0131\u015f miktar\u0131na g\u00f6re \u00e7al\u0131\u015fan\u0131n alaca\u011f\u0131 bonus miktar\u0131 hesaplan\u0131r. 20,000 TL\u2019nin \u00fczerinde sat\u0131\u015f yapanlar 500 TL bonus, 15,000 ile 19,999 TL aras\u0131 olanlar 300 TL bonus, 10,000 ile 14,999 TL aras\u0131 olanlar 200 TL bonus al\u0131rken, 10,000 TL alt\u0131 sat\u0131\u015f yapanlar bonus almazlar.<\/li>\n<\/ul>\n
      \u0130\u015flevin Uygulamada Kullan\u0131lmas\u0131<\/h2>\n
      IFS<\/code> i\u015flevi, \u00f6zellikle birden fazla ko\u015fulun oldu\u011fu durumlarda ve bu ko\u015fullar\u0131n s\u0131ras\u0131na ba\u011fl\u0131 olarak farkl\u0131 \u00e7\u0131kt\u0131lar \u00fcretmek gerekti\u011finde olduk\u00e7a yararl\u0131d\u0131r. Bu i\u015flev sayesinde \u00f6nceden bir\u00e7ok farkl\u0131 IF<\/code> kullanmak zorunda kal\u0131nan yerlerde kod temizli\u011fi ve okunabilirli\u011fi artar.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Bir veya birden fazla ko\u015fulun kar\u015f\u0131lan\u0131p kar\u015f\u0131lanmad\u0131\u011f\u0131n\u0131 denetler ve ilk DO\u011eRU ko\u015fula kar\u015f\u0131l\u0131k gelen de\u011feri d\u00f6nd\u00fcr\u00fcr<\/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-15457","post","type-post","status-publish","format-standard","hentry","category-mantiksal"],"acf":[],"yoast_head":"\nExcel'de IFS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da IFS 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\/ifs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de IFS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da IFS 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\/ifs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:28:43+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 IFS 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\/ifs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/ifs\/\",\"name\":\"Excel'de IFS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:28:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da IFS 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\/ifs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/ifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/ifs\/#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\":\"IFS\"}]},{\"@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 IFS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da IFS 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\/ifs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de IFS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da IFS 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\/ifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:28:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de IFS 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\/ifs\/","url":"https:\/\/functiontranslator.com\/tr\/ifs\/","name":"Excel'de IFS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:28:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da IFS 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\/ifs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/ifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/ifs\/#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":"IFS"}]},{"@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\/15457","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=15457"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15457\/revisions"}],"predecessor-version":[{"id":27053,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15457\/revisions\/27053"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}