{"id":4738,"date":"2023-07-08T11:01:58","date_gmt":"2023-07-08T11:01:58","guid":{"rendered":"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/"},"modified":"2023-07-08T11:01:58","modified_gmt":"2023-07-08T11:01:58","slug":"putaran-excel-ke-dolar-terdekat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/","title":{"rendered":"Cara membulatkan ke dolar terdekat di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membulatkan harga di Excel ke dolar terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk melakukannya:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Bulatkan ke dolar terdekat dan tampilkan sen (misalnya $22,00)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ROUND( <span style=\"color: #3366ff;\">B2<\/span> , 0)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Bulatkan ke dolar terdekat dan jangan tampilkan sen (misalnya $22)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=\"$\"&amp;INT(ROUND( <span style=\"color: #3366ff;\">B2,0<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kedua metode tersebut mengasumsikan bahwa harga yang Anda bulatkan ada di sel <strong>B2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36998 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd1.png\" alt=\"\" width=\"474\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Bulatkan ke dolar terdekat dan tampilkan sen<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk membulatkan harga di sel <strong>B2<\/strong> ke dolar terdekat:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=ROUND( <span style=\"color: #3366ff;\">B2<\/span> , 0)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C;<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36999\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd2.png\" alt=\"Excel dibulatkan ke dolar terdekat\" width=\"502\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C menampilkan masing-masing harga di kolom B yang dibulatkan ke dolar terdekat.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Bulatkan ke dolar terdekat dan jangan tampilkan sen<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk membulatkan harga di sel <strong>B2<\/strong> ke dolar terdekat dan menghindari menampilkan sen:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=\"$\"&amp;INT(ROUND( <span style=\"color: #3366ff;\">B2,0<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37001\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd4.png\" alt=\"Excel membulatkan ke dolar terdekat dan tidak menampilkan sen\" width=\"480\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C menunjukkan masing-masing harga di kolom B yang dibulatkan ke dolar terdekat dan tidak menunjukkan sen.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa metode ini menggunakan simbol <strong>&amp;<\/strong> untuk menggabungkan tanda dolar hanya dengan bagian bilangan bulat dari nilai dolar yang dibulatkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah harga dibulatkan ke dolar terdekat dan sen tidak ditampilkan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-bawah\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan MROUND agar selalu membulatkan ke bawah<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/unggul\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menggunakan MROUND agar selalu membulat<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/angka-penting-unggul\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membulatkan ke angka penting<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin membulatkan harga di Excel ke dolar terdekat. Anda dapat menggunakan metode berikut untuk melakukannya: Metode 1: Bulatkan ke dolar terdekat dan tampilkan sen (misalnya $22,00) =ROUND( B2 , 0) Metode 2: Bulatkan ke dolar terdekat dan jangan tampilkan sen (misalnya $22) =&#8221;$&#8221;&amp;INT(ROUND( B2,0 )) Kedua metode tersebut mengasumsikan bahwa harga yang [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara membulatkan ke dolar terdekat di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membulatkan ke dolar terdekat di Excel, 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\/putaran-excel-ke-dolar-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 dolar terdekat di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membulatkan ke dolar terdekat di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T11:01:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd1.png\" \/>\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\/putaran-excel-ke-dolar-terdekat\/\",\"url\":\"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/\",\"name\":\"Cara membulatkan ke dolar terdekat di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T11:01:58+00:00\",\"dateModified\":\"2023-07-08T11:01:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membulatkan ke dolar terdekat di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membulatkan ke dolar terdekat di excel\"}]},{\"@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 dolar terdekat di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membulatkan ke dolar terdekat di Excel, 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\/putaran-excel-ke-dolar-terdekat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membulatkan ke dolar terdekat di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membulatkan ke dolar terdekat di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/","og_site_name":"Statorials","article_published_time":"2023-07-08T11:01:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sd1.png"}],"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\/putaran-excel-ke-dolar-terdekat\/","url":"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/","name":"Cara membulatkan ke dolar terdekat di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T11:01:58+00:00","dateModified":"2023-07-08T11:01:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membulatkan ke dolar terdekat di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/putaran-excel-ke-dolar-terdekat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membulatkan ke dolar terdekat di excel"}]},{"@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\/4738"}],"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=4738"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4738\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}