{"id":15454,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/eger\/"},"modified":"2021-02-25T16:28:38","modified_gmt":"2021-02-25T16:28:38","slug":"if","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/if\/","title":{"rendered":"E\u011eER"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Ko\u015fullu Hesaplamalar<\/h2>\n

Microsoft Excel ve Google E-Tablolar, veri analizinde \u00f6nemli ara\u00e7lard\u0131r ve her iki platform da IF fonksiyonunu destekler. Bu fonksiyon, belirli bir ko\u015fula ba\u011fl\u0131 olarak farkl\u0131 hesaplamalar yapman\u0131za olanak sa\u011flar. IF fonksiyonu, belirtilen bir ko\u015fulun do\u011fru (TRUE) ya da yanl\u0131\u015f (FALSE) olmas\u0131na ba\u011fl\u0131 olarak iki farkl\u0131 sonu\u00e7 \u00fcretir.<\/p>\n

Fonksiyonun S\u00f6zdizimi<\/h2>\n

IF fonksiyonunun genel yap\u0131s\u0131 \u015fu \u015fekildedir:<\/p>\n

  IF(logical_test, value_if_true, value_if_false) <\/code> <\/pre>\n
    \n
  • logical_test:<\/strong> Test edilecek ko\u015ful veya ifade.<\/li>\n
  • value_if_true:<\/strong> Ko\u015ful do\u011fru ise d\u00f6nd\u00fcr\u00fclecek de\u011fer.<\/li>\n
  • value_if_false:<\/strong> Ko\u015ful yanl\u0131\u015f ise d\u00f6nd\u00fcr\u00fclecek de\u011fer.<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, bir \u00f6\u011frencinin s\u0131navdan ald\u0131\u011f\u0131 notuna g\u00f6re ge\u00e7ip ge\u00e7medi\u011fini belirlemek i\u00e7in a\u015fa\u011f\u0131daki gibi bir formula kullanabiliriz:<\/p>\n
      IF(A1>=50, \"Ge\u00e7ti\", \"Kald\u0131\") <\/code> <\/pre>\n
    Burada A1 h\u00fccresindeki not 50 veya \u00fczeri ise “Ge\u00e7ti” de\u011filse “Kald\u0131” yazacakt\u0131r.<\/p>\n
    G\u00fcnl\u00fck \u0130\u015f Ak\u0131\u015f\u0131nda IF Kullan\u0131m\u0131<\/h2>\n
    IF fonksiyonu, \u00e7ok \u00e7e\u015fitli durumlarda kullan\u0131labilir. \u0130\u015fte iki pratik \u00f6rnek:<\/p>\n
    B\u00fct\u00e7e Planlamas\u0131<\/h3>\n
    Bir \u015firketin y\u0131ll\u0131k sat\u0131\u015f b\u00fct\u00e7esini de\u011ferlendirdi\u011fini d\u00fc\u015f\u00fcnelim. E\u011fer y\u0131ll\u0131k sat\u0131\u015f 500.000 TL\u2019den fazla ise bonus olarak %10, aksi halde %5 bonus hesaplanmas\u0131 gerekiyor. Bunun i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<\/p>\n
      IF(B1>500000, B1*0.10, B1*0.05) <\/code> <\/pre>\n
    Burada B1 h\u00fccresi y\u0131ll\u0131k sat\u0131\u015f tutar\u0131n\u0131 belirtir ve bu tutar 500.000 TL\u2019den b\u00fcy\u00fckse sat\u0131\u015f tutar\u0131n\u0131n %10’u, de\u011filse %5’i hesaplan\u0131r.<\/p>\n
    \u00c7al\u0131\u015fan Performans De\u011ferlendirmesi<\/h3>\n
    Bir i\u015fletmenin \u00e7al\u0131\u015fan performans\u0131n\u0131 de\u011ferlendirdi\u011fi bir sistem oldu\u011funu varsayal\u0131m. Performans skoru 80 \u00fczerinde olan \u00e7al\u0131\u015fanlar i\u00e7in “M\u00fckemmel”, 60-79 aras\u0131 i\u00e7in “\u0130yi”, bunun alt\u0131nda kalanlar i\u00e7in “Daha Fazla \u00c7al\u0131\u015fmal\u0131” ifadelerinin kullan\u0131lmas\u0131 gerekebilir. IF fonksiyonu ile:<\/p>\n
      IF(C1>=80, \"M\u00fckemmel\", IF(C1>=60, \"\u0130yi\", \"Daha Fazla \u00c7al\u0131\u015fmal\u0131\")) <\/code> <\/pre>\n
    Bu \u00f6rnekte C1 h\u00fccresindeki performans skoru kontrol edilir. 80 ve \u00fczeri i\u00e7in “M\u00fckemmel”, 60-79 aras\u0131 i\u00e7in “\u0130yi”, 60’dan d\u00fc\u015f\u00fck ise “Daha Fazla \u00c7al\u0131\u015fmal\u0131” sonucunu verir.<\/p>\n
    IF fonksiyonu, basit ve anla\u015f\u0131l\u0131r yap\u0131s\u0131yla, veriler \u00fczerinde ko\u015fullu i\u015flemler yapman\u0131z\u0131 sa\u011flamakta ve kar\u015f\u0131la\u015ft\u0131\u011f\u0131n\u0131z \u00e7ok \u00e7e\u015fitli durumlar i\u00e7in esnek \u00e7\u00f6z\u00fcmler sunmaktad\u0131r. Bu fonksiyon sayesinde verilerinizi daha etkili ve h\u0131zl\u0131 bir \u015fekilde analiz edebilir, raporlar\u0131n\u0131z\u0131 daha i\u015flevsel hale getirebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ger\u00e7ekle\u015ftirilecek bir mant\u0131ksal s\u0131nama belirtir<\/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-15454","post","type-post","status-publish","format-standard","hentry","category-mantiksal"],"acf":[],"yoast_head":"\nExcel'de IF (E\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da IF (E\u011eER) 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\/if\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de IF (E\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da IF (E\u011eER) 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\/if\/\" \/>\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:28:38+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 IF (E\u011eER) 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\/if\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/if\/\",\"name\":\"Excel'de IF (E\u011eER) 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:28:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da IF (E\u011eER) 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\/if\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/if\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/if\/#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\":\"E\u011eER\"}]},{\"@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 IF (E\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da IF (E\u011eER) 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\/if\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de IF (E\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da IF (E\u011eER) 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\/if\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:28:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de IF (E\u011eER) 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\/if\/","url":"https:\/\/functiontranslator.com\/tr\/if\/","name":"Excel'de IF (E\u011eER) 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:28:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da IF (E\u011eER) 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\/if\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/if\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/if\/#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":"E\u011eER"}]},{"@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\/15454","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=15454"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15454\/revisions"}],"predecessor-version":[{"id":26722,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15454\/revisions\/26722"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}