{"id":15691,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/nsat\/"},"modified":"2021-02-25T16:38:13","modified_gmt":"2021-02-25T16:38:13","slug":"trunc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/trunc\/","title":{"rendered":"NSAT"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te kullan\u0131lan TRUNC<\/code> (T\u00fcrk\u00e7e’de NSAT) fonksiyonu, bir say\u0131n\u0131n ondal\u0131k k\u0131sm\u0131n\u0131 kald\u0131rarak tam say\u0131 de\u011ferini verir. Finansal hesaplamalar ve veri analizi gibi sahalarda, ondal\u0131k de\u011ferlerden ar\u0131nm\u0131\u015f net sonu\u00e7lar elde etmek i\u00e7in s\u0131kl\u0131kla tercih edilir.<\/p>\n

TRUNC Fonksiyonunun S\u00f6zdizimi<\/h2>\n

TRUNC<\/code> fonksiyonunun s\u00f6zdizimi a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n

TRUNC(say\u0131, [basamak])<\/code><\/pre>\n
    \n
  • say\u0131:<\/strong> Kesirli k\u0131sm\u0131 elenip tam say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fclecek say\u0131d\u0131r.<\/li>\n
  • basamak (iste\u011fe ba\u011fl\u0131):<\/strong> Hangi ondal\u0131k basama\u011fa kadar say\u0131n\u0131n k\u0131salt\u0131laca\u011f\u0131n\u0131 belirten opsiyonel bir arg\u00fcmand\u0131r. Bu arg\u00fcman sa\u011flanmad\u0131\u011f\u0131nda veya 0 olarak girildi\u011finde, fonksiyon say\u0131n\u0131n tam k\u0131sm\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131mlar \u015fu \u015fekildedir:<\/p>\n\n\n\n\n\n\n
    Komut<\/th>\nSonu\u00e7<\/th>\n<\/tr>\n
    TRUNC(8.9)<\/code><\/td>\n8<\/td>\n<\/tr>\n
    TRUNC(8.9, 0)<\/code><\/td>\n8<\/td>\n<\/tr>\n
    TRUNC(-8.9)<\/code><\/td>\n-8<\/td>\n<\/tr>\n
    TRUNC(8.786, 2)<\/code><\/td>\n8.78<\/td>\n<\/tr>\n<\/table>\n
    TRUNC Fonksiyonunun Kullan\u0131m Senaryolar\u0131<\/h2>\n
    A\u015fa\u011f\u0131da, TRUNC fonksiyonunun \u00e7e\u015fitli kullan\u0131m \u00f6rnekleri ve uygulamalar\u0131 g\u00f6sterilmektedir.<\/p>\n
    \u00d6rnek 1: Finansal Raporlama<\/h2>\n
    Bir i\u015fletme, g\u00fcnl\u00fck gelir raporlar\u0131nda kesirli de\u011ferler yerine tam say\u0131lar\u0131 kullanmay\u0131 tercih eder. Gelirler genellikle kesirli olsa da, tam say\u0131 kullan\u0131m\u0131 raporlamay\u0131 daha a\u00e7\u0131k ve net yapar.<\/p>\n
    Gelir = 456.7893 G\u00fcnl\u00fck Raporlanan Gelir = TRUNC(Gelir)<\/code><\/pre>\n
      \n
    • Bu durumda, TRUNC(456.7893)<\/code> komutu “456” olarak bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n
      \u00d6rnek 2: Veri Analizi<\/h2>\n
      Veri analizinde k\u00fc\u00e7\u00fck par\u00e7ac\u0131kl\u0131 veriler bazen yaln\u0131zca tam say\u0131 format\u0131nda ele al\u0131n\u0131r. Bu ba\u011flamda, TRUNC fonksiyonu kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n
      Mesafe = 123.456 Tam Mesafe = TRUNC(Mesafe)<\/code><\/pre>\n
        \n
      • Bu \u00f6rnekte TRUNC(123.456)<\/code>, istenilen “123” olarak tam bir mesafe de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n
        TRUNC<\/code> fonksiyonunun ba\u015fl\u0131ca yarar\u0131 hesaplamalar\u0131 sadele\u015ftirerek daha anla\u015f\u0131l\u0131r hale getirmesidir. \u00d6zellikle b\u00fcy\u00fck veri setleri ve finansal raporlamada olduk\u00e7a s\u0131k kullan\u0131l\u0131r, pozitif ve negatif say\u0131larla uyumlu \u00e7al\u0131\u015f\u0131r, b\u00f6ylece kesirli say\u0131lar\u0131n kolayca elemine edilmesine olanak tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Bir say\u0131n\u0131n, tamsay\u0131 durumuna gelecek \u015fekilde, fazlal\u0131klar\u0131n\u0131 atar<\/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-15691","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de TRUNC (NSAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TRUNC (NSAT) 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\/trunc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TRUNC (NSAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TRUNC (NSAT) 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\/trunc\/\" \/>\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:38:13+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 TRUNC (NSAT) 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\/trunc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/trunc\/\",\"name\":\"Excel'de TRUNC (NSAT) 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:38:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TRUNC (NSAT) 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\/trunc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/trunc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/trunc\/#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\":\"NSAT\"}]},{\"@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 TRUNC (NSAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TRUNC (NSAT) 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\/trunc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TRUNC (NSAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TRUNC (NSAT) 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\/trunc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:38:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TRUNC (NSAT) 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\/trunc\/","url":"https:\/\/functiontranslator.com\/tr\/trunc\/","name":"Excel'de TRUNC (NSAT) 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:38:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TRUNC (NSAT) 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\/trunc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/trunc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/trunc\/#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":"NSAT"}]},{"@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\/15691","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=15691"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15691\/revisions"}],"predecessor-version":[{"id":26959,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15691\/revisions\/26959"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}