{"id":15500,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tekmi\/"},"modified":"2021-02-25T16:30:01","modified_gmt":"2021-02-25T16:30:01","slug":"isodd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/isodd\/","title":{"rendered":"TEKM\u0130"},"content":{"rendered":"

Microsoft Excel ve Google Tablolar, veri analizi ve hesaplama i\u015flemleri i\u00e7in kullan\u0131lan pop\u00fcler programlard\u0131r. Bu ara\u00e7larda \u00e7ok say\u0131da i\u015flev bulunmaktad\u0131r ve TEKM\u0130<\/strong> i\u015flevi bunlardan biridir. Bu i\u015flev, belirli bir say\u0131n\u0131n tek mi yoksa \u00e7ift mi oldu\u011funu kontrol etmek i\u00e7in kullan\u0131l\u0131r. E\u011fer say\u0131 tek ise TRUE<\/code> (DO\u011eRU), \u00e7ift ise FALSE<\/code> (YANLI\u015e) de\u011feri d\u00f6nd\u00fcr\u00fcr. Bu i\u015flev, veri setleri i\u00e7inde ko\u015fullu i\u015flemler ve analizler yapmak i\u00e7in s\u0131kl\u0131kla kullan\u0131l\u0131r.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi<\/h2>\n

TEKM\u0130(say\u0131)<\/code><\/p>\n

    \n
  • say\u0131<\/strong>: Teklik ya da \u00e7iftlik durumu kontrol edilecek olan say\u0131sal de\u011ferdir.<\/li>\n<\/ul>\n

    \u00d6rnek kullan\u0131m:<\/strong><\/p>\n

      =TEKM\u0130(5) \/\/ Sonu\u00e7: TRUE (\u00c7\u00fcnk\u00fc 5 tek bir say\u0131d\u0131r) =TEKM\u0130(2) \/\/ Sonu\u00e7: FALSE (\u00c7\u00fcnk\u00fc 2 \u00e7ift bir say\u0131d\u0131r) <\/code> <\/pre>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: S\u0131n\u0131f Listesindeki \u00d6\u011frencilere Tek\/\u00c7ift Numara Atamas\u0131<\/strong><\/p>\n
    \u00d6rne\u011fin, bir \u00f6\u011fretmen s\u0131n\u0131ftaki her \u00f6\u011frenciye tek veya \u00e7ift numaralar atayarak gruplar olu\u015fturmak istiyor. \u00d6\u011frencilerin listesi A s\u00fctununda ve numaralar\u0131 B s\u00fctununda olsun. C s\u00fctununda, \u00f6\u011frencinin numaras\u0131n\u0131n tek mi \u00e7ift mi oldu\u011funu belirleyebiliriz:<\/p>\n
      A B C Ali 1 =TEKM\u0130(B2) Ay\u015fe 2 =TEKM\u0130(B3) Can 3 =TEKM\u0130(B4) Deniz 4 =TEKM\u0130(B5) <\/code> <\/pre>\n
    B s\u00fctunu numaralar\u0131 \u00fczerinden i\u015flem yap\u0131larak C s\u00fctununda numaran\u0131n tek veya \u00e7ift oldu\u011fu bilgisi g\u00f6sterilmi\u015f olur. Bu bilgiye g\u00f6re gruplar olu\u015fturulabilir.<\/p>\n
    Senaryo 2: Faturalardaki \u0130\u015flem Numaralar\u0131n\u0131n Kontrol\u00fc<\/strong><\/p>\n
    Bir \u015firket, fatura i\u015flem numaralar\u0131n\u0131n tek seferlik mi yoksa d\u00fczenli mi olduklar\u0131n\u0131 s\u0131n\u0131fland\u0131rmak istiyor. D\u00fczenli i\u015flemler \u00e7ift, tek seferlik i\u015flemler tek numaraland\u0131r\u0131lm\u0131\u015f. Excel veya Google Tablolar kullanarak, bu s\u0131n\u0131fland\u0131rmay\u0131 h\u0131zl\u0131ca yapabiliriz:<\/p>\n
      A B Fatura1 101 Fatura2 204 Fatura3 303 Fatura4 410 =TEKM\u0130(B2) \/\/ Sonu\u00e7: TRUE, bu bir tek seferlik i\u015flem anlam\u0131na gelir. =TEKM\u0130(B3) \/\/ Sonu\u00e7: FALSE, bu d\u00fczenli bir i\u015flem anlam\u0131na gelir. <\/code> <\/pre>\n
    Bu iki \u00f6rnek, TEKM\u0130<\/strong> i\u015flevinin farkl\u0131 durumlarda nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir. \u0130\u015flevin d\u00fczg\u00fcn bir \u015fekilde uygulanmas\u0131, veri s\u0131n\u0131fland\u0131rma, analiz etme ve ko\u015fullu i\u015flemler yapma gibi i\u015flemleri kolayla\u015ft\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Say\u0131 tekse, DO\u011eRU verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[586],"tags":[],"class_list":["post-15500","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISODD (TEKM\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISODD (TEKM\u0130) 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\/isodd\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISODD (TEKM\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISODD (TEKM\u0130) 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\/isodd\/\" \/>\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:30:01+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 ISODD (TEKM\u0130) 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\/isodd\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/isodd\/\",\"name\":\"Excel'de ISODD (TEKM\u0130) 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:30:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISODD (TEKM\u0130) 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\/isodd\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/isodd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/isodd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bilgi\",\"item\":\"https:\/\/functiontranslator.com\/tr\/bilgi\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TEKM\u0130\"}]},{\"@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 ISODD (TEKM\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISODD (TEKM\u0130) 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\/isodd\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISODD (TEKM\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISODD (TEKM\u0130) 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\/isodd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:30:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISODD (TEKM\u0130) 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\/isodd\/","url":"https:\/\/functiontranslator.com\/tr\/isodd\/","name":"Excel'de ISODD (TEKM\u0130) 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:30:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISODD (TEKM\u0130) 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\/isodd\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/isodd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/isodd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Bilgi","item":"https:\/\/functiontranslator.com\/tr\/bilgi\/"},{"@type":"ListItem","position":3,"name":"TEKM\u0130"}]},{"@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\/15500","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=15500"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15500\/revisions"}],"predecessor-version":[{"id":26768,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15500\/revisions\/26768"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}