{"id":2724,"date":"2023-07-21T00:17:06","date_gmt":"2023-07-21T00:17:06","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/"},"modified":"2023-07-21T00:17:06","modified_gmt":"2023-07-21T00:17:06","slug":"google-sheet-membulatkan-5-10-terdekat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/","title":{"rendered":"Cara membulatkan ke 5 atau 10 terdekat di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk membulatkan nilai ke 5 atau 10 terdekat di Google Spreadsheet:<\/span><\/p>\n

Cara 1: Bulatkan ke 5 terdekat<\/strong><\/span><\/p>\n

 #round value in cell A1 to nearest 5<\/span>\n=MROUND( A1,5<\/span> )<\/span>\n\n#round value in cell A1 up<\/em> to nearest 5<\/span>\n=CEILING( A1,5<\/span> )<\/span>\n\n#round value in cell A1 down<\/i> to nearest 5<\/span>\n= FLOOR(A1,5<\/span> )<\/span>\n<\/strong><\/pre>\n
 Cara 2: Bulatkan ke sepuluh terdekat<\/strong><\/span><\/p>\n
 #round value in cell A1 to nearest 10<\/span>\n=MROUND( A1,10<\/span> )<\/span>\n\n#round value in cell A1 up<\/em> to nearest 10<\/span>\n=CEILING( A1,10<\/span> )<\/span>\n\n#round value in cell A1 down<\/i> to nearest 10<\/span>\n=FLOOR( A1,10<\/span> )<\/span><\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n
 Contoh 1: Bulatkan ke 5 terdekat di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara membulatkan setiap nilai di kolom A ke 5 terdekat:<\/span> <\/p>\n
\"Google<\/p>\n
 Rumus pada kolom B membulatkan nilainya ke 5 terdekat.<\/span><\/p>\n
 Rumus pada kolom C membulatkan nilainya ke 5 terdekat<\/em> .<\/span><\/p>\n
 Dan rumus pada kolom D membulatkan nilainya ke 5 terdekat<\/em> .<\/span><\/p>\n
 Contoh 2: Pembulatan ke sepuluh terdekat di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara membulatkan setiap nilai di kolom A ke sepuluh terdekat:<\/span> <\/p>\n
\"\"<\/p>\n
 Rumus pada kolom B membulatkan nilainya ke sepuluh terdekat.<\/span><\/p>\n
 Rumus pada kolom C membulatkan nilainya ke<\/em> sepuluh terdekat.<\/span><\/p>\n
 Dan rumus di kolom D membulatkan<\/em> nilainya ke sepuluh terdekat.<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara membulatkan ke angka penting di Google Sheets<\/a>
 Cara menemukan nilai terdekat di Google Sheets<\/a>
 Cara mengekstrak angka dari string di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut untuk membulatkan nilai ke 5 atau 10 terdekat di Google Spreadsheet: Cara 1: Bulatkan ke 5 terdekat #round value in cell A1 to nearest 5 =MROUND( A1,5 ) #round value in cell A1 up to nearest 5 =CEILING( A1,5 ) #round value in cell A1 down to nearest 5 = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nCara membulatkan ke 5 atau 10 terdekat di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membulatkan ke 5 atau 10 terdekat di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membulatkan ke 5 atau 10 terdekat di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membulatkan ke 5 atau 10 terdekat di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T00:17:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tourgoogle1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/\",\"name\":\"Cara membulatkan ke 5 atau 10 terdekat di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T00:17:06+00:00\",\"dateModified\":\"2023-07-21T00:17:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membulatkan ke 5 atau 10 terdekat di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membulatkan ke 5 atau 10 terdekat di google sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara membulatkan ke 5 atau 10 terdekat di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara membulatkan ke 5 atau 10 terdekat di Google Sheets, dengan beberapa contoh.","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:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membulatkan ke 5 atau 10 terdekat di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membulatkan ke 5 atau 10 terdekat di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/","og_site_name":"Statorials","article_published_time":"2023-07-21T00:17:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tourgoogle1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/","url":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/","name":"Cara membulatkan ke 5 atau 10 terdekat di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T00:17:06+00:00","dateModified":"2023-07-21T00:17:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membulatkan ke 5 atau 10 terdekat di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-membulatkan-5-10-terdekat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membulatkan ke 5 atau 10 terdekat di google sheets"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2724"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2724"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2724\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}