{"id":15486,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tamsayi\/"},"modified":"2021-02-25T16:29:38","modified_gmt":"2021-02-25T16:29:38","slug":"int","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/int\/","title":{"rendered":"TAMSAYI"},"content":{"rendered":"<p>Excel ve Google Sheets, veri analizi ve i\u015flem i\u00e7in yayg\u0131n olarak kullan\u0131lan uygulamalard\u0131r. Finans, muhasebe, bilim ve e\u011fitim gibi bir\u00e7ok alanda tercih edilen bu programlar, \u00e7e\u015fitli fonksiyonlar sunar. Bu makalede, Excel ve Google Sheets&#8217;te bulunan <code>INT<\/code> fonksiyonunun kullan\u0131m\u0131 \u00fczerine detayl\u0131 bilgi sunulacakt\u0131r.<\/p>\n<h2>S\u00f6zdizimi ve Kullan\u0131m<\/h2>\n<p><code>INT<\/code> fonksiyonu, belirtilen bir say\u0131y\u0131 a\u015fa\u011f\u0131 yuvarlayarak en yak\u0131n tam say\u0131ya \u00e7evirir. E\u011fer say\u0131 negatif ise, de\u011fer mutlak olarak artacak \u015fekilde yuvarlan\u0131r. Fonksiyon a\u015fa\u011f\u0131daki gibi kullan\u0131l\u0131r:<\/p>\n<pre><code>=INT(say\u0131)<\/code><\/pre>\n<ul>\n<li><strong>say\u0131:<\/strong> Yuvarlanacak ger\u00e7ek say\u0131. Bu arg\u00fcman bir say\u0131, h\u00fccre referans\u0131 veya form\u00fcl sonucu olabilir.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin:<\/p>\n<pre><code>=INT(4.7) \/\/ Sonu\u00e7 4 =INT(-4.7) \/\/ Sonu\u00e7 -5<\/code><\/pre>\n<h2>Pratik Uygulamalar<\/h2>\n<p><code>INT<\/code> fonksiyonu, finansal hesaplamalar, zaman serisi analizleri ve g\u00fcnl\u00fck veri i\u015fleme g\u00f6revleri i\u00e7in olduk\u00e7a faydal\u0131d\u0131r. \u0130\u015fte bu fonksiyonun farkl\u0131 kullan\u0131m \u00f6rnekleri:<\/p>\n<h2>\u00d6rnek 1: Ya\u015f Hesaplama<\/h2>\n<p>Do\u011fum tarihi verilen bir ki\u015finin tam ya\u015f\u0131n\u0131 hesaplamak i\u00e7in <code>INT<\/code> fonksiyonu idealdir. E\u011fer bug\u00fcn\u00fcn tarihi ve ki\u015finin do\u011fum tarihi bir h\u00fccrede belirlenmi\u015fse, ya\u015f hesaplama i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<\/p>\n<pre><code>=INT((BUG\u00dcN()-A1)\/365)<\/code><\/pre>\n<p>Bu form\u00fcl, A1 h\u00fccresindeki do\u011fum tarihinden bug\u00fcne kadar ge\u00e7en g\u00fcn say\u0131s\u0131n\u0131 hesaplar, bu s\u00fcreyi 365 g\u00fcnle b\u00f6lerek elde edilen kesirli de\u011feri en yak\u0131n tam say\u0131ya yuvarlar.<\/p>\n<h2>\u00d6rnek 2: Finansal Raporlama<\/h2>\n<p>Finansal raporlamada genellikle tam say\u0131lar tercih edilir. \u00d6rne\u011fin, bir \u015firketin y\u0131ll\u0131k sat\u0131\u015f gelirini milyonlar cinsinden yuvarlanm\u0131\u015f bir bi\u00e7imde g\u00f6stermek i\u00e7in <code>INT<\/code> fonksiyonu kullan\u0131l\u0131r. Diyelim ki toplam gelir B1 h\u00fccresinde belirtilmi\u015f:<\/p>\n<pre><code>=INT(B1\/1000000)<\/code><\/pre>\n<p>Bu form\u00fcl, B1 h\u00fccresindeki miktar\u0131 1,000,000&#8217;a b\u00f6ler ve ortaya \u00e7\u0131kan sonucu en yak\u0131n tam say\u0131ya yuvarlar ki bu da geliri milyonlar cinsinden ifade eder.<\/p>\n<p>Yukar\u0131daki \u00f6rnekler, <code>INT<\/code> fonksiyonunun g\u00fcnl\u00fck i\u015flemlerde nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir. Bu fonksiyon, ger\u00e7ek d\u00fcnyadaki veriler \u00fczerinde uyguland\u0131\u011f\u0131nda, veri analizi ve i\u015flem s\u00fcre\u00e7lerini basitle\u015ftirerek h\u0131zland\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir say\u0131y\u0131 a\u015fa\u011f\u0131ya do\u011fru en yak\u0131n tamsay\u0131ya yuvarlar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[577],"tags":[],"class_list":["post-15486","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"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 INT (TAMSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da INT (TAMSAYI) 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\/int\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de INT (TAMSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da INT (TAMSAYI) 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\/int\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:38+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 INT (TAMSAYI) 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\/int\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/int\/\",\"name\":\"Excel'de INT (TAMSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:29:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da INT (TAMSAYI) 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\/int\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/int\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/int\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematik ve trigonometri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TAMSAYI\"}]},{\"@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 INT (TAMSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da INT (TAMSAYI) 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\/int\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de INT (TAMSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da INT (TAMSAYI) 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\/int\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:29:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de INT (TAMSAYI) 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\/int\/","url":"https:\/\/functiontranslator.com\/tr\/int\/","name":"Excel'de INT (TAMSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:29:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da INT (TAMSAYI) 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\/int\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/int\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/int\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Matematik ve trigonometri","item":"https:\/\/functiontranslator.com\/tr\/matematik-ve-trigonometri\/"},{"@type":"ListItem","position":3,"name":"TAMSAYI"}]},{"@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\/15486","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=15486"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15486\/revisions"}],"predecessor-version":[{"id":26754,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15486\/revisions\/26754"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}