{"id":3738,"date":"2023-07-15T20:21:56","date_gmt":"2023-07-15T20:21:56","guid":{"rendered":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/"},"modified":"2023-07-15T20:21:56","modified_gmt":"2023-07-15T20:21:56","slug":"fonksiyon-evet-veya-hayir-ise-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/","title":{"rendered":"Excel: evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir e\u011fer i\u015flevi nas\u0131l olu\u015fturulur"},"content":{"rendered":"

<\/p>\n

\n

Excel’de “Evet” veya “Hay\u0131r” sonucunu d\u00f6nd\u00fcren bir E\u011eER i\u015flevi olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n

 =IF( A2<\/span> >= B2<\/span> , \"Yes\", \"No\")<\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl i\u00e7in, A2<\/strong> h\u00fccresinin de\u011feri B2<\/strong> h\u00fccresinin de\u011ferinden b\u00fcy\u00fck veya ona e\u015fitse i\u015flev “Evet” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 Aksi halde “Hay\u0131r” sonucunu d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekler bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n
 \u00d6rnek: Excel’de Evet veya Hay\u0131r de\u011ferini d\u00f6nd\u00fcrecek bir E\u011eER \u0130\u015flevi olu\u015fturma<\/strong><\/span><\/h2>\n
 Excel’de on farkl\u0131 \u00fcr\u00fcn i\u00e7in sat\u0131\u015f ve sat\u0131\u015f hedeflerini g\u00f6r\u00fcnt\u00fcleyen a\u015fa\u011f\u0131daki iki s\u00fctuna sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 A2<\/strong> h\u00fccresindeki sat\u0131\u015f say\u0131s\u0131, B2<\/strong> h\u00fccresindeki sat\u0131\u015f hedefine e\u015fit veya ondan b\u00fcy\u00fckse “Evet” sonucunu d\u00f6nd\u00fcrmek i\u00e7in C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =IF( A2<\/span> >= B2<\/span> , \"Yes\", \"No\")<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyip doldurabiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 Form\u00fcl, A s\u00fctunundaki sat\u0131\u015f de\u011ferinin B s\u00fctunundaki sat\u0131\u015f hedefinden b\u00fcy\u00fck veya ona e\u015fit olmas\u0131na ba\u011fl\u0131 olarak “Evet” veya “Hay\u0131r” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 IF fonksiyonunun ilk arg\u00fcman\u0131na istedi\u011finiz herhangi bir mant\u0131ksal testi yerle\u015ftirebilece\u011finizi unutmay\u0131n.<\/span><\/p>\n
 \u00d6rne\u011fin, A2<\/strong> ve B2<\/strong> h\u00fccrelerindeki de\u011ferlerin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in <><\/strong> komutunu kullanabilir ve e\u015fit de\u011filse “Evet”, e\u015fitse “Hay\u0131r” sonucunu d\u00f6nd\u00fcrebilirsiniz:<\/span><\/p>\n
 =IF( A2<\/span> <> B2<\/span> , \"Yes\", \"No\")<\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyip doldurabiliriz:<\/span> <\/p>\n
\"\"<\/p>\n
 Sat\u0131\u015f ve sat\u0131\u015f hedefleri e\u015fit de\u011filse form\u00fcl “Evet” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 Aksi takdirde, sat\u0131\u015f ve sat\u0131\u015f hedefleri e\u015fitse form\u00fcl “Hay\u0131r” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 Test etmek istedi\u011finiz ko\u015fula ba\u011fl\u0131 olarak IF fonksiyonunun ilk arg\u00fcman\u0131nda istedi\u011finiz mant\u0131k testini kullanmaktan \u00e7ekinmeyin.<\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n
 Excel: 3 ko\u015fullu bir E\u011eER i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/a>
 Excel: Bir De\u011fer Aral\u0131\u011f\u0131yla E\u011eER \u0130\u015flevi Nas\u0131l Kullan\u0131l\u0131r<\/a>
 Excel: tarihlerle birlikte E\u011eER i\u015flevi nas\u0131l kullan\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Excel’de “Evet” veya “Hay\u0131r” sonucunu d\u00f6nd\u00fcren bir E\u011eER i\u015flevi olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz: =IF( A2 >= B2 , “Yes”, “No”) Bu \u00f6zel form\u00fcl i\u00e7in, A2 h\u00fccresinin de\u011feri B2 h\u00fccresinin de\u011ferinden b\u00fcy\u00fck veya ona e\u015fitse i\u015flev “Evet” de\u011ferini d\u00f6nd\u00fcr\u00fcr. Aksi halde “Hay\u0131r” sonucunu d\u00f6nd\u00fcr\u00fcr. A\u015fa\u011f\u0131daki \u00f6rnekler bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. \u00d6rnek: Excel’de […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3738","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel: Evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir E\u011eER i\u015flevi nas\u0131l olu\u015fturulur - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel'de Evet veya Hay\u0131r d\u00f6nd\u00fcren bir E\u011eER i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir E\u011eER i\u015flevi nas\u0131l olu\u015fturulur - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel'de Evet veya Hay\u0131r d\u00f6nd\u00fcren bir E\u011eER i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T20:21:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifexcel1.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\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:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/\",\"name\":\"Excel: Evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir E\u011eER i\u015flevi nas\u0131l olu\u015fturulur - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-15T20:21:56+00:00\",\"dateModified\":\"2023-07-15T20:21:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel'de Evet veya Hay\u0131r d\u00f6nd\u00fcren bir E\u011eER i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir e\u011fer i\u015flevi nas\u0131l olu\u015fturulur\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir E\u011eER i\u015flevi nas\u0131l olu\u015fturulur - Statorials","description":"Bu e\u011fitimde, Excel'de Evet veya Hay\u0131r d\u00f6nd\u00fcren bir E\u011eER i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir E\u011eER i\u015flevi nas\u0131l olu\u015fturulur - Statorials","og_description":"Bu e\u011fitimde, Excel'de Evet veya Hay\u0131r d\u00f6nd\u00fcren bir E\u011eER i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-15T20:21:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifexcel1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/","url":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/","name":"Excel: Evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir E\u011eER i\u015flevi nas\u0131l olu\u015fturulur - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-15T20:21:56+00:00","dateModified":"2023-07-15T20:21:56+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel'de Evet veya Hay\u0131r d\u00f6nd\u00fcren bir E\u011eER i\u015flevinin nas\u0131l olu\u015fturulaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/fonksiyon-evet-veya-hayir-ise-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: evet veya hay\u0131r d\u00f6nd\u00fcrmek i\u00e7in bir e\u011fer i\u015flevi nas\u0131l olu\u015fturulur"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=3738"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3738\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}