{"id":4624,"date":"2023-07-09T13:00:24","date_gmt":"2023-07-09T13:00:24","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/"},"modified":"2023-07-09T13:00:24","modified_gmt":"2023-07-09T13:00:24","slug":"excel-menghasilkan-4-digit-angka-acak","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/","title":{"rendered":"Cara menghasilkan angka acak 4 digit di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan proses dua langkah untuk menghasilkan angka acak 4 digit di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Gunakan RANDBETWEEN()<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(0, 9999)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan bilangan bulat acak antara 0 dan 9999 (misalnya, mungkin angka 468).<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Gunakan TEKS()<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A1<\/span> , \"0000\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menambahkan angka nol di depan angka tersebut jika perlu untuk memastikan panjangnya 4 digit (misalnya, ini akan mengubah 468 menjadi 0468).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghasilkan angka acak 4 digit di Excel dalam praktiknya.<\/span><\/p>\n<h2> <strong>Contoh: Cara Menghasilkan Angka Acak 4 Digit di Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, ketik rumus berikut di sel <strong>A1<\/strong> untuk menghasilkan bilangan bulat acak antara 0 dan 9999:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(0, 9999)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Lalu kita bisa menyeret rumus ini ke sel lain di kolom A untuk menghasilkan beberapa angka acak 4 digit:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36083 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rando1.png\" alt=\"\" width=\"433\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap sel di kolom A berisi bilangan bulat acak antara 0 dan 9999.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa sel terakhir di kolom tidak berisi 4 digit.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memastikan setiap sel pada kolom A memiliki 4 digit, kita dapat mengetikkan rumus berikut pada sel <strong>B1<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A1<\/span> , \"0000\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36084\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rando2.png\" alt=\"Excel menghasilkan angka acak 4 digit\" width=\"414\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap sel di kolom B sekarang berisi 4 digit nomor acak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda ingin menghasilkan angka acak 4 digit dalam satu langkah, Anda cukup menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=RANDBETWEEN(1000, 9999)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Ini akan menghasilkan bilangan bulat acak antara 1000 dan 9999.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya kelemahan dari pendekatan ini adalah tidak mungkin memiliki nol sebagai digit pertama.<\/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-menghasilkan-angka-acak-antar-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara menghasilkan angka acak antar rentang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/seleksi-acak-excel-dengan-kriteria\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sel secara acak berdasarkan kriteria di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sampel-acak-excel\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sampel acak di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan proses dua langkah untuk menghasilkan angka acak 4 digit di Excel: Langkah 1: Gunakan RANDBETWEEN() =RANDBETWEEN(0, 9999) Ini akan menghasilkan bilangan bulat acak antara 0 dan 9999 (misalnya, mungkin angka 468). Langkah 2: Gunakan TEKS() =TEXT( A1 , &#8220;0000&#8221;) Ini akan menambahkan angka nol di depan angka tersebut jika perlu untuk memastikan [&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 Menghasilkan Angka Acak 4 Digit di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghasilkan angka acak 4 digit di Excel, dengan contoh lengkap.\" \/>\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\/excel-menghasilkan-4-digit-angka-acak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghasilkan Angka Acak 4 Digit di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghasilkan angka acak 4 digit di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T13:00:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rando1.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\/excel-menghasilkan-4-digit-angka-acak\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/\",\"name\":\"Cara Menghasilkan Angka Acak 4 Digit di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T13:00:24+00:00\",\"dateModified\":\"2023-07-09T13:00:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghasilkan angka acak 4 digit di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghasilkan angka acak 4 digit 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 Menghasilkan Angka Acak 4 Digit di Excel - Statorials","description":"Tutorial ini menjelaskan cara menghasilkan angka acak 4 digit di Excel, dengan contoh lengkap.","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\/excel-menghasilkan-4-digit-angka-acak\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghasilkan Angka Acak 4 Digit di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menghasilkan angka acak 4 digit di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/","og_site_name":"Statorials","article_published_time":"2023-07-09T13:00:24+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rando1.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\/excel-menghasilkan-4-digit-angka-acak\/","url":"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/","name":"Cara Menghasilkan Angka Acak 4 Digit di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T13:00:24+00:00","dateModified":"2023-07-09T13:00:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghasilkan angka acak 4 digit di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghasilkan-4-digit-angka-acak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghasilkan angka acak 4 digit 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\/4624"}],"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=4624"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4624\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}