{"id":15298,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tavanayuvarla-duyarli\/"},"modified":"2021-02-25T16:23:20","modified_gmt":"2021-02-25T16:23:20","slug":"ceiling-precise","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/ceiling-precise\/","title":{"rendered":"TAVANAYUVARLA.DUYARLI"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Yuvarlama \u0130\u015flevleri: TAVANAYUVARLA.DUYARLI \u0130ncelemesi<\/h1>\n

Yuvarlama i\u015flevleri, hem MS Excel hem de Google Sheets’te olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. Bu yaz\u0131da, “TAVANAYUVARLA.DUYARLI” fonksiyonunun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131, nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve fonksiyonun uygulanabilece\u011fi pratik g\u00f6revlerle anlatmaya \u00e7al\u0131\u015faca\u011f\u0131z. Bu fonksiyon, belirli bir de\u011feri en yak\u0131n tam say\u0131ya ya da belirlenen bir kat\u0131na yuvarlama i\u015flevi g\u00f6r\u00fcr.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

“TAVANAYUVARLA.DUYARLI” fonksiyonu, bir say\u0131y\u0131 belirledi\u011finiz de\u011ferin katlar\u0131na yukar\u0131 do\u011fru yuvarlar.<\/p>\n

=TAVANAYUVARLA.DUYARLI(say\u0131, [\u00f6nemsiz]) <\/code><\/pre>\n
    \n
  • say\u0131<\/strong>: Yuvarlanacak olan de\u011fer.<\/li>\n
  • \u00f6nemsiz (opsiyonel)<\/strong>: Yuvarlaman\u0131n yap\u0131laca\u011f\u0131 kat say\u0131. E\u011fer belirtilmezse, varsay\u0131lan olarak 1 kabul edilir.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m a\u015fa\u011f\u0131daki gibi olabilir:<\/p>\n
    =TAVANAYUVARLA.DUYARLI(10.75) \/\/Sonu\u00e7 11 olur. =TAVANAYUVARLA.DUYARLI(6.3, 0.5) \/\/Sonu\u00e7 6.5 olur. <\/code><\/pre>\n
    Pratik Uygulamalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n
    Uygulama 1: Fiyat Hesaplama<\/h3>\n
    \u00d6rne\u011fin, bir \u00fcr\u00fcnde uygulanacak fiyat art\u0131\u015f\u0131 hesapland\u0131\u011f\u0131nda, son halini yuvarlamak isteyebilirsiniz. Diyelim ki, \u00fcr\u00fcn\u00fcn g\u00fcncel fiyat\u0131 22.30 TL ve %15 oran\u0131nda bir fiyat art\u0131\u015f\u0131 planl\u0131yorsunuz. Fiyat\u0131n yar\u0131m TL cinsinden yuvarlanmas\u0131n\u0131 istiyor olabilirsiniz.<\/p>\n
    f\u0131yat = 22.30 art\u0131\u015f_oran\u0131 = 0.15 yeni_fiyat = f\u0131yat + (f\u0131yat * art\u0131\u015f_oran\u0131) sonuc = TAVANAYUVARLA.DUYARLI(yeni_fiyat, 0.5) <\/code><\/pre>\n
    Yukar\u0131daki form\u00fcl kullan\u0131ld\u0131\u011f\u0131nda, yeni fiyat \u00f6nce 25.645 olarak hesaplan\u0131r ve “TAVANAYUVARLA.DUYARLI” kullanarak 26.0 TL olarak yuvarlan\u0131r.<\/p>\n
    Uygulama 2: Zaman Planlama<\/h3>\n
    Bir projede ge\u00e7irilecek saat miktarlar\u0131 planlarken, \u00e7al\u0131\u015fma saatlerinin tam ya da yar\u0131m saatlik periyotlar halinde olmas\u0131 tercih edilebilir. E\u011fer bir g\u00f6rev i\u00e7in 38 dakika tahmin edilmi\u015fse, bunu yar\u0131m saatlik periyotlara yuvarlayabilirsiniz.<\/p>\n
    s\u00fcre_dakika = 38 s\u00fcre_saat = s\u00fcre_dakika \/ 60 yuvarlanm\u0131\u015f_s\u00fcre = TAVANAYUVARLA.DUYARLI(s\u00fcre_saat, 0.5) <\/code><\/pre>\n
    Bu durumda, 38 dakika, saat cinsinden 0.6333 olarak hesapland\u0131ktan sonra, 0.5 saatlik periyotlarla yuvarlanarak 1 saate \u00e7\u0131kar\u0131l\u0131r.<\/p>\n
    Yukar\u0131da verilen \u00f6rnekler ve a\u00e7\u0131klamalar, “TAVANAYUVARLA.DUYARLI” fonksiyonunun hem MS Excel hem de Google E-Tablolar’da nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. Bu fonksiyonun esnekli\u011fi, bir\u00e7ok farkl\u0131 senaryoda kullan\u0131lmas\u0131n\u0131 m\u00fcmk\u00fcn k\u0131lar. \u0130ster fiyatland\u0131rma, ister zaman y\u00f6netimi olsun, bu i\u015flev sayesinde de\u011ferleri istedi\u011finiz kriterlere g\u00f6re kolayl\u0131kla yuvarlayabilirsiniz.<\/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 yuvarlar Say\u0131n\u0131n i\u015faretinden ba\u011f\u0131ms\u0131z olarak say\u0131 yukar\u0131 yuvarlan\u0131r<\/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-15298","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/\" \/>\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:20+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 CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/ceiling-precise\/\",\"name\":\"Excel'de CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/ceiling-precise\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/ceiling-precise\/#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.DUYARLI\"}]},{\"@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.PRECISE (TAVANAYUVARLA.DUYARLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:23:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/","url":"https:\/\/functiontranslator.com\/tr\/ceiling-precise\/","name":"Excel'de CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CEILING.PRECISE (TAVANAYUVARLA.DUYARLI) 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-precise\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/ceiling-precise\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/ceiling-precise\/#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.DUYARLI"}]},{"@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\/15298","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=15298"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15298\/revisions"}],"predecessor-version":[{"id":27040,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15298\/revisions\/27040"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}