{"id":15258,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/ve\/"},"modified":"2021-02-25T16:22:02","modified_gmt":"2021-02-25T16:22:02","slug":"and","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/and\/","title":{"rendered":"VE"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi i\u00e7in s\u0131kl\u0131kla ba\u015fvurulan g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Her iki platformda da bulunan “AND” fonksiyonu, birden fazla ko\u015fulun t\u00fcm\u00fcn\u00fcn sa\u011flan\u0131p sa\u011flanmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in kullan\u0131l\u0131r. E\u011fer t\u00fcm ko\u015fullar do\u011fru ise, fonksiyon TRUE (DO\u011eRU) de\u011feri d\u00f6nd\u00fcr\u00fcr; ancak herhangi bir ko\u015ful yanl\u0131\u015fsa, FALSE (YANLI\u015e) de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve \u00d6rnekleri<\/h2>\n

AND fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=AND(logical1, [logical2], ...)<\/code><\/pre>\n
“logical1”, “logical2” vb. arg\u00fcmanlar, de\u011ferlendirilmesi gereken mant\u0131ksal ifadelerdir. En az bir mant\u0131ksal arg\u00fcman gereklidir, ancak fonksiyonun yetene\u011fini art\u0131rmak i\u00e7in daha fazla arg\u00fcman eklemek m\u00fcmk\u00fcnd\u00fcr.<\/p>\n
    \n
  • \n
    \u00d6rnek 1:<\/strong> \u00dc\u00e7 farkl\u0131 h\u00fccredeki say\u0131lar\u0131n (A1, A2, A3) 10’dan b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in:<\/p>\n
    =AND(A1>10, A2>10, A3>10)<\/code><\/pre>\n
    E\u011fer A1, A2 ve A3 h\u00fccrelerindeki t\u00fcm say\u0131lar 10’dan b\u00fcy\u00fckseniz, bu form\u00fcl DO\u011eRU olarak de\u011ferlendirilir.<\/p>\n<\/li>\n
  • \n
    \u00d6rnek 2:<\/strong> Bir \u00f6\u011frencinin dersten ge\u00e7me durumunu kontrol etmek i\u00e7in (A1’deki puan ve A2’deki kat\u0131l\u0131m durumu dikkate al\u0131narak):<\/p>\n
    =AND(A1>=60, A2=\"Evet\")<\/code><\/pre>\n
    E\u011fer \u00f6\u011frenci hem 60 veya daha y\u00fcksek bir puan alm\u0131\u015fsa ve ayn\u0131 zamanda kat\u0131l\u0131m durumu “Evet” ise, bu form\u00fcl DO\u011eRU de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p>\n<\/li>\n<\/ul>\n
    Pratik Kullan\u0131mlar<\/h2>\n
    AND fonksiyonu, karar alma s\u00fcre\u00e7lerinde ve ko\u015fullu de\u011ferlendirmelerde etkili bir \u015fekilde kullan\u0131labilir. \u0130\u015fte birka\u00e7 uygulama \u00f6rne\u011fi:<\/p>\n
    Durum 1: Proje Onay\u0131<\/h2>\n
    Bir kurulu\u015fta projelerin onaylanmas\u0131 i\u00e7in gereken baz\u0131 kriterler bulunabilir. \u00d6rne\u011fin, bir projenin A, B, ve C fazlar\u0131n\u0131n her birinin onaylanmas\u0131 zorunludur.<\/p>\n
    =AND(A1=\"Onayland\u0131\", B1=\"Onayland\u0131\", C1=\"Onayland\u0131\")<\/code><\/pre>\n
    E\u011fer A1, B1 ve C1 h\u00fccreleri “Onayland\u0131” olarak i\u015faretlenmi\u015fse, bu form\u00fcl t\u00fcm fazlar\u0131n onayland\u0131\u011f\u0131n\u0131 g\u00f6sterir ve DO\u011eRU sonucu verir.<\/p>\n
    Durum 2: \u0130ndirimli Sat\u0131\u015f Ko\u015fullar\u0131<\/h2>\n
    Bir \u015firket, \u00fcr\u00fcnlerinde indirim yap\u0131labilmesi i\u00e7in belirli kriterler belirleyebilir; \u00f6rne\u011fin stok miktar\u0131 ve piyasada kalma s\u00fcresi.<\/p>\n
    =AND(A1>100, B1>365)<\/code><\/pre>\n
    E\u011fer \u00fcr\u00fcn\u00fcn stok miktar\u0131 (A1) 100’den fazla ve piyasada kalma s\u00fcresi (B1) 365 g\u00fcnden fazla ise, bu ko\u015fullar kar\u015f\u0131lanm\u0131\u015f say\u0131l\u0131r ve form\u00fcl DO\u011eRU olarak de\u011ferlendirilir, b\u00f6ylece indirim uygulanabilir.<\/p>\n
    Yukar\u0131da verilen \u00f6rnekler, AND fonksiyonunun birden fazla ko\u015fulu ayn\u0131 anda test etme yetene\u011fini ve veri analizi ile i\u015f ak\u0131\u015f\u0131 y\u00f6netimindeki \u00f6nemini vurgulamaktad\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    T\u00fcm ba\u011f\u0131ms\u0131z de\u011fi\u015fkenleri 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-15258","post","type-post","status-publish","format-standard","hentry","category-mantiksal"],"acf":[],"yoast_head":"\nExcel'de AND (VE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da AND (VE) 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\/and\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de AND (VE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da AND (VE) 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\/and\/\" \/>\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:22:02+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 AND (VE) 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\/and\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/and\/\",\"name\":\"Excel'de AND (VE) 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:22:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da AND (VE) 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\/and\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/and\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/and\/#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\":\"VE\"}]},{\"@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 AND (VE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da AND (VE) 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\/and\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de AND (VE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da AND (VE) 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\/and\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:22:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de AND (VE) 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\/and\/","url":"https:\/\/functiontranslator.com\/tr\/and\/","name":"Excel'de AND (VE) 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:22:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da AND (VE) 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\/and\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/and\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/and\/#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":"VE"}]},{"@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\/15258","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=15258"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15258\/revisions"}],"predecessor-version":[{"id":26526,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15258\/revisions\/26526"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}