{"id":15499,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/esayiysa\/"},"modified":"2021-02-25T16:30:00","modified_gmt":"2021-02-25T16:30:00","slug":"isnumber","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/isnumber\/","title":{"rendered":"ESAYIYSA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r ve kullan\u0131c\u0131lar\u0131na veri \u00fczerinde \u00e7e\u015fitli i\u015flemler yapma imk\u00e2n\u0131 sunar. Bu ara\u00e7larla veri t\u00fcrlerini belirlemenizi sa\u011flayan bir\u00e7ok fonksiyon bulunmaktad\u0131r. “ISNUMBER” (T\u00fcrk\u00e7e’de “ESAYIYSA”), bir h\u00fccredeki de\u011ferin say\u0131sal olup olmad\u0131\u011f\u0131n\u0131 denetleyen bir fonksiyondur ve say\u0131sal de\u011fer i\u00e7eren h\u00fccrelerle \u00e7al\u0131\u015f\u0131l\u0131rken b\u00fcy\u00fck yarar sa\u011flar.<\/p>\n

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

“ISNUMBER” fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=ISNUMBER(de\u011fer)<\/code><\/pre>\n
Burada “de\u011fer”, say\u0131sal olup olmad\u0131\u011f\u0131 test edilecek h\u00fccre veya ifadedir.<\/p>\n
\u00d6rnek kullan\u0131mlar:<\/p>\n
    \n
  • =ISNUMBER(5)<\/code> – Sonu\u00e7: TRUE, zira 5 bir say\u0131d\u0131r.<\/li>\n
  • =ISNUMBER(\"Metin\")<\/code> – Sonu\u00e7: FALSE, \u00e7\u00fcnk\u00fc “Metin” bir metin t\u00fcr\u00fcndedir ve say\u0131sal de\u011fer ta\u015f\u0131maz.<\/li>\n<\/ul>\n
    Pratik Uygulamalar<\/h2>\n
    ISNUMBER fonksiyonunun kullan\u0131labilece\u011fi baz\u0131 pratik durumlar ve \u00f6rnekler \u015funlard\u0131r:<\/p>\n
    1. Say\u0131sal De\u011ferleri Filtreleme<\/h2>\n
    Bir veri setiniz var ve sadece say\u0131sal de\u011ferlere sahip h\u00fccreleri filtremek istiyorsunuz. Bu, \u00f6zellikle finansal veya say\u0131sal verilerle yo\u011fun \u015fekilde \u00e7al\u0131\u015f\u0131ld\u0131\u011f\u0131nda faydal\u0131d\u0131r.<\/p>\n
    =IF(ISNUMBER(A2), \"Say\u0131\", \"Say\u0131 De\u011fil\")<\/code><\/pre>\n
    Bu form\u00fcl, A2 h\u00fccresindeki de\u011ferin say\u0131sal olup olmad\u0131\u011f\u0131n\u0131 denetler. E\u011fer say\u0131sal bir de\u011fer ise “Say\u0131”, de\u011filse “Say\u0131 De\u011fil” d\u00f6n\u00fc\u015f yan\u0131t\u0131n\u0131 verir. Bu form\u00fcl bir s\u00fctunda veya t\u00fcm veri tablosu \u00fczerinde uygulanarak, hangi h\u00fccrelerin say\u0131sal de\u011fer i\u00e7erdi\u011fini h\u0131zl\u0131 bir \u015fekilde anlaman\u0131za yard\u0131mc\u0131 olur.<\/p>\n
    2. Say\u0131sal Veri Tiplerini Analiz Etme<\/h2>\n
    Bir ba\u015fka kullan\u0131m \u00f6rne\u011fi, bir veri setinde say\u0131sal olmayan girdilerin etkilerini incelemektir. \u00d6rne\u011fin, say\u0131sal olmayan girdileri saymak i\u00e7in a\u015fa\u011f\u0131daki kullan\u0131m\u0131 de\u011ferlendirebilirsiniz:<\/p>\n
    =COUNTIF(A1:A10, ISNUMBER)<\/code><\/pre>\n
    Bu form\u00fcl, A1’den A10’a kadar olan h\u00fccreler aras\u0131nda ka\u00e7 tane say\u0131sal de\u011fer bulundu\u011funu sayar. Say\u0131sal olmayan de\u011ferler i\u00e7in FALSE d\u00f6nd\u00fcrd\u00fc\u011f\u00fcnden, bu h\u00fccreler say\u0131ma dahil edilmez.<\/p>\n
    ISNUMBER fonksiyonunun Excel ve Google Sheets’teki kullan\u0131mlar\u0131na dair bu bilgiler, veri do\u011frulama ve temizleme i\u015flemleri s\u0131ras\u0131nda \u00e7ok i\u015finize yarayabilir. Fonksiyonun \u00e7e\u015fitli kullan\u0131m \u015fekillerini deneyerek veri setleriniz \u00fczerinde daha etkili kontroller yapabilir ve daha do\u011fru analizler yapabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    De\u011fer bir say\u0131ysa, 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-15499","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISNUMBER (ESAYIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISNUMBER (ESAYIYSA) 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\/isnumber\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISNUMBER (ESAYIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISNUMBER (ESAYIYSA) 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\/isnumber\/\" \/>\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:30:00+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 ISNUMBER (ESAYIYSA) 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\/isnumber\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/isnumber\/\",\"name\":\"Excel'de ISNUMBER (ESAYIYSA) 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:30:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISNUMBER (ESAYIYSA) 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\/isnumber\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/isnumber\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/isnumber\/#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\":\"ESAYIYSA\"}]},{\"@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 ISNUMBER (ESAYIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISNUMBER (ESAYIYSA) 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\/isnumber\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISNUMBER (ESAYIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISNUMBER (ESAYIYSA) 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\/isnumber\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:30:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISNUMBER (ESAYIYSA) 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\/isnumber\/","url":"https:\/\/functiontranslator.com\/tr\/isnumber\/","name":"Excel'de ISNUMBER (ESAYIYSA) 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:30:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISNUMBER (ESAYIYSA) 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\/isnumber\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/isnumber\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/isnumber\/#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":"ESAYIYSA"}]},{"@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\/15499","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=15499"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15499\/revisions"}],"predecessor-version":[{"id":26767,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15499\/revisions\/26767"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}