{"id":15621,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/asagiyuvarla\/"},"modified":"2021-02-25T16:34:59","modified_gmt":"2021-02-25T16:34:59","slug":"rounddown","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/rounddown\/","title":{"rendered":"A\u015eA\u011eIYUVARLA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi ve hesaplama i\u015flerinizde g\u00fc\u00e7l\u00fc yard\u0131mc\u0131lar\u0131n\u0131zd\u0131r. Bu makalede, Excel ve Google Sheets’te kullanabilece\u011finiz ROUNDDOWN (A\u015eA\u011eIYUVARLA) fonksiyonunu detaylar\u0131yla inceleyece\u011fiz. Bu fonksiyon, belirtilen bir de\u011feri, yine belirtilen bir basamak say\u0131s\u0131na kadar a\u015fa\u011f\u0131 yuvarlamak i\u00e7in kullan\u0131l\u0131r ve finansal hesaplardan veri temizli\u011fine kadar \u00e7ok \u00e7e\u015fitli alanlarda faydal\u0131d\u0131r.<\/p>\n

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

ROUNDDOWN fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  A\u015eA\u011eIYUVARLA(say\u0131, basamak) <\/code> <\/pre>\n
    \n
  • say\u0131:<\/strong> Yuvarlanacak olan ger\u00e7ek say\u0131.<\/li>\n
  • basamak:<\/strong> Yuvarlaman\u0131n uygulanaca\u011f\u0131 basamak say\u0131s\u0131n\u0131 belirtir. Pozitif de\u011ferler ondal\u0131k k\u0131s\u0131mda, negatif de\u011ferler ise tam k\u0131s\u0131mda yuvarlamay\u0131 ger\u00e7ekle\u015ftirir.<\/li>\n<\/ul>\n
    \u00d6rnek:<\/p>\n
      =A\u015eA\u011eIYUVARLA(123.987, 2) \/\/ Sonu\u00e7 123.98 olur. =A\u015eA\u011eIYUVARLA(123.987, 0) \/\/ Sonu\u00e7 123 olur. =A\u015eA\u011eIYUVARLA(123.987, -2) \/\/ Sonu\u00e7 100 olur. <\/code> <\/pre>\n
    Pratik \u00d6rnekler<\/h2>\n
    1. Finansal Raporlama<\/h2>\n
    Finansal raporlarda genellikle tam say\u0131lar tercih edilir. \u00d6rne\u011fin, bir \u015firket projelerden elde etti\u011fi gelirleri y\u00fczler basama\u011f\u0131na yuvarlamak isteyebilir:<\/p>\n
     A1 h\u00fccresine girilen de\u011fer: 26785.90 Form\u00fcl: =A\u015eA\u011eIYUVARLA(A1, -2) Sonu\u00e7: 26700 <\/code><\/pre>\n
    Bu kullan\u0131m, 26785.90 say\u0131s\u0131n\u0131 en yak\u0131n y\u00fczl\u00fc\u011fe yuvarlar ve 26700 sonucunu \u00fcretir, raporlar\u0131n\u0131zda daha d\u00fczg\u00fcn veriler sa\u011flar.<\/p>\n
    2. E\u011fitimde Not Hesaplama<\/h2>\n
    Okullar, \u00f6\u011frencilerin s\u0131nav puanlar\u0131n\u0131 belirli kriterlere g\u00f6re yuvarlamak isteyebilir. \u00d6rne\u011fin, puanlar\u0131 yar\u0131m puanl\u0131k ad\u0131mlarla yuvarlamak:<\/p>\n
     A1 h\u00fccresine girilen de\u011fer: 88.3 Form\u00fcl: =A\u015eA\u011eIYUVARLA(A1, 1) * 2 \/ 2 Sonu\u00e7: 88.5 <\/code><\/pre>\n
    Bu form\u00fcl, 88.3 puan\u0131 \u00f6nce en yak\u0131n ondal\u0131k basama\u011fa yuvarlar, sonra bu de\u011feri iki ile \u00e7arpar ve ikiye b\u00f6ler. Bu i\u015flem sonucunda elde edilen puan 0.5’in katlar\u0131na yuvarlanm\u0131\u015f olur.<\/p>\n
    ROUNDDOWN (A\u015eA\u011eIYUVARLA) fonksiyonu, finansal analizlerden e\u011fitime, \u00fcr\u00fcn fiyatland\u0131rmadan envanter y\u00f6netimine kadar bir\u00e7ok alanda kullan\u0131labilir. Bu fonksiyonla belirli standartlara uygun daha d\u00fczenli ve tutarl\u0131 sonu\u00e7lar elde edebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir say\u0131y\u0131, daha k\u00fc\u00e7\u00fck say\u0131ya, s\u0131f\u0131ra yak\u0131nsayarak 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-15621","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de ROUNDDOWN (A\u015eA\u011eIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ROUNDDOWN (A\u015eA\u011eIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/\" \/>\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:34:59+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 ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/rounddown\/\",\"name\":\"Excel'de ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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:34:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/rounddown\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/rounddown\/#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\":\"A\u015eA\u011eIYUVARLA\"}]},{\"@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 ROUNDDOWN (A\u015eA\u011eIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ROUNDDOWN (A\u015eA\u011eIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:34:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/","url":"https:\/\/functiontranslator.com\/tr\/rounddown\/","name":"Excel'de ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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:34:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ROUNDDOWN (A\u015eA\u011eIYUVARLA) 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\/rounddown\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/rounddown\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/rounddown\/#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":"A\u015eA\u011eIYUVARLA"}]},{"@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\/15621","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=15621"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15621\/revisions"}],"predecessor-version":[{"id":26889,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15621\/revisions\/26889"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}