{"id":1505,"date":"2023-11-20T01:48:26","date_gmt":"2023-11-20T01:48:26","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/"},"modified":"2023-12-06T06:18:30","modified_gmt":"2023-12-06T06:18:30","slug":"menggabungkan-jika-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/","title":{"rendered":"Bagaimana cara menggunakan kombinasi if dengan syarat?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2633901119\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, ada dua metode untuk menggunakan rumus if gabungan.<\/p><ul><li> Berdasarkan kolom<\/li><li> Berdasarkan garis<\/li><\/ul><p> Dan kami memiliki dua fungsi berbeda untuk menulis rumus ini. Jadi dalam tutorial ini, kita akan mempelajari keempat metode tersebut.<\/p><h2 class=\"wp-block-heading\"> Gabungkan dengan IF menggunakan fungsi CONCAT<\/h2><h3 class=\"wp-block-heading\"> 1. Berdasarkan kolom<\/h3><p> Rumus ini cukup sederhana. Disini kita menguji apakah nilai \u201cA\u201d ada di kolom A. Dan jika ada, gabungkan nilai dari kolom A dan B. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83621\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggabungkan-dengan-jika\" width=\"506\" height=\"385\"><\/figure><\/div><p> Kami menggunakan fungsi CONCAT dan IF. Dalam fungsi IF, kami telah menentukan kondisi untuk menguji apakah nilai sel A1 adalah &#8220;A&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83622\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-concatener-et-si-combine.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggabungkan-dan-jika-menggabungkan\" width=\"344\" height=\"75\"><\/figure><\/div><p> Dan jika nilainya A, kembalikan rentang A1:B1; jika tidak, nilai kosong. Pada akhirnya, CONCAT menggunakan rentang yang dikembalikan oleh IF dan menggabungkan nilainya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(IF(A1=\"A\",A1:B1,\"\"))<\/code><\/pre><h3 class=\"wp-block-heading\"> 2. Berdasarkan baris (+ kolom)<\/h3><p> Sekarang katakanlah Anda ingin menggabungkan nilai semua baris menggunakan suatu kondisi. Dalam hal ini Anda dapat menggunakan rumus yang sama tetapi Anda harus mengacu pada keseluruhan rentang. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83623\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-de-concatenation-a-laide-dune-condition.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggabungkan-nilai-menggunakan-kondisi\" width=\"542\" height=\"401\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CONCAT(IF(A1:A4=\"A\",A1:B4,\"\"))<\/code><\/pre><p> Dalam rumus ini, IF memeriksa nilai A&#8217; di seluruh rentang A1:A4. TRUE untuk sel yang berisi nilai dan FALSE untuk sel lainnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83624\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-concat-avec-if-pour-verifier-letat.png\" sizes=\"auto, \" srcset=\"\" alt=\"concat-dengan-jika-untuk-memeriksa-kondisi\" width=\"567\" height=\"116\"><\/figure><\/div><p> Dan kemudian mengembalikan baris dari rentang A1:B4 dengan nilai &#8220;A&#8221; di kolom A. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83625\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-renvoyees-par-condition-appliquee.png\" sizes=\"auto, \" srcset=\"\" alt=\"baris-dikembalikan-berdasarkan-kondisi-diterapkan\" width=\"455\" height=\"342\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gabungkan dengan IF menggunakan fungsi TEXTJOIN<\/h2><h3 class=\"wp-block-heading\"> 1. Berdasarkan kolom<\/h3><p> Setelah Anda memasukkan fungsi TEXTJOIN, Anda perlu menentukan pembatasnya. Dan juga apakah Anda ingin mengabaikan sel kosong atau tidak. Setelah itu, Anda perlu menggunakan fungsi IF seperti yang Anda gunakan pada metode sebelumnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83626\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-concatener-avec-si-vous-utilisez-textjoin.png\" sizes=\"auto, \" srcset=\"\" alt=\"penggabungan-dengan-jika-menggunakan-textjoin\" width=\"508\" height=\"394\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\",\",TRUE,IF(A1=\"A\",A1:B1,\"\"))<\/code><\/pre><p> IF hanya mengembalikan nilai rentang jika sel di kolom A memiliki nilai &#8220;A&#8221;.<\/p><h3 class=\"wp-block-heading\"> 2. Berdasarkan baris<\/h3><p> Demikian pula, Anda dapat menggabungkan nilai dari beberapa baris menggunakan suatu kondisi.<\/p><p> Misalnya, dalam rumus di bawah, Anda telah mereferensikan seluruh rentang A1:A4 untuk kondisi yang akan diuji. Dan ke rentang A1:B4 untuk nilai yang akan digabungkan. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXTJOIN(\",\",TRUE,IF(A1:A4=\"A\",A1:B4,\"\"))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83627\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-textjoin-avec-si-par-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"textjoin-dengan-jika-demi-baris\" width=\"550\" height=\"365\"><\/figure><\/div><p> Hasilnya kita mendapatkan nilai A,1,A,3, dari sel A1, B1, A3 dan B3.<\/p><p> Dengan fungsi IF, kami menguji kondisi di kolom A. Fungsi ini mengembalikan nilai baris yang nilai sel di kolom A adalah &#8220;A&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-83628\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-concatener-la-valeur-resultante.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai-hasil-gabungan\" width=\"565\" height=\"158\"><\/figure><\/div><p> TEXTJOIN mengabaikan nilai kosong dan, menggunakan pembatas, menggabungkan semua nilai menjadi satu. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" style=\"font-size: 16px;\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a> <\/h2><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\">Centang IF 0 (nol) lalu kosongkan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/periksa-apakah-ada-nilai-dalam-suatu-rentang\/\">Periksa apakah ada nilai dalam rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\">Gabungkan fungsi IF dan AND di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">Gabungkan fungsi IF dan OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\">IF Cell kosong (kosong) menggunakan IF + ISBLANK di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1505","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menggunakan KOMBINASI IF dengan syarat?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan CONCATENATE IF. Kombinasi ini dapat berguna untuk kasus-kasus termasuk\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggunakan KOMBINASI IF dengan syarat?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan CONCATENATE IF. Kombinasi ini dapat berguna untuk kasus-kasus termasuk\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan KOMBINASI IF dengan syarat?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\",\"datePublished\":\"2023-11-20T01:48:26+00:00\",\"dateModified\":\"2023-12-06T06:18:30+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan CONCATENATE IF. Kombinasi ini dapat berguna untuk kasus-kasus termasuk\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan kombinasi if dengan syarat?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menggunakan KOMBINASI IF dengan syarat?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan CONCATENATE IF. Kombinasi ini dapat berguna untuk kasus-kasus termasuk","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:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan KOMBINASI IF dengan syarat?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan CONCATENATE IF. Kombinasi ini dapat berguna untuk kasus-kasus termasuk","og_url":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/","url":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/","name":"\u25b7 Bagaimana cara menggunakan KOMBINASI IF dengan syarat?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png","datePublished":"2023-11-20T01:48:26+00:00","dateModified":"2023-12-06T06:18:30+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel menggunakan CONCATENATE IF. Kombinasi ini dapat berguna untuk kasus-kasus termasuk","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-concatener-avec-if.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-jika-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan kombinasi if dengan syarat?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1505"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1505\/revisions"}],"predecessor-version":[{"id":2733,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1505\/revisions\/2733"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}