{"id":87868,"date":"2023-10-26T10:55:00","date_gmt":"2023-10-26T03:55:00","guid":{"rendered":"https:\/\/deepublishstore.com\/blog\/?p=87868"},"modified":"2023-10-27T17:45:17","modified_gmt":"2023-10-27T10:45:17","slug":"cara-membulatkan-angka-di-excel","status":"publish","type":"post","link":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/","title":{"rendered":"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit"},"content":{"rendered":"\n<p>Walaupun terbilang sepele, ternyata banyak juga yang belum tau bagaimana cara membulatkan angka di excel baik ke atas maupun ke bawah. Pada kesempatan kali ini, Deepublish Store bakalan bahas ini dalam 3 cara dan pastinya setiap panduan disertai dengan cara-cara yang runut dan tidak membingungkan.<\/p>\n\n\n\n<p>Namun, sebelum lanjut. Tahukah kamu jika berbicara tentang pembulatan angka di excel ada beberapa jalan yang bisa dihitung. Bahkan, dari cara menghitung rumus pembulatan pun ada beberapa alternative. Ada yang versi panjang dan versi singkat.\u00a0<\/p>\n\n\n\n<p>Artikel ditulis secara komprehensif, detail dan mudah yang tujuan utamanya supaya kamu juga akan belajar bagaimana cara membulatkan angka di excel secara menggunakan rumus dan menggunakan versi singkat.<\/p>\n\n\n\n<p><strong>Berikut tips dan panduan membulatkan angka di excel dengan baik dan benar.<\/strong><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69d0ff47d208d\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69d0ff47d208d\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#1_Rumus_Round_Down_atau_Membulatkan_Angka_Ke_Bawah\" >1. Rumus Round Down atau Membulatkan Angka Ke Bawah<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#2_Rumus_Roundup_atau_Membulatkan_Angka_Ke_Atas\" >2. Rumus Roundup atau Membulatkan Angka Ke Atas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#3_Cara_Membulatkan_Angka_Di_Excel_Menggunakan_Increase_dan_Decrease\" >3. Cara Membulatkan Angka Di Excel Menggunakan Increase dan Decrease\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#1_Increase_Decimal\" >1. Increase Decimal\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#2_Decrease_Decimal\" >2. Decrease Decimal\u00a0<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Rumus_Round_Down_atau_Membulatkan_Angka_Ke_Bawah\"><\/span>1. Rumus Round Down atau Membulatkan Angka Ke Bawah<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Buat kamu yang ingin membulatkan angka desimal ke atas, bisa menggunakan rumus ROUND. Jadi dengan rumus ini, bisa membulatkan angka secara otomatis secara kaidah matematika.&nbsp;<\/p>\n\n\n\n<p>Rumus Round adalah pembulatan angka yang paling umum digunakan. Umumnya pembulatan dapat dilakukan dengan membulatkan ke atas dan membulatkan ke bawah. Jadi apabila menemukan angka dibelakang koma lebih dari satu atau sama dengan 5 maka angka tersebut harus dibulatkan ke atas. Sementara jika angka dibelakang koma tidak sampai dari lima angka, maka perlu dibulatkan ke bawah.<\/p>\n\n\n\n<p><strong>Berikut langkah-langkahnya.<\/strong><\/p>\n\n\n\n<p>1. Langkah pertama, perlunya memasukan data ke lembar kerja Excel. Contoh bisa dilihat sebagai gambar di bawah\u00a0<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"240\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image1.jpg\" alt=\"memasukan data ke lembar kerja Excel\" class=\"wp-image-87869\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image1.jpg 455w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image1-300x158.jpg 300w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><figcaption class=\"wp-element-caption\">Memasukan data ke lembar kerja Excel<\/figcaption><\/figure>\n<\/div>\n\n\n<p>2. Setelah file semuanya sudah dimasukan, langkah selanjutnya adalah menempatkan kursor di kolom yang hendak dibulatkan. Di dalam kolom kita ketik &#8220;=ROUND&#8221; seperti gambar berikut.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"324\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image2.jpg\" alt=\"ketik &quot;=ROUND&quot;\" class=\"wp-image-87870\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image2.jpg 618w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image2-300x157.jpg 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><figcaption class=\"wp-element-caption\">ketik &#8220;=ROUND&#8221;<\/figcaption><\/figure>\n<\/div>\n\n\n<p>3. Setelah diketik demikian akan muncul &#8220;=ROUNDDOWN(number,num_digits)\u201d kemudian klik kolom yang hendak dibulatkan.\u00a0<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"229\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image3.jpg\" alt=\"muncul &quot;=ROUNDDOWN\" class=\"wp-image-87871\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image3.jpg 451w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image3-300x152.jpg 300w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><figcaption class=\"wp-element-caption\">muncul &#8220;=ROUNDDOWN<\/figcaption><\/figure>\n<\/div>\n\n\n<p>4. Pada contoh di atas disamping \u201c=rounddown\u201d terdapat tanda kurung yang disertai dengan kode A2 yang muncul secara otomatis ketika diklik pada kolom yang akan dibulatkan.<\/p>\n\n\n\n<p>5. Kemudian disamping A2 wajib disertai dengan tanda \u201c;\u201d kemudian diikuti angka 2. Angka 2 diambil dari keinginan kita. Karena kita akan membulatkan setelah 2 angka desimal, maka kita ketik 2.Jika ingin membulatkan dibelakang desimal 3 angka atau 1 angka hanya tinggal menggantinya saja.<\/p>\n\n\n\n<p>6. Jika sudah, tinggal tekan enter. Maka akan muncul hitungan angka secara otomatis seperti gambar di bawah.\u00a0<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"310\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image4.jpg\" alt=\"setelah dibulatkan kebawah\" class=\"wp-image-87872\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image4.jpg 460w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image4-300x202.jpg 300w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><figcaption class=\"wp-element-caption\">Setelah dibulatkan kebawah<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Pada contoh gambar di atas angka setelah dibulatkan kebawah menjadi 42,51.<\/p>\n\n\n\n<p>7. Jika ingin mengetahui jumlah desimal dibulatkan ke bawah secara otomatis dari perhitungan di atas, maka ada cara singkat yaitu dengan klik kolom B2. Kemudian arahkan kursor di kolom,maka akan muncul tanda +  dan kemudian ditarik ke arah bawah. Maka, secara otomatis pembulatan akan keluar secara otomatis seperti berikut.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"438\" height=\"210\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image5.jpg\" alt=\"desimal dibulatkan ke bawah secara otomatis\" class=\"wp-image-87873\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image5.jpg 438w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image5-300x144.jpg 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><figcaption class=\"wp-element-caption\">Desimal dibulatkan ke bawah secara otomatis<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Rumus_Roundup_atau_Membulatkan_Angka_Ke_Atas\"><\/span>2. <strong>Rumus Roundup atau Membulatkan Angka Ke Atas<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Selain pembulatan ke bawah, ada juga pembulatan ke atas atau roundup. Jadi roundup merupakan cara untuk membulatkan angka desimal menjadi angka 0. Berikut adalah rumus roundup yang bisa kamu lakukan.<\/p>\n\n\n\n<p>1. Masuk ke lembar kerja excel, dan kamu bisa memasukan angka (masih menggunakan contoh yang sama seperti yang di rounddown.\u00a0<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"240\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image1.jpg\" alt=\"memasukan data ke lembar kerja Excel\" class=\"wp-image-87869\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image1.jpg 455w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image1-300x158.jpg 300w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><figcaption class=\"wp-element-caption\">Memasukan data ke lembar kerja Excel<\/figcaption><\/figure>\n<\/div>\n\n\n<p>2. Setelah file semuanya sudah dimasukan, langkah selanjutnya adalah menempatkan kursor di kolom yang hendak dibulatkan. Di dalam kolom kita ketik &#8220;=ROUND&#8221; seperti gambar berikut.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"324\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image2.jpg\" alt=\"ketik &quot;=ROUND&quot;\" class=\"wp-image-87870\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image2.jpg 618w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image2-300x157.jpg 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><figcaption class=\"wp-element-caption\">ketik &#8220;=ROUND&#8221;<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Dari gambar di atas, bisa ketik \u201c=roundup\u201d dan akan muncul &#8220;=ROUNDUP(number,num_digits)\u201d kemudian klik kolom yang hendak dibulatkan.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"246\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image6.jpg\" alt=\" ketik \u201c=roundup\u201d\" class=\"wp-image-87874\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image6.jpg 486w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image6-300x152.jpg 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><figcaption class=\"wp-element-caption\"> ketik \u201c=roundup\u201d<\/figcaption><\/figure>\n<\/div>\n\n\n<p>3. Pada contoh di atas disamping \u201c=roundUP\u201d terdapat tanda kurung yang disertai dengan kode A2 yang muncul secara otomatis ketika diklik pada kolom yang akan dibulatkan.<\/p>\n\n\n\n<p>4. Kemudian disamping A2 wajib disertai dengan tanda \u201c<strong>;<\/strong>\u201d kemudian diikuti angka 2. Angka 2 diambil dari keinginan kita. Karena kita akan membulatkan setelah 2 angka desimal, maka kita ketik 2. Jika ingin membulatkan dibelakang desimal 3 angka atau 1 angka hanya tinggal menggantinya saja.<\/p>\n\n\n\n<p>5. Jika sudah, tinggal tekan enter. Maka akan muncul hitungan angka secara otomatis seperti gambar di bawah.\u00a0<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"225\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image7.jpg\" alt=\"hitungan angka secara otomatis \" class=\"wp-image-87875\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image7.jpg 396w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image7-300x170.jpg 300w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><figcaption class=\"wp-element-caption\">Hitungan angka secara otomatis <\/figcaption><\/figure>\n<\/div>\n\n\n<p>Pada contoh gambar di atas angka setelah dibulatkan kebawah menjadi 42,52.<\/p>\n\n\n\n<p>6. Jika ingin mengetahui jumlah desimal dibulatkan ke bawah secara otomatis dari perhitungan di atas, maka ada cara singkat yaitu dengan klik kolom B2. Kemudian arahkan kursor di kolom,maka akan muncul tanda + ,kemudian ditarik ke arah bawah. Maka, secara otomatis pembulatan akan keluar secara otomatis seperti berikut.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"266\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image8.jpg\" alt=\"Hasil Roundup\" class=\"wp-image-87876\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image8.jpg 415w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image8-300x192.jpg 300w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><figcaption class=\"wp-element-caption\">Hasil Roundup<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Dari cara membulatkan angka di excel menggunakan rumus Rounddown dan roundup di atas, jika dibandingkan, ada perbedaan hasil yang cukup jelas. Berikut hasil akhir jika disandingkan, untuk melihat perbedaan hasil antara keduannya.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"440\" height=\"109\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/hasil-akhir-pembulatan.jpg\" alt=\"hasil akhir pembulatan\" class=\"wp-image-87877\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/hasil-akhir-pembulatan.jpg 440w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/hasil-akhir-pembulatan-300x74.jpg 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><figcaption class=\"wp-element-caption\">Hasil akhir pembulatan<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Sampai di sini, semoga bisa membantu cara membulatkan angka di excel versi menggunakan rumus. Ternyata tidak sulit bukan? Kamu bisa mencoba dan melatihnya.<\/p>\n\n\n\n<p>Insight: &#8220;<strong><a href=\"https:\/\/deepublishstore.com\/blog\/cara-mengetik-pecahan-di-word\/\">6 Tips dan Cara Mengetik Pecahan di Word<\/a><\/strong>&#8220;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Cara_Membulatkan_Angka_Di_Excel_Menggunakan_Increase_dan_Decrease\"><\/span>3. <strong>Cara Membulatkan Angka Di Excel Menggunakan Increase dan Decrease\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Selain menggunakan rumus &#8220;Round&#8221; di atas, kamu pun juga bisa membulatkan menggunakan cara yang lebih simpel dan singkat, tanpa harus menggunakan rumus. Namanya adalah increase decimal dan decrease decimal.&nbsp;<\/p>\n\n\n\n<p>Lantas dimana kamu bisa menemukan increase dan decrease ini? tenang setiap laptop\/komputer sudah memiliki fitur ini. Kamu Bisa temukan di lembar kerja Excel. Kemudian Kamu bisa temukan di menu &#8220;HOME&#8221; maka, di sana ada banyak sekali ragam pilihan. Kamu bisa mencari menu NUMBER. <\/p>\n\n\n\n<p>Jika menggunakan Windows 10 lokasinya ada di sisi tengah, tampilannya akan tampak sebagai gambar berikut.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"139\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-1.png\" alt=\"\" class=\"wp-image-87878\"\/><\/figure>\n<\/div>\n\n\n<p>Dari gambar di atas, lalu mana bagian increase dan decrease? Sekilas memang tidak terlihat secara tertulis. Karena hanya terlihat dalam bentuk simbol gambar. Untuk mengetahui jawabannya langsung simak berikut.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Increase_Decimal\"><\/span>1. Increase Decimal\u00a0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Jadi Increase decimal berperan untuk menampilkan lebih banyak bilangan desimal. Kode increase decimal sebagai berikut<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"349\" height=\"127\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-2.png\" alt=\"\" class=\"wp-image-87879\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-2.png 349w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-2-300x109.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Decrease_Decimal\"><\/span>2. Decrease Decimal\u00a0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>sebaliknya, Decrease decimal akan menampilkan bilangan desimal lebih sedikit, yang disebut Decrease ditandai pada kode berikut .<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"349\" height=\"127\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-3.png\" alt=\"\" class=\"wp-image-87880\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-3.png 349w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-3-300x109.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/figure>\n<\/div>\n\n\n<p>&nbsp;<\/p>\n\n\n\n<p>Lalu bagaimana caranya? Sangat mudah<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Masuk ke lembar excel<\/li>\n\n\n\n<li>Tulis angka sesuai dengan kebutuhan. Contoh sebagai berikut.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"528\" height=\"273\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-4.png\" alt=\"\" class=\"wp-image-87881\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-4.png 528w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/image-4-300x155.png 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Tiga kolom di atas bisa di blok dan tinggal klik Increase atau Decrease, sesuai dengan keinginan. Berikut adalah hasil setelah di increase dan di-decreasi-kan<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"315\" height=\"130\" src=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/increasing-decimal.jpg\" alt=\"increasing decimal\" class=\"wp-image-87882\" srcset=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/increasing-decimal.jpg 315w, https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/increasing-decimal-300x124.jpg 300w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><figcaption class=\"wp-element-caption\">Increasing decimal<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Dari contoh di atas terlihat jauh perbedaan penulisan angka desimal di belakang koma bukan? Cara ini juga anggap paling cepat.<\/p>\n\n\n\n<p>Bagaimana? Sangat mudah bukan? Tidak perlu rumus, tinggal klik kode tersebut, maka secara otomatis angka bisa berubah dalam bentuk desimal. Semoga dari ulasan tentang cara membulatkan angka di excel memberikan wawasan baru cara cepat mengoperasikan versi cepat dan versi menggunakan rumus. Semoga bermanfaat. (Irukawa Elisa)<\/p>\n\n\n\n<p>Baca juga artikel tentang excel lainnya berikut, <strong><a href=\"https:\/\/deepublishstore.com\/blog\/cara-membuat-garis-di-excel\/\">Cara membuat garis di Ms. Excel<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Panduan mudah bagi pemula untuk membulatkan angka di Excel hanya dengan 5 menit dan rumus yang mudah dan sudah tersedia di Ms. Excel.<\/p>\n","protected":false},"author":2,"featured_media":87883,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-87868","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-artikel-cerdas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit - Deepublish Store<\/title>\n<meta name=\"description\" content=\"Panduan mudah bagi pemula untuk membulatkan angka di Excel hanya dengan 5 menit dan rumus yang mudah dan sudah tersedia di Ms. Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit - Deepublish Store\" \/>\n<meta property=\"og:description\" content=\"Panduan mudah bagi pemula untuk membulatkan angka di Excel hanya dengan 5 menit dan rumus yang mudah dan sudah tersedia di Ms. Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Deepublish Store\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-26T03:55:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T10:45:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/Cara-Membulatkan-Angka-Di-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"524\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yusuf Abdhul Azis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@deepublisher\" \/>\n<meta name=\"twitter:site\" content=\"@deepublisher\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf Abdhul Azis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 menit\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit - Deepublish Store","description":"Panduan mudah bagi pemula untuk membulatkan angka di Excel hanya dengan 5 menit dan rumus yang mudah dan sudah tersedia di Ms. Excel.","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:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit - Deepublish Store","og_description":"Panduan mudah bagi pemula untuk membulatkan angka di Excel hanya dengan 5 menit dan rumus yang mudah dan sudah tersedia di Ms. Excel.","og_url":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/","og_site_name":"Deepublish Store","article_published_time":"2023-10-26T03:55:00+00:00","article_modified_time":"2023-10-27T10:45:17+00:00","og_image":[{"width":900,"height":524,"url":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/Cara-Membulatkan-Angka-Di-Excel.jpg","type":"image\/jpeg"}],"author":"Yusuf Abdhul Azis","twitter_card":"summary_large_image","twitter_creator":"@deepublisher","twitter_site":"@deepublisher","twitter_misc":{"Ditulis oleh":"Yusuf Abdhul Azis","Estimasi waktu membaca":"9 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#article","isPartOf":{"@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/"},"author":{"name":"Yusuf Abdhul Azis","@id":"https:\/\/deepublishstore.com\/blog\/#\/schema\/person\/817ff2c0038f340b466b10f6f0658bbc"},"headline":"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit","datePublished":"2023-10-26T03:55:00+00:00","dateModified":"2023-10-27T10:45:17+00:00","mainEntityOfPage":{"@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/"},"wordCount":1030,"publisher":{"@id":"https:\/\/deepublishstore.com\/blog\/#organization"},"image":{"@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/Cara-Membulatkan-Angka-Di-Excel.jpg","articleSection":["Artikel Cerdas"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/","url":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/","name":"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit - Deepublish Store","isPartOf":{"@id":"https:\/\/deepublishstore.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#primaryimage"},"image":{"@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/Cara-Membulatkan-Angka-Di-Excel.jpg","datePublished":"2023-10-26T03:55:00+00:00","dateModified":"2023-10-27T10:45:17+00:00","description":"Panduan mudah bagi pemula untuk membulatkan angka di Excel hanya dengan 5 menit dan rumus yang mudah dan sudah tersedia di Ms. Excel.","breadcrumb":{"@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#primaryimage","url":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/Cara-Membulatkan-Angka-Di-Excel.jpg","contentUrl":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/Cara-Membulatkan-Angka-Di-Excel.jpg","width":900,"height":524,"caption":"Cara Membulatkan Angka Di Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/deepublishstore.com\/blog\/artikel-cerdas\/cara-membulatkan-angka-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/deepublishstore.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Artikel Cerdas","item":"https:\/\/deepublishstore.com\/blog\/category\/artikel-cerdas\/"},{"@type":"ListItem","position":3,"name":"Cara Membulatkan Angka di Microsoft Excel Hanya 5 Menit"}]},{"@type":"WebSite","@id":"https:\/\/deepublishstore.com\/blog\/#website","url":"https:\/\/deepublishstore.com\/blog\/","name":"Deepublish Store Blog","description":"Pusat Buku Referensi Kuliah","publisher":{"@id":"https:\/\/deepublishstore.com\/blog\/#organization"},"alternateName":"Deepublish Store Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/deepublishstore.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/deepublishstore.com\/blog\/#organization","name":"Deepublish Store","url":"https:\/\/deepublishstore.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/deepublishstore.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/cropped-icon-deepublish-store-blog.png","contentUrl":"https:\/\/deepublishstore.com\/wp-content\/uploads\/2023\/04\/cropped-icon-deepublish-store-blog.png","width":127,"height":35,"caption":"Deepublish Store"},"image":{"@id":"https:\/\/deepublishstore.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/deepublisher"]},{"@type":"Person","@id":"https:\/\/deepublishstore.com\/blog\/#\/schema\/person\/817ff2c0038f340b466b10f6f0658bbc","name":"Yusuf Abdhul Azis","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/secure.gravatar.com\/avatar\/e49bbf8111e656d436285262ed11269bc24bd881c163eb9465f0cfd2f89f7fb5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e49bbf8111e656d436285262ed11269bc24bd881c163eb9465f0cfd2f89f7fb5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e49bbf8111e656d436285262ed11269bc24bd881c163eb9465f0cfd2f89f7fb5?s=96&d=mm&r=g","caption":"Yusuf Abdhul Azis"},"description":"Sebagai seorang SEO Spesialis, telah berpengalaman dalam membantu berbagai bisnis meningkatkan visibilitas online mereka melalui optimasi mesin pencari. Dengan keahlian dalam riset kata kunci, optimasi konten, dan strategi backlink,\u00a0 berfokus pada peningkatan trafik organik dan peringkat situs web di mesin pencari","url":"https:\/\/deepublishstore.com\/blog\/author\/yusufabdhul\/"}]}},"views":983,"_links":{"self":[{"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/posts\/87868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/comments?post=87868"}],"version-history":[{"count":3,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/posts\/87868\/revisions"}],"predecessor-version":[{"id":89571,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/posts\/87868\/revisions\/89571"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/media\/87883"}],"wp:attachment":[{"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/media?parent=87868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/categories?post=87868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deepublishstore.com\/blog\/wp-json\/wp\/v2\/tags?post=87868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}