{"id":15417,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tabanayuvarla\/"},"modified":"2021-02-25T16:27:06","modified_gmt":"2021-02-25T16:27:06","slug":"floor","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/floor\/","title":{"rendered":"TABANAYUVARLA"},"content":{"rendered":"

Excel ve Google Sheets’te \u2018FLOOR\u2019 (TABANAYUVARLA) Fonksiyonu Nedir?<\/strong><\/p>\n

FLOOR fonksiyonu, bir say\u0131y\u0131, belirtilen bir kat say\u0131ya (\u00f6nem derecesine) en yak\u0131n alt tam say\u0131 de\u011ferine yuvarlayan bir fonksiyondur. Finans ve matematik alanlar\u0131 ba\u015fta olmak \u00fczere veri analizi s\u00fcre\u00e7lerinden grupland\u0131rmaya ve tahminlemeye kadar geni\u015f \u00e7apta kullan\u0131l\u0131r.<\/p>\n

S\u00f6z Dizimi<\/strong><\/p>\n

FLOOR(number, significance)<\/code><\/pre>\n
    \n
  • number:<\/strong> Yuvarlanacak say\u0131.<\/li>\n
  • significance:<\/strong> Yuvarlama i\u015flemi i\u00e7in kullan\u0131lacak kat say\u0131.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m<\/h2>\n
    =FLOOR(6.7, 1) \/\/ Sonu\u00e7: 6 =FLOOR(-3.7, 2) \/\/ Sonu\u00e7: -4<\/code><\/pre>\n
    Uygulamal\u0131 \u00d6rnekler<\/h2>\n
    \u00d6rnek 1: Muhasebe ve Mali Y\u0131l Planlamas\u0131<\/strong><\/p>\n
    Mali y\u0131l sonu planlamas\u0131 yaparken \u015firketiniz yat\u0131r\u0131mlar\u0131 belirli birim dilimlerine yuvarlamak isteyebilir. \u00d6rne\u011fin, bir \u015firket yat\u0131r\u0131m giderlerini her 100 birimlik dilimlere g\u00f6re planlayabilir:<\/p>\n
    =FLOOR(957, 100) \/\/ Sonu\u00e7: 900<\/code><\/pre>\n
    Bu sonu\u00e7, 957 birimlik giderin 900 birim olarak muhasebele\u015ftirildi\u011fini ve kalan 57 birimin sonraki periyoda ta\u015f\u0131nd\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    \u00d6rnek 2: Zaman Bazl\u0131 Fiyatland\u0131rma<\/strong><\/p>\n
    \u00d6rne\u011fin, bir otoparkta park \u00fccretleri her 15 dakikal\u0131k dilim baz\u0131nda hesaplan\u0131yor olsa, ve bir ki\u015fi 37 dakika park etmi\u015f olsa:<\/p>\n
    =FLOOR(37, 15) \/\/ Sonu\u00e7: 30<\/code><\/pre>\n
    Bu durumda park s\u00fcresi en yak\u0131n ge\u00e7mi\u015f 15 dakikal\u0131k dilime yuvarlan\u0131r ve m\u00fc\u015fteri 30 dakika i\u00e7in \u00fccret \u00f6der.<\/p>\n
    Tablo ile \u00d6rnekler<\/h2>\n\n\n\n\n\n
    Giri\u015f De\u011feri<\/th>\nYuvarlama Kat\u0131<\/th>\nFLOOR Sonucu<\/th>\nA\u00e7\u0131klama<\/th>\n<\/tr>\n
    6.7<\/td>\n1<\/td>\n6<\/td>\nEn yak\u0131n tam say\u0131ya yuvarlama.<\/td>\n<\/tr>\n
    -3.7<\/td>\n2<\/td>\n-4<\/td>\nNegatif y\u00f6nde en yak\u0131n d\u00fc\u015f\u00fck \u00e7ift say\u0131ya yuvarlama.<\/td>\n<\/tr>\n
    23.25<\/td>\n0.5<\/td>\n23<\/td>\nEn yak\u0131n 0.5 kat\u0131na yuvarlama.<\/td>\n<\/tr>\n<\/table>\n
    Bu tablo, FLOOR fonksiyonunun \u00e7e\u015fitli “number” ve “significance” de\u011ferleri kullan\u0131ld\u0131\u011f\u0131nda nas\u0131l farkl\u0131 sonu\u00e7lar \u00fcretti\u011fini g\u00f6stermektedir.<\/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":[584],"tags":[],"class_list":["post-15417","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de FLOOR (TABANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da FLOOR (TABANAYUVARLA) 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\/floor\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de FLOOR (TABANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da FLOOR (TABANAYUVARLA) 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\/floor\/\" \/>\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:27:06+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 FLOOR (TABANAYUVARLA) 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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/floor\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/floor\/\",\"name\":\"Excel'de FLOOR (TABANAYUVARLA) 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:27:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da FLOOR (TABANAYUVARLA) 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\/floor\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/floor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/floor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TABANAYUVARLA\"}]},{\"@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 FLOOR (TABANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da FLOOR (TABANAYUVARLA) 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\/floor\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de FLOOR (TABANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da FLOOR (TABANAYUVARLA) 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\/floor\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:27:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de FLOOR (TABANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/floor\/","url":"https:\/\/functiontranslator.com\/tr\/floor\/","name":"Excel'de FLOOR (TABANAYUVARLA) 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:27:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da FLOOR (TABANAYUVARLA) 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\/floor\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/floor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/floor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"TABANAYUVARLA"}]},{"@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\/15417","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=15417"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15417\/revisions"}],"predecessor-version":[{"id":26685,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15417\/revisions\/26685"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}