{"id":5128,"date":"2023-07-03T02:47:35","date_gmt":"2023-07-03T02:47:35","guid":{"rendered":"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/"},"modified":"2023-07-03T02:47:35","modified_gmt":"2023-07-03T02:47:35","slug":"sel-isi-otomatis-excel-berdasarkan-sel-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/","title":{"rendered":"Excel: cara mengisi sel secara otomatis berdasarkan nilai sel lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mengisi sel secara otomatis di Excel berdasarkan nilai sel lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini mudah dilakukan dengan menggunakan fungsi <strong>IF<\/strong> dan contoh berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Mengisi Sel Secara Otomatis Berdasarkan Nilai Sel Lain di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom berikut di Excel yang memperlihatkan posisi pemain bola basket yang berbeda:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mengisi otomatis nilai di kolom B agar berisi &#8220;Ya&#8221; jika nilai di kolom A adalah &#8220;Simpan&#8221; atau &#8220;Tidak&#8221; jika nilai di kolom A adalah nilai lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #3366ff;\">A2<\/span> =\"Guard\", \"Yes\", \"\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai di kolom B secara otomatis diisi berdasarkan nilai terkait di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sel <strong>A2<\/strong> berisi \u201cPenjaga\u201d, jadi sel <strong>B2<\/strong> diisi dengan \u201cYa\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sel <strong>A3<\/strong> berisi \u201cPenjaga\u201d, jadi sel <strong>B3<\/strong> diisi dengan \u201cYa\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sel <strong>A4<\/strong> tidak berisi \u201cPenjaga\u201d, jadi sel <strong>B4<\/strong> tetap kosong<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat membuat aturan pengisian otomatis yang lebih kompleks jika diinginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk otomatis mengisi &#8220;Ya&#8221; jika nilai di sel <strong>A2<\/strong> adalah Guard <em>atau<\/em> Forward:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(OR( <span style=\"color: #3366ff;\">A2<\/span> =\"Guard\", <span style=\"color: #3366ff;\">A2<\/span> =\"Forward\"),\"Yes\",\"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan &#8220;Ya&#8221; jika sel terkait di kolom A sama dengan Penjaga <em>atau<\/em> Depan, jika tidak, sel tersebut tetap kosong.<\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mengisi Tanggal Secara Otomatis di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/alfabet-isi-otomatis-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mengisi Otomatis Huruf Alfabet di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Cara mengisi otomatis nilai dari lembar lain di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara mengisi otomatis menggunakan daftar kustom di Excel<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mengisi sel secara otomatis di Excel berdasarkan nilai sel lain. Hal ini mudah dilakukan dengan menggunakan fungsi IF dan contoh berikut menunjukkan cara melakukannya. Contoh: Cara Mengisi Sel Secara Otomatis Berdasarkan Nilai Sel Lain di Excel Misalkan kita memiliki kolom berikut di Excel yang memperlihatkan posisi pemain bola basket yang berbeda: [&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>Excel: Cara mengisi sel secara otomatis berdasarkan nilai sel lain - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi sel secara otomatis di Excel berdasarkan nilai sel lain, beserta sebuah 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\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengisi sel secara otomatis berdasarkan nilai sel lain - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi sel secara otomatis di Excel berdasarkan nilai sel lain, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T02:47:35+00:00\" \/>\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\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/\",\"name\":\"Excel: Cara mengisi sel secara otomatis berdasarkan nilai sel lain - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T02:47:35+00:00\",\"dateModified\":\"2023-07-03T02:47:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi sel secara otomatis di Excel berdasarkan nilai sel lain, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengisi sel secara otomatis berdasarkan nilai sel lain\"}]},{\"@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":"Excel: Cara mengisi sel secara otomatis berdasarkan nilai sel lain - Statologi","description":"Tutorial ini menjelaskan cara mengisi sel secara otomatis di Excel berdasarkan nilai sel lain, beserta sebuah 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\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengisi sel secara otomatis berdasarkan nilai sel lain - Statologi","og_description":"Tutorial ini menjelaskan cara mengisi sel secara otomatis di Excel berdasarkan nilai sel lain, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-03T02:47:35+00:00","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\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/","url":"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/","name":"Excel: Cara mengisi sel secara otomatis berdasarkan nilai sel lain - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T02:47:35+00:00","dateModified":"2023-07-03T02:47:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi sel secara otomatis di Excel berdasarkan nilai sel lain, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sel-isi-otomatis-excel-berdasarkan-sel-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengisi sel secara otomatis berdasarkan nilai sel lain"}]},{"@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\/5128"}],"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=5128"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5128\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}