{"id":15622,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yukariyuvarla\/"},"modified":"2021-02-25T16:35:03","modified_gmt":"2021-02-25T16:35:03","slug":"roundup","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/roundup\/","title":{"rendered":"YUKARIYUVARLA"},"content":{"rendered":"

Excel ve Google Sheets, veri analizi ve hesaplama i\u015flemlerini kolayla\u015ft\u0131ran \u00e7e\u015fitli fonksiyonlar sa\u011flayan g\u00fc\u00e7l\u00fc elektronik tablo uygulamalar\u0131d\u0131r. Bu yaz\u0131da, belirli bir de\u011feri en yak\u0131n daha b\u00fcy\u00fck tam say\u0131ya veya belirlenen ondal\u0131k basama\u011fa yuvarlamak i\u00e7in kullan\u0131lan ROUNDUP<\/strong> (T\u00fcrk\u00e7ede YUKARIYUVARLA<\/strong>) fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 detayl\u0131ca inceleyece\u011fiz.<\/p>\n

Fonksiyon Tan\u0131m\u0131 ve S\u00f6z Dizimi<\/h2>\n

ROUNDUP<\/code> fonksiyonu, belirtilen bir say\u0131y\u0131 her zaman yukar\u0131 yuvarlar. Excel ve Google Sheets’te bu fonksiyon, verilen say\u0131y\u0131, belirtilen ondal\u0131k basamak say\u0131s\u0131na g\u00f6re yukar\u0131 do\u011fru yuvarlar.<\/p>\n

S\u00f6z Dizimi: ROUNDUP(say\u0131, basamak_say\u0131s\u0131)<\/code><\/pre>\n
    \n
  • say\u0131:<\/strong> Yuvarlanacak olan say\u0131.<\/li>\n
  • basamak_say\u0131s\u0131:<\/strong> Yuvarlaman\u0131n yap\u0131laca\u011f\u0131 ondal\u0131k basamak say\u0131s\u0131. Yukar\u0131 yuvarlama i\u00e7in pozitif veya negatif de\u011ferler, tam say\u0131 yuvarlama i\u00e7in ise 0 de\u011feri kullan\u0131l\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnekler:<\/p>\n
    =ROUNDUP(3.14159, 0) \/\/ Sonu\u00e7 4 =ROUNDUP(-3.14159, 2) \/\/ Sonu\u00e7 -3.15 =ROUNDUP(314.16, -2) \/\/ Sonu\u00e7 400<\/code><\/pre>\n
    Pratik \u00d6rnekler<\/h2>\n
    ROUNDUP fonksiyonunun ger\u00e7ek d\u00fcnya uygulamalar\u0131na ili\u015fkin \u00f6rnekler:<\/p>\n
    Finansal Hesaplamalarda Kullan\u0131m<\/h2>\n
    \u00d6rnek: Bir i\u015fletmenin y\u0131ll\u0131k gelirini yuvarlayarak b\u00fct\u00e7e dilimlerine ay\u0131rmak istedi\u011fini d\u00fc\u015f\u00fcn\u00fcn. Her b\u00fct\u00e7e dilimi 10.000 birime yuvarlanmal\u0131d\u0131r.<\/p>\n
    Gelir: 85367 Yuvarlanm\u0131\u015f B\u00fct\u00e7e Dilimi: =ROUNDUP(A1, -4) \/\/ A1 h\u00fccresinde gelir bilgisi mevcutsa<\/code><\/pre>\n
    Bu sayede elde edilecek yuvarlanm\u0131\u015f de\u011fer 90.000 olur, b\u00fct\u00e7e planlamas\u0131 daha d\u00fczenli ve anla\u015f\u0131l\u0131r h\u00e2le gelir.<\/p>\n
    Veri Analizinde Hassas De\u011ferlerin D\u00fczenlenmesi<\/h2>\n
    \u00d6rnek: Bir ara\u015ft\u0131rmac\u0131n\u0131n \u00f6l\u00e7\u00fcm sonu\u00e7lar\u0131n\u0131 belirli bir hassasiyetle raporlamas\u0131 gerekti\u011fini varsayal\u0131m. \u00d6l\u00e7\u00fcm sonu\u00e7lar\u0131 sadece ilk iki ondal\u0131k basama\u011fa yuvarlanmal\u0131d\u0131r.<\/p>\n
    \u00d6l\u00e7\u00fcm sonucu: 0.123456 Rapor i\u00e7in Yuvarlanm\u0131\u015f De\u011fer: =ROUNDUP(B2, 2) \/\/ B2 h\u00fccresinde \u00f6l\u00e7\u00fcm sonucu bulunuyorsa<\/code><\/pre>\n
    Bu i\u015flem sonucunda \u00f6l\u00e7\u00fcm sonucu 0.124 olarak d\u00fczeltilir ve raporlar i\u00e7in daha standart de\u011ferler sa\u011flan\u0131r.<\/p>\n
    ROUNDUP Fonksiyonunun Avantajlar\u0131<\/h2>\n
    ROUNDUP fonksiyonu, \u00f6zellikle finansal modelleme ve veri analizinde verilerin standartla\u015ft\u0131r\u0131lmas\u0131na yard\u0131mc\u0131 olur. \u00c7e\u015fitli sekt\u00f6rlerde farkl\u0131 senaryolarda yuvarlama ihtiyac\u0131 duyuldu\u011funda esnek ve kullan\u0131\u015fl\u0131d\u0131r. Kolay kullan\u0131m\u0131 ile veri do\u011frulu\u011funu art\u0131r\u0131r ve raporlama ile analiz i\u015flemlerinde tutarl\u0131l\u0131k sa\u011flamada kritik bir role sahiptir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Say\u0131y\u0131 daha b\u00fcy\u00fck say\u0131ya, s\u0131f\u0131rdan uzakla\u015farak 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-15622","post","type-post","status-publish","format-standard","hentry","category-matematik-ve-trigonometri"],"acf":[],"yoast_head":"\nExcel'de ROUNDUP (YUKARIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ROUNDUP (YUKARIYUVARLA) 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\/roundup\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ROUNDUP (YUKARIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ROUNDUP (YUKARIYUVARLA) 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\/roundup\/\" \/>\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:35:03+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 ROUNDUP (YUKARIYUVARLA) 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\/roundup\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/roundup\/\",\"name\":\"Excel'de ROUNDUP (YUKARIYUVARLA) 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:35:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ROUNDUP (YUKARIYUVARLA) 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\/roundup\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/roundup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/roundup\/#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\":\"YUKARIYUVARLA\"}]},{\"@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 ROUNDUP (YUKARIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ROUNDUP (YUKARIYUVARLA) 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\/roundup\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ROUNDUP (YUKARIYUVARLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ROUNDUP (YUKARIYUVARLA) 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\/roundup\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:35:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ROUNDUP (YUKARIYUVARLA) 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\/roundup\/","url":"https:\/\/functiontranslator.com\/tr\/roundup\/","name":"Excel'de ROUNDUP (YUKARIYUVARLA) 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:35:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ROUNDUP (YUKARIYUVARLA) 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\/roundup\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/roundup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/roundup\/#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":"YUKARIYUVARLA"}]},{"@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\/15622","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=15622"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15622\/revisions"}],"predecessor-version":[{"id":26890,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15622\/revisions\/26890"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}