{"id":15296,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tavanayuvarla\/"},"modified":"2021-02-25T16:23:19","modified_gmt":"2021-02-25T16:23:19","slug":"ceiling","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/ceiling\/","title":{"rendered":"TAVANAYUVARLA"},"content":{"rendered":"<h2>Yukar\u0131 Yuvarlama Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n<p>Excel ve Google E-Tablolar, veri analizi ve hesaplamalar konusunda son derece g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Her iki programda da bulunan <code>CEILING<\/code> veya T\u00fcrk\u00e7e ad\u0131yla <code>TAVANAYUVARLA<\/code> i\u015flevi, belirli bir say\u0131y\u0131, belirtti\u011finiz bir kat\u0131na en yak\u0131n \u015fekilde yukar\u0131 y\u00f6nl\u00fc yuvarlar. Bu i\u015flev finansal hesaplamalardan, veri d\u00fczenlemeye kadar bir\u00e7ok alanda pratik kullan\u0131mlar sunar.<\/p>\n<h2>\u0130\u015flevin S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n<p>Excel ve Google E-Tablolar\u2019da kullan\u0131lan <code>TAVANAYUVARLA<\/code> i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n<pre> <code>TAVANAYUVARLA(say\u0131; \u00e7arpan) <\/code> <\/pre>\n<ul>\n<li><strong>say\u0131:<\/strong> Yuvarlanacak olan ger\u00e7ek say\u0131d\u0131r.<\/li>\n<li><strong>\u00e7arpan:<\/strong> Say\u0131n\u0131n yuvarlanaca\u011f\u0131 kat\u0131 belirtir. Bu de\u011fer negatif veya pozitif olabilir fakat s\u0131f\u0131r olamaz.<\/li>\n<\/ul>\n<p>\u00d6rnek kullan\u0131m\u0131 a\u015fa\u011f\u0131daki gibi ger\u00e7ekle\u015ftirilebilir:<\/p>\n<pre> <code>TAVANAYUVARLA(4.2; 1) \/\/ Sonu\u00e7: 5 TAVANAYUVARLA(-4.2; 1) \/\/ Sonu\u00e7: -4 <\/code> <\/pre>\n<h2>Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n<h3>1. Finansal Tutarda Kesirli De\u011feri Elimine Etme<\/h3>\n<p>Bir i\u015fletme, faturalar\u0131ndaki miktarlar\u0131 en yak\u0131n tam say\u0131 de\u011fere yuvarlamak istiyor olabilir. \u00d6zellikle miktar \u00e7ok k\u00fc\u00e7\u00fck kuru\u015flarla ifade edildi\u011finde, muhasebe prati\u011fi olarak bu tutarlar\u0131n tam say\u0131 olarak yuvarlanmas\u0131 i\u015flem kolayl\u0131\u011f\u0131 sa\u011flar.<\/p>\n<pre> <code>Kesirli tutar: 456.78 Yuvarlama kat\u0131: 1 Kullan\u0131lan Form\u00fcl: =TAVANAYUVARLA(456.78; 1) Sonu\u00e7: 457 <\/code> <\/pre>\n<p>Bu \u00f6rnekte, 456.78 de\u011feri 1\u2019in katlar\u0131na yuvarlanarak 457 olarak hesaplanm\u0131\u015ft\u0131r, bu i\u015flem sayesinde i\u015fletme faturalar\u0131nda tam say\u0131 tutarlar\u0131 g\u00f6rebilir.<\/p>\n<h3>2. \u00dcretimde Malzeme Boyutland\u0131rma<\/h3>\n<p>Bir \u00fcretim firmas\u0131, \u00fcretimde kullan\u0131lan malzemeleri belirli standart \u00f6l\u00e7\u00fclerde kesmek istiyor olabilir. \u00d6rne\u011fin, bir demir \u00e7ubu\u011fu en yak\u0131n 5 cm&#8217;lik k\u0131sma yuvarlamak gerekebilir.<\/p>\n<pre> <code>Orijinal boyut: 142.5 cm Yuvarlama kat\u0131: 5 Kullan\u0131lan Form\u00fcl: =TAVANAYUVARLA(142.5; 5) Sonu\u00e7: 145 cm <\/code> <\/pre>\n<p>Bu senaryoda, 142.5 cm uzunlu\u011fundaki demir \u00e7ubuk, en yak\u0131n 5 cm&#8217;lik kat olan 145 cm&#8217;ye yuvarlanm\u0131\u015ft\u0131r. Bu i\u015flem, malzeme israf\u0131n\u0131 azalt\u0131r ve standart \u00fcretim s\u00fcre\u00e7lerine uyum sa\u011flar.<\/p>\n<p>Bu iki pratik \u00f6rnek, <code>TAVANAYUVARLA<\/code> i\u015flevinin hem finansal hem de \u00fcretim s\u00fcre\u00e7lerinde nas\u0131l etkili bir \u015fekilde kullan\u0131labilece\u011fini g\u00f6stermektedir. Her iki durumda da kolayl\u0131k sa\u011flayan bu i\u015flev, verileri belirlenen katlara g\u00f6re d\u00fczenleme ihtiyac\u0131n\u0131 kar\u015f\u0131lar.<\/p>\n<p>Excel ve Google E-Tablolar\u2019daki bu gibi i\u015flevler, veri i\u015fleme ve hesaplama g\u00f6revlerinizi daha verimli hale getirmeye yard\u0131mc\u0131 olur. \u0130htiya\u00e7lar\u0131n\u0131za g\u00f6re bu i\u015flevleri kullanarak zaman kazanabilir ve hatalar\u0131 minimuma indirebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Say\u0131y\u0131 en yak\u0131n tamsay\u0131ya veya en yak\u0131n anlaml\u0131 say\u0131 kat\u0131na 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-15296","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 CEILING (TAVANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da CEILING (TAVANAYUVARLA) 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\/ceiling\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de CEILING (TAVANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da CEILING (TAVANAYUVARLA) 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\/ceiling\/\" \/>\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:23:19+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 CEILING (TAVANAYUVARLA) 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\/ceiling\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/ceiling\/\",\"name\":\"Excel'de CEILING (TAVANAYUVARLA) 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:23:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CEILING (TAVANAYUVARLA) 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\/ceiling\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/ceiling\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/ceiling\/#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\":\"TAVANAYUVARLA\"}]},{\"@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 CEILING (TAVANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CEILING (TAVANAYUVARLA) 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\/ceiling\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CEILING (TAVANAYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CEILING (TAVANAYUVARLA) 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\/ceiling\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:23:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CEILING (TAVANAYUVARLA) 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\/ceiling\/","url":"https:\/\/functiontranslator.com\/tr\/ceiling\/","name":"Excel'de CEILING (TAVANAYUVARLA) 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:23:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CEILING (TAVANAYUVARLA) 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\/ceiling\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/ceiling\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/ceiling\/#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":"TAVANAYUVARLA"}]},{"@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\/15296","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=15296"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15296\/revisions"}],"predecessor-version":[{"id":26564,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15296\/revisions\/26564"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}