{"id":15491,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ebossa\/"},"modified":"2021-02-25T16:29:47","modified_gmt":"2021-02-25T16:29:47","slug":"isblank","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/isblank\/","title":{"rendered":"EBO\u015eSA"},"content":{"rendered":"<h2>H\u00fccrelerin Bo\u015f Olup Olmad\u0131\u011f\u0131n\u0131 Kontrol Etme<\/h2>\n<p><code>ISBLANK<\/code> veya T\u00fcrk\u00e7e ismiyle <code>EBO\u015eSA<\/code>, hem Microsoft Excel hem de Google E-Tablolar&#8217;da kullanabilece\u011finiz bir fonksiyondur. Bu i\u015flev, belirli bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve sonu\u00e7 olarak TRUE (Do\u011fru) veya FALSE (Yanl\u0131\u015f) d\u00f6nd\u00fcr\u00fcr. H\u00fccre tamamen bo\u015f ise TRUE, herhangi bir de\u011fer (metin, say\u0131, hata de\u011feri veya form\u00fcl bile olsa) i\u00e7eriyorsa FALSE de\u011ferini verir.<\/p>\n<h2>S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n<p>Fonksiyonun kullan\u0131m\u0131 \u00e7ok basittir. S\u00f6z dizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre><code>ISBLANK(h\u00fccre_referans\u0131)<\/code><\/pre>\n<p>\u00d6rnek kullan\u0131m:<\/p>\n<pre><code>=ISBLANK(A1)<\/code><\/pre>\n<p>E\u011fer A1 h\u00fccresi bo\u015fsa, bu form\u00fcl TRUE de\u011ferini d\u00f6nd\u00fcr\u00fcr. A1 h\u00fccresinde herhangi bir de\u011fer varsa, FALSE d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h2>Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n<h3>Data Temizli\u011fi<\/h3>\n<p>Bir veri setindeki bo\u015f de\u011ferleri tespit etmek ve saymak i\u00e7in <code>ISBLANK<\/code> fonksiyonunu kullanabilirsiniz. \u00d6rne\u011fin, A s\u00fctunundaki bo\u015f olmayan h\u00fccre say\u0131s\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p>\n<pre><code>=COUNTIF(A:A, NOT(ISBLANK(A1)))<\/code><\/pre>\n<p>Bu form\u00fcl, A s\u00fctununda bo\u015f olmayan h\u00fccrelerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h3>Ko\u015fullu Bi\u00e7imlendirme<\/h3>\n<p>Excel veya Google E-Tablolar&#8217;da bo\u015f h\u00fccreleri vurgulamak i\u00e7in <code>ISBLANK<\/code> fonksiyonunu ko\u015fullu bi\u00e7imlendirme ile kullanabilirsiniz. \u00d6rne\u011fin, t\u00fcm bo\u015f h\u00fccreleri k\u0131rm\u0131z\u0131yla vurgulamak i\u00e7in:<\/p>\n<ol>\n<li>Ko\u015fullu bi\u00e7imlendirme men\u00fcs\u00fcn\u00fc a\u00e7\u0131n.<\/li>\n<li>&#8216;Yeni Kural&#8217; se\u00e7ene\u011fini se\u00e7in ve &#8216;Form\u00fcl\u00fc kullan&#8217; opsiyonunu belirleyin.<\/li>\n<li>A\u015fa\u011f\u0131daki form\u00fcl\u00fc girin:<\/li>\n<pre><code>=ISBLANK(A1)<\/code><\/pre>\n<li>Uygulanacak format\u0131 se\u00e7in (\u00f6rne\u011fin, h\u00fccre rengini k\u0131rm\u0131z\u0131 olarak ayarlay\u0131n).<\/li>\n<li>&#8216;Tamam&#8217; diyerek ayarlar\u0131 onaylay\u0131n.<\/li>\n<\/ol>\n<p>Bu y\u00f6ntem, veri setinizdeki bo\u015f h\u00fccreleri h\u0131zl\u0131ca tespit etmenize ve g\u00f6rsel olarak ay\u0131rt etmenize yard\u0131mc\u0131 olur.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>De\u011fer bo\u015fsa, 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-15491","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de ISBLANK (EBO\u015eSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da ISBLANK (EBO\u015eSA) 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\/isblank\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ISBLANK (EBO\u015eSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da ISBLANK (EBO\u015eSA) 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\/isblank\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de ISBLANK (EBO\u015eSA) 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\/isblank\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/isblank\/\",\"name\":\"Excel'de ISBLANK (EBO\u015eSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:29:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISBLANK (EBO\u015eSA) 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\/isblank\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/isblank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/isblank\/#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\":\"EBO\u015eSA\"}]},{\"@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 ISBLANK (EBO\u015eSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISBLANK (EBO\u015eSA) 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\/isblank\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISBLANK (EBO\u015eSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISBLANK (EBO\u015eSA) 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\/isblank\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISBLANK (EBO\u015eSA) 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\/isblank\/","url":"https:\/\/functiontranslator.com\/tr\/isblank\/","name":"Excel'de ISBLANK (EBO\u015eSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:29:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISBLANK (EBO\u015eSA) 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\/isblank\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/isblank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/isblank\/#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":"EBO\u015eSA"}]},{"@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\/15491","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=15491"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15491\/revisions"}],"predecessor-version":[{"id":26759,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15491\/revisions\/26759"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}