{"id":4654,"date":"2023-07-09T06:52:35","date_gmt":"2023-07-09T06:52:35","guid":{"rendered":"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/"},"modified":"2023-07-09T06:52:35","modified_gmt":"2023-07-09T06:52:35","slug":"uzunluk-bundan-buyukse-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/","title":{"rendered":"Excel: "uzunluk a\u015fa\u011f\u0131dakilerden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl"},"content":{"rendered":"

<\/p>\n

\n

Belirli bir h\u00fccredeki dizenin belirli bir uzunluktan b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in Excel’de a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =IF(LEN( A2<\/span> )>4,\"Greater than 4\",\"Not Greater than 4\")\n<\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl, A2<\/strong> h\u00fccresindeki dize uzunlu\u011funun 4’ten b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve e\u011fer \u00f6yleyse “4’ten b\u00fcy\u00fck” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 Aksi halde form\u00fcl “4’ten b\u00fcy\u00fck de\u011fil” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n
 \u00d6rnek: H\u00fccrenin belirli bir de\u011ferden daha uzun bir dize i\u00e7erip i\u00e7ermedi\u011fini kontrol edin<\/strong><\/span><\/h2>\n
 Excel’de \u00e7e\u015fitli basketbol tak\u0131mlar\u0131 hakk\u0131nda bilgi i\u00e7eren a\u015fa\u011f\u0131daki dize s\u00fctununa sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 Tak\u0131m s\u00fctunundaki her bir dizenin uzunlu\u011funun 4’ten b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n
 =IF(LEN( A2<\/span> )>4,\"Greater than 4\",\"Not Greater than 4\")<\/strong><\/pre>\n
 Bu form\u00fcl\u00fc B2<\/strong> h\u00fccresine girece\u011fiz, ard\u0131ndan onu t\u0131klay\u0131p B s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyece\u011fiz:<\/span> <\/p>\n
\"\"<\/p>\n
 B s\u00fctunundaki her h\u00fccre, A s\u00fctunundaki ilgili dizenin uzunlu\u011funun 4’ten b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 bize bildiren bir dize d\u00f6nd\u00fcr\u00fcr.<\/span><\/span><\/p>\n
 Ayr\u0131ca istersek stringler d\u0131\u015f\u0131nda de\u011ferler de d\u00f6nd\u00fcrebilece\u011fimizi unutmay\u0131n.<\/span><\/p>\n
 \u00d6rne\u011fin, dize uzunlu\u011fu 4’ten b\u00fcy\u00fckse dizenin yaln\u0131zca ilk 4 karakterini d\u00f6nd\u00fcrmek veya aksi durumda “FALSE” de\u011ferini d\u00f6nd\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n
 =IF(LEN( A2<\/span> )>4,LEFT( A2,4<\/span> ),\"FALSE\")<\/strong><\/pre>\n
 Bu form\u00fcl\u00fc B2<\/strong> h\u00fccresine girece\u011fiz, ard\u0131ndan onu t\u0131klay\u0131p B s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyece\u011fiz:<\/span> <\/p>\n
\"\"<\/p>\n
 A s\u00fctunundaki dizenin uzunlu\u011fu 4’ten b\u00fcy\u00fckse, B s\u00fctununda dizenin yaln\u0131zca ilk 4 karakteri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/span><\/p>\n
 Aksi halde, A s\u00fctunundaki dizenin uzunlu\u011fu 4’ten b\u00fcy\u00fck de\u011filse, B s\u00fctununda FALSE de\u011ferini d\u00f6nd\u00fcr\u00fcr\u00fcz.<\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer genel g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n
 Excel: h\u00fccrenin liste metni i\u00e7erip i\u00e7ermedi\u011fini kontrol etme<\/a>
 Excel: h\u00fccre metin i\u00e7eriyorsa ortalama nas\u0131l hesaplan\u0131r<\/a>
 Excel: Aral\u0131\u011f\u0131n belirli bir de\u011fer i\u00e7erip i\u00e7ermedi\u011fi nas\u0131l kontrol edilir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Belirli bir h\u00fccredeki dizenin belirli bir uzunluktan b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in Excel’de a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =IF(LEN( A2 )>4,”Greater than 4″,”Not Greater than 4″) Bu \u00f6zel form\u00fcl, A2 h\u00fccresindeki dize uzunlu\u011funun 4’ten b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve e\u011fer \u00f6yleyse “4’ten b\u00fcy\u00fck” de\u011ferini d\u00f6nd\u00fcr\u00fcr. Aksi halde form\u00fcl “4’ten b\u00fcy\u00fck de\u011fil” de\u011ferini d\u00f6nd\u00fcr\u00fcr. A\u015fa\u011f\u0131daki \u00f6rnekte […]<\/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-4654","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel: "Uzunluk \u015fu de\u011ferden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde Excel'de "uzunluk \u015fundan b\u00fcy\u00fckse" form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131 birka\u00e7 \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\/uzunluk-bundan-buyukse-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: "Uzunluk \u015fu de\u011ferden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde Excel'de "uzunluk \u015fundan b\u00fcy\u00fckse" form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T06:52:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifg1.png\" \/>\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\/uzunluk-bundan-buyukse-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/\",\"name\":\"Excel: "Uzunluk \u015fu de\u011ferden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-09T06:52:35+00:00\",\"dateModified\":\"2023-07-09T06:52:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde Excel'de "uzunluk \u015fundan b\u00fcy\u00fckse" form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: "uzunluk a\u015fa\u011f\u0131dakilerden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl\"}]},{\"@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: "Uzunluk \u015fu de\u011ferden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl - Statoryaller","description":"Bu e\u011fitimde Excel'de "uzunluk \u015fundan b\u00fcy\u00fckse" form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131 birka\u00e7 \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\/uzunluk-bundan-buyukse-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: "Uzunluk \u015fu de\u011ferden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl - Statoryaller","og_description":"Bu e\u011fitimde Excel'de "uzunluk \u015fundan b\u00fcy\u00fckse" form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-09T06:52:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifg1.png"}],"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\/uzunluk-bundan-buyukse-excel\/","url":"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/","name":"Excel: "Uzunluk \u015fu de\u011ferden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-09T06:52:35+00:00","dateModified":"2023-07-09T06:52:35+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde Excel'de "uzunluk \u015fundan b\u00fcy\u00fckse" form\u00fcl\u00fcn\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/uzunluk-bundan-buyukse-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: "uzunluk a\u015fa\u011f\u0131dakilerden b\u00fcy\u00fckse" i\u00e7in basit bir form\u00fcl"}]},{"@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\/4654","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=4654"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4654\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}