{"id":4376,"date":"2023-07-11T14:32:10","date_gmt":"2023-07-11T14:32:10","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/"},"modified":"2023-07-11T14:32:10","modified_gmt":"2023-07-11T14:32:10","slug":"google-sheet-menggabungkan-jika","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/","title":{"rendered":"Google spreadsheet: cara menggunakan rumus penggabungan if"},"content":{"rendered":"

<\/p>\n

\n

Contoh berikut menunjukkan cara menggunakan rumus penggabungan if<\/strong> di Google Spreadsheet.<\/span><\/p>\n

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

Katakanlah kita memiliki data berikut di Google Spreadsheet:<\/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

 =CONCATENATE(IF( B2<\/span> =\" Good<\/span> \", A2:B2<\/span> , \"\"))\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Google<\/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
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi CONCATENATE<\/strong> di Google Spreadsheet di sini<\/a> .<\/span><\/p>\n
 Contoh 2: Menggabungkan If (per baris)<\/span><\/strong><\/h2>\n
 Mari kita asumsikan lagi bahwa kita memiliki data berikut di Google Spreadsheet:<\/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
 =ARRAYFORMULA(TEXTJOIN(\"\", FALSE<\/span> ,IF( B2:B7<\/span> =\" Good<\/span> \", 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
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menghapus substring di Google Sheets<\/a>
 Cara mengekstrak angka dari string di Google Sheets<\/a>
 Cara memilih baris yang berisi string di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Contoh berikut menunjukkan cara menggunakan rumus penggabungan if di Google Spreadsheet. Contoh 1: Menggabungkan If (menurut kolom) Katakanlah kita memiliki data berikut di Google Spreadsheet: Kita bisa menggunakan rumus berikut untuk menggabungkan sel di kolom A dan B hanya jika nilai di kolom B sama dengan “Baik”: =CONCATENATE(IF( B2 =” Good “, A2:B2 , “”)) […]<\/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":"\nGoogle Spreadsheet: Cara menggunakan rumus penggabungan If - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus untuk "menggabungkan jika" di Google Spreadsheet, beserta contohnya.\" \/>\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\/google-sheet-menggabungkan-jika\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menggunakan rumus penggabungan If - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus untuk "menggabungkan jika" di Google Spreadsheet, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T14:32:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cs1.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\/google-sheet-menggabungkan-jika\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/\",\"name\":\"Google Spreadsheet: Cara menggunakan rumus penggabungan If - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T14:32:10+00:00\",\"dateModified\":\"2023-07-11T14:32:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus untuk "menggabungkan jika" di Google Spreadsheet, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: 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":"Google Spreadsheet: Cara menggunakan rumus penggabungan If - Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus untuk "menggabungkan jika" di Google Spreadsheet, beserta contohnya.","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\/google-sheet-menggabungkan-jika\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menggunakan rumus penggabungan If - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus untuk "menggabungkan jika" di Google Spreadsheet, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/","og_site_name":"Statorials","article_published_time":"2023-07-11T14:32:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cs1.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\/google-sheet-menggabungkan-jika\/","url":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/","name":"Google Spreadsheet: Cara menggunakan rumus penggabungan If - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T14:32:10+00:00","dateModified":"2023-07-11T14:32:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus untuk "menggabungkan jika" di Google Spreadsheet, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: 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\/4376"}],"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=4376"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4376\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}