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

Yuvatama \u0130\u015flemlerinde Kullan\u0131lan Bir Fonksiyonun Detaylar\u0131<\/h2>\n

Bu rehberde, hem Microsoft Excel hem de Google E-Tablolar’da kullan\u0131lan ve say\u0131lar\u0131 belirli bir taban de\u011ferine yuvarlama i\u015flemi yapan FLOOR.MATH<\/code> (T\u00fcrk\u00e7e: TABANAYUVARLA.MATEMAT\u0130K<\/code>) fonksiyonunun kullan\u0131m\u0131n\u0131 ayr\u0131nt\u0131l\u0131 bi\u00e7imde ele alaca\u011f\u0131z. Son derece kullan\u0131\u015fl\u0131 olan bu fonksiyon, mali verilerin analizi gibi bir\u00e7ok farkl\u0131 durumda i\u015finize yarayabilir.<\/p>\n

Fonksiyonun S\u00f6z Dizimi ve Kullan\u0131m\u0131<\/h2>\n

FLOOR.MATH<\/code> fonksiyonu ana arg\u00fcman olarak bir say\u0131 al\u0131r ve bu say\u0131y\u0131 a\u015fa\u011f\u0131 do\u011fru en yak\u0131n tam say\u0131ya yuvarlar. Bu fonksiyonun s\u00f6z dizimi \u015fu \u015fekildedir:<\/p>\n

<\/code><\/pre>\n
    \n
  • number:<\/b> Yuvarlanacak olan say\u0131.<\/li>\n
  • significance (iste\u011fe ba\u011fl\u0131):<\/b> Yuvarlama i\u015fleminin ger\u00e7ekle\u015ftirilece\u011fi taban de\u011feri. Bu de\u011fer belirtilmezse varsay\u0131lan olarak 1 olarak kabul edilir.<\/li>\n
  • mode (iste\u011fe ba\u011fl\u0131):<\/b> Pozitif veya negatif say\u0131lar i\u00e7in yuvarlama modunu belirler. E\u011fer 0 ise (ya da belirtilmezse), say\u0131lar 0’a do\u011fru yuvarlan\u0131r.<\/li>\n<\/ul>\n
    Bu fonksiyon, \u00f6zellikle say\u0131sal verileri belirli bir hassasiyette yuvarlama gerekti\u011finde kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Maa\u015f Hesaplamalar\u0131<\/b><\/p>\n
    Bir \u015firket, \u00e7al\u0131\u015fanlar\u0131n\u0131n maa\u015flar\u0131n\u0131 belirli bir y\u00fcz say\u0131l\u0131k dilime yuvarlamak istiyor. \u00d6rne\u011fin, 2625.50 TL olan bir maa\u015f\u0131n 100 TL’lik dilimde yuvarlanmas\u0131 gerekmektedir. FLOOR.MATH<\/code> fonksiyonunu kullanarak bu i\u015flemi \u015fu \u015fekilde yapar\u0131z:<\/p>\n
    <\/pre>\n
    Yukar\u0131daki fonksiyon, 2625.50 say\u0131s\u0131n\u0131 a\u015fa\u011f\u0131 y\u00f6nl\u00fc en yak\u0131n 100'\u00fcn kat\u0131 olan 2600 olarak yuvarlar. Bu, \u00f6deme sistemlerinde hesaplama kolayl\u0131\u011f\u0131 sa\u011flar.<\/p>\n
    \u00d6rnek 2: Stok Birimlerinin Yuvarlanmas\u0131<\/b><\/p>\n
    Bir depo, \u00fcr\u00fcn say\u0131lar\u0131n\u0131 belirli lot miktarlar\u0131na g\u00f6re ayarlamak istiyor. E\u011fer bir \u00fcr\u00fcn\u00fcn sto\u011fu 423 adet ve bir lot 25 adet ise, bu durumda stok say\u0131s\u0131 a\u015fa\u011f\u0131 y\u00f6nl\u00fc yuvarlanmal\u0131d\u0131r. Fonksiyonu kullanarak:<\/p>\n
    <\/pre>\n
    Bu i\u015flem, 423 say\u0131s\u0131n\u0131 a\u015fa\u011f\u0131 y\u00f6nl\u00fc en yak\u0131n 25'in kat\u0131 olan 400 olarak yuvarlar ve bu \u015fekilde 400 adet \u00fcr\u00fcn lot olarak d\u00fczenlenebilir.<\/p>\n
    Bu iki \u00f6rnek, FLOOR.MATH<\/code> fonksiyonunun i\u015f d\u00fcnyas\u0131ndaki \u00e7e\u015fitli senaryolarda nas\u0131l kullan\u0131\u015fl\u0131 olabilece\u011fini g\u00f6stermektedir. Maliyet hesaplamalar\u0131ndan, stok y\u00f6netimine kadar bir\u00e7ok alanda bu t\u00fcr yuvarlama y\u00f6ntemleri i\u015finizi kolayla\u015ft\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir say\u0131y\u0131 en yak\u0131n tamsay\u0131ya veya en yak\u0131n anlaml\u0131 say\u0131 kat\u0131na a\u015fa\u011f\u0131 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-15418","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/\" \/>\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:07+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.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/floor-math\/\",\"name\":\"Excel'de FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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:07+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/floor-math\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/floor-math\/#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\":\"TABANAYUVARLA.MATEMAT\u0130K\"}]},{\"@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.MATH (TABANAYUVARLA.MATEMAT\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:27:07+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/","url":"https:\/\/functiontranslator.com\/tr\/floor-math\/","name":"Excel'de FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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:07+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da FLOOR.MATH (TABANAYUVARLA.MATEMAT\u0130K) 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-math\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/floor-math\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/floor-math\/#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":"TABANAYUVARLA.MATEMAT\u0130K"}]},{"@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\/15418","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=15418"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15418\/revisions"}],"predecessor-version":[{"id":26686,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15418\/revisions\/26686"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}