{"id":15576,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yada\/"},"modified":"2021-02-25T16:33:17","modified_gmt":"2021-02-25T16:33:17","slug":"or","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/or\/","title":{"rendered":"YADA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, i\u015f ve e\u011fitim ama\u00e7lar\u0131 i\u00e7in geni\u015f kapsaml\u0131 hesaplama ve veri analizi olanaklar\u0131 sunan pop\u00fcler elektronik tablo uygulamalar\u0131d\u0131r. Bu yaz\u0131da, bu iki platformda bulunan “OR” (YADA) fonksiyonunun kullan\u0131m\u0131n\u0131, s\u00f6zdizimini ve bu fonksiyonla \u00e7\u00f6z\u00fclebilecek tipik problemleri inceleyece\u011fiz.<\/p>\n

YADA Fonksiyonunun Tan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

“OR” (YADA) fonksiyonu, verilen arg\u00fcmanlardan en az birinin DO\u011eRU (TRUE) olup olmad\u0131\u011f\u0131n\u0131 test eder. Arg\u00fcmanlardan biri bile DO\u011eRU ise, fonksiyonun sonucu DO\u011eRU olarak d\u00f6ner; t\u00fcm arg\u00fcmanlar YANLI\u015e (FALSE) ise, sonu\u00e7 YANLI\u015e olur.<\/p>\n

 OR(logical1, [logical2], ...) <\/code><\/pre>\n
Burada logical1<\/code>, logical2<\/code>, … mant\u0131ksal ifadelerdir ve fonksiyon, bu ifadelerin en az birinin DO\u011eRU olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirir.<\/p>\n
Arg\u00fcmanlar\u0131n Tan\u0131m\u0131 ve \u00d6zellikleri<\/h2>\n
    \n
  • logical1<\/code>, logical2<\/code>, …: Bunlar, DO\u011eRU veya YANLI\u015e sonu\u00e7 verebilecek arg\u00fcmanlard\u0131r. Excel ve Google Sheets’te bu arg\u00fcmanlar do\u011frudan DO\u011eRU\/YANLI\u015e de\u011ferler, mant\u0131ksal testler veya bu testlerin sonu\u00e7lar\u0131n\u0131 \u00fcreten di\u011fer fonksiyonlar olabilir.<\/li>\n<\/ul>\n
    Basit Uygulama \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Bir \u00f6\u011frencinin s\u0131navlardan birinden ge\u00e7ip ge\u00e7medi\u011fini kontrol edin:<\/p>\n
     =OR(A1>=50, B1>=50) <\/code><\/pre>\n
    Bu form\u00fcl, A1 h\u00fccresindeki ve B1 h\u00fccresindeki s\u0131nav puanlar\u0131n\u0131n herhangi birinin 50 veya \u00fczeri olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. Herhangi bir s\u0131nav puan\u0131 50 veya \u00fczeri ise, sonu\u00e7 DO\u011eRU olarak d\u00f6ner.<\/p>\n
    \u00d6rnek 2: \u00c7al\u0131\u015fan\u0131n bonus al\u0131p alamayaca\u011f\u0131n\u0131 kontrol edin:<\/p>\n
     =OR(A1>1000, B1>=90, C1=\"Evet\") <\/code><\/pre>\n
    Bu form\u00fcl, A1 h\u00fccresindeki sat\u0131\u015f miktar\u0131n\u0131n 1000’den y\u00fcksek, B1 h\u00fccresindeki performans puan\u0131n\u0131n 90’dan y\u00fcksek olmas\u0131 veya C1 h\u00fccresindeki ek criteria’n\u0131n “Evet” olmas\u0131 durumunda, \u00e7al\u0131\u015fan\u0131n bonus almaya hak kazand\u0131\u011f\u0131n\u0131 belirtir.<\/p>\n
    Karma\u015f\u0131k Sistemler \u0130\u00e7in Uygulama Senaryolar\u0131<\/h2>\n\n\n\n\n
    Senaryo<\/th>\nKullan\u0131m<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
    Proje De\u011ferlendirmesi<\/td>\n\n
    =OR(A1=\"Tamamland\u0131\", B1=\"Tamamland\u0131\")<\/code><\/pre>\n<\/td>\n
    		Projenin A veya B a\u015famalar\u0131ndan herhangi birinin “Tamamland\u0131” olarak i\u015faretlenmi\u015f olmas\u0131, projenin tamamlanm\u0131\u015f say\u0131lmas\u0131na yeterlidir.<\/td>\n<\/tr>\n
    \u00dcr\u00fcn Kontrol\u00fc<\/td>\n\n
    =OR(A1>100, B1<10)<\/code><\/pre>\n<\/td>\n
    		\u00dcr\u00fcn stok miktar\u0131n\u0131n 100'den fazla olmas\u0131 veya \u00fcr\u00fcnde hata say\u0131s\u0131n\u0131n 10'dan az olmas\u0131 durumunda, \u00fcr\u00fcn durumu iyi olarak de\u011ferlendirilir.<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
    Ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerden herhangi birisi DO\u011eRU ise, 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":[580],"tags":[],"class_list":["post-15576","post","type-post","status-publish","format-standard","hentry","category-mantiksal"],"acf":[],"yoast_head":"\nExcel'de OR (YADA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da OR (YADA) 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\/or\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de OR (YADA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da OR (YADA) 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\/or\/\" \/>\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:33:17+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 OR (YADA) 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\/or\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/or\/\",\"name\":\"Excel'de OR (YADA) 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:33:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da OR (YADA) 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\/or\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/or\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/or\/#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\":\"YADA\"}]},{\"@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 OR (YADA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da OR (YADA) 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\/or\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de OR (YADA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da OR (YADA) 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\/or\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de OR (YADA) 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\/or\/","url":"https:\/\/functiontranslator.com\/tr\/or\/","name":"Excel'de OR (YADA) 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:33:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da OR (YADA) 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\/or\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/or\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/or\/#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":"YADA"}]},{"@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\/15576","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=15576"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15576\/revisions"}],"predecessor-version":[{"id":26844,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15576\/revisions\/26844"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}