{"id":15495,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/eformulse\/"},"modified":"2021-02-25T16:29:54","modified_gmt":"2021-02-25T16:29:54","slug":"isformula","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/isformula\/","title":{"rendered":"EFORM\u00dcLSE"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, her seviyede kullan\u0131c\u0131 i\u00e7in g\u00fc\u00e7l\u00fc veri analizi ara\u00e7lar\u0131 sunar. Bu ara\u00e7lardan bir tanesi de ISFORMULA<\/code> (T\u00fcrk\u00e7e’de EFORM\u00dcLSE<\/code>) fonksiyonudur. Bu fonksiyon, belirli bir h\u00fccrede form\u00fcl bulunup bulunmad\u0131\u011f\u0131n\u0131 kontrol etmek amac\u0131yla kullan\u0131l\u0131r. E\u011fer h\u00fccre bir form\u00fcl i\u00e7eriyorsa, fonksiyon TRUE (do\u011fru) de\u011ferini; aksi takdirde FALSE (yanl\u0131\u015f) de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p>\n

Fonksiyon Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

ISFORMULA<\/code> fonksiyonunun temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=ISFORMULA(h\u00fccre_referans\u0131)<\/code><\/pre>\n
    \n
  • h\u00fccre_referans\u0131:<\/strong> Form\u00fcl i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek istedi\u011finiz h\u00fccrenin referans\u0131.<\/li>\n<\/ul>\n
    \u00d6rnek:<\/p>\n
    =ISFORMULA(A1)<\/code><\/pre>\n
    Bu \u00f6rnekte, e\u011fer A1 h\u00fccresi bir form\u00fcl i\u00e7eriyorsa fonksiyon TRUE d\u00f6necek; e\u011fer A1 h\u00fccresi sabit bir de\u011fer i\u00e7eriyorsa veya bo\u015fsa FALSE d\u00f6necektir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    EFORM\u00dcLSE<\/code> fonksiyonu Excel ve Google Sheets’te \u00e7e\u015fitli senaryolarda de\u011ferli olabilir. \u0130\u015fte bu fonksiyonun kullan\u0131\u015fl\u0131 oldu\u011fu baz\u0131 durumlar:<\/p>\n
    Bir H\u00fccredeki Form\u00fcllerin Tespiti<\/h2>\n
    Geni\u015f bir veri seti \u00fczerinde \u00e7al\u0131\u015f\u0131rken, baz\u0131 h\u00fccrelerin manuel olarak girilmi\u015f de\u011ferler yerine form\u00fcller i\u00e7erip i\u00e7ermedi\u011fini bilmek faydal\u0131 olabilir. \u00d6rne\u011fin, bir b\u00fct\u00e7e tablosunda hangi de\u011ferlerin hesapland\u0131\u011f\u0131n\u0131 belirlemek isteyebilirsiniz.<\/p>\n
    =ISFORMULA(B2)<\/code><\/pre>\n
      \n
    • E\u011fer B2 h\u00fccresi bir form\u00fcl i\u00e7eriyorsa, bu form\u00fcl\u00fc inceleyebilir ve gerekirse d\u00fczenleyebilirsiniz.<\/li>\n<\/ul>\n
      Otomatik Raporlama ve Uyar\u0131lar<\/h2>\n
      Belli h\u00fccrelerin form\u00fcl ile doldurulmu\u015f olup olmad\u0131\u011f\u0131n\u0131 belirlemek, raporlama ve denetim i\u015flemleri i\u00e7in hayati \u00f6nem ta\u015f\u0131r. \u00d6rne\u011fin, bir veri setindeki t\u00fcm h\u00fccrelerin form\u00fcllerle doldurulmas\u0131 gerekti\u011fi durumlarda, baz\u0131lar\u0131n\u0131n manuel giri\u015fle dolduruldu\u011funu ke\u015ffetmek, hatalar\u0131 \u00f6nlemek a\u00e7\u0131s\u0131ndan kritik olabilir.<\/p>\n\n\n\n\n
      H\u00fccre<\/th>\n\u0130\u00e7erik<\/th>\nForm\u00fcl Kontrol\u00fc<\/th>\n<\/tr>\n
      A1<\/td>\n100<\/td>\nFALSE<\/td>\n<\/tr>\n
      A2<\/td>\n=A1*2<\/td>\nTRUE<\/td>\n<\/tr>\n<\/table>\n
        \n
      • Bu senaryoda, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korumak ve olas\u0131 hatalar\u0131 tespit etmek i\u00e7in h\u00fccrelerde form\u00fcl olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek yararl\u0131d\u0131r.<\/li>\n<\/ul>\n
        Yukar\u0131da belirtilen kullan\u0131mlar, \u00f6zellikle b\u00fcy\u00fck veri setleri ve karma\u015f\u0131k i\u015f modellerinde \u00e7al\u0131\u015f\u0131rken Excel ve Google Sheets’in ISFORMULA<\/code> fonksiyonunu de\u011ferli bir ara\u00e7 haline getirmektedir. Veri do\u011frulu\u011funu art\u0131rma, yanl\u0131\u015fl\u0131kla yap\u0131lan de\u011fi\u015fiklikleri engelleme ve otomatik hesaplamalar\u0131n do\u011frulu\u011funu teyit etme gibi i\u015flemler i\u00e7in olduk\u00e7a etkilidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Form\u00fcl i\u00e7eren bir h\u00fccreye ba\u015fvuru varsa DO\u011eRU de\u011ferini 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-15495","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISFORMULA (EFORM\u00dcLSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISFORMULA (EFORM\u00dcLSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/\" \/>\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:54+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 ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/isformula\/\",\"name\":\"Excel'de ISFORMULA (EFORM\u00dcLSE) 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:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/isformula\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/isformula\/#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\":\"EFORM\u00dcLSE\"}]},{\"@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 ISFORMULA (EFORM\u00dcLSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISFORMULA (EFORM\u00dcLSE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/","url":"https:\/\/functiontranslator.com\/tr\/isformula\/","name":"Excel'de ISFORMULA (EFORM\u00dcLSE) 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:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISFORMULA (EFORM\u00dcLSE) 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\/isformula\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/isformula\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/isformula\/#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":"EFORM\u00dcLSE"}]},{"@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\/15495","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=15495"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15495\/revisions"}],"predecessor-version":[{"id":26763,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15495\/revisions\/26763"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}