{"id":2773,"date":"2023-07-20T18:45:17","date_gmt":"2023-07-20T18:45:17","guid":{"rendered":"https:\/\/statorials.org\/id\/gabungan-excel-jika\/"},"modified":"2023-07-20T18:45:17","modified_gmt":"2023-07-20T18:45:17","slug":"gabungan-excel-jika","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/gabungan-excel-jika\/","title":{"rendered":"Excel: cara menggunakan rumus penggabungan if"},"content":{"rendered":"

<\/p>\n

\n

Contoh berikut memperlihatkan cara menggunakan rumus penggabungan if<\/strong> di Excel.<\/span><\/p>\n

Contoh 1: Menggabungkan If (menurut kolom)<\/span><\/strong><\/h3>\n

Misalkan kita memiliki data berikut di Excel:<\/span> <\/p>\n

\"\"
Kita bisa menggunakan rumus berikut untuk menggabungkan sel di kolom A dan B hanya jika nilai di kolom B sama dengan “Baik”:<\/span><\/p>\n

 =CONCAT(IF( B2<\/span> =\"Good\", A2:B2<\/span> , \"\"))\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Gabungkan<\/p>\n
 Jika sel pada kolom B sama dengan \u201cBaik\u201d maka nilai pada kolom C sama dengan gabungan sel pada kolom A dan B.<\/span><\/p>\n
 Jika tidak, rumus ini hanya mengembalikan nilai kosong.<\/span><\/p>\n
 Contoh 2: Menggabungkan If (per baris)<\/span><\/strong><\/h3>\n
 Mari kita asumsikan lagi bahwa kita memiliki data berikut di Excel:<\/span> <\/p>\n
\"\"
 Kita bisa menggunakan rumus berikut untuk menggabungkan semua sel di kolom A yang nilai di kolom B sama dengan “Baik”:<\/span><\/p>\n
 =CONCAT(IF( B2:B7<\/span> =\"Good\", A2:A7<\/span> , \"\"))\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa nilai di sel C2<\/strong> adalah hasil penggabungan setiap nilai di kolom A dengan nilai terkait di kolom B sama dengan “Baik”.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi CONCAT<\/strong> di Excel di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: Cara menghapus teks tertentu dari sel<\/a>
 Excel: cara menghapus baris dengan teks tertentu<\/a>
Excel: cara memeriksa apakah sel berisi sebagian teks<\/a>
 Excel: cara memeriksa apakah sel berisi teks daftar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Contoh berikut memperlihatkan cara menggunakan rumus penggabungan if di Excel. Contoh 1: Menggabungkan If (menurut kolom) Misalkan kita memiliki data berikut di Excel: Kita bisa menggunakan rumus berikut untuk menggabungkan sel di kolom A dan B hanya jika nilai di kolom B sama dengan “Baik”: =CONCAT(IF( B2 =”Good”, A2:B2 , “”)) Tangkapan layar berikut menunjukkan […]<\/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":"\nExcel: Cara menggunakan rumus gabungan If - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus penggabungan if di Excel, 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\/gabungan-excel-jika\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan rumus gabungan If - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus penggabungan if di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/gabungan-excel-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T18:45:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatif1.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\/gabungan-excel-jika\/\",\"url\":\"https:\/\/statorials.org\/id\/gabungan-excel-jika\/\",\"name\":\"Excel: Cara menggunakan rumus gabungan If - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T18:45:17+00:00\",\"dateModified\":\"2023-07-20T18:45:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus penggabungan if di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/gabungan-excel-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/gabungan-excel-jika\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/gabungan-excel-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan rumus penggabungan if\"}]},{\"@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 menggunakan rumus gabungan If - Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus penggabungan if di Excel, 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\/gabungan-excel-jika\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan rumus gabungan If - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus penggabungan if di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/gabungan-excel-jika\/","og_site_name":"Statorials","article_published_time":"2023-07-20T18:45:17+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/concatif1.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\/gabungan-excel-jika\/","url":"https:\/\/statorials.org\/id\/gabungan-excel-jika\/","name":"Excel: Cara menggunakan rumus gabungan If - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T18:45:17+00:00","dateModified":"2023-07-20T18:45:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus penggabungan if di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/gabungan-excel-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/gabungan-excel-jika\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/gabungan-excel-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan rumus penggabungan if"}]},{"@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\/2773"}],"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=2773"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2773\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}