{"id":1755,"date":"2023-11-06T23:45:43","date_gmt":"2023-11-06T23:45:43","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/"},"modified":"2023-12-06T06:13:08","modified_gmt":"2023-12-06T06:13:08","slug":"membandingkan-dua-sel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/","title":{"rendered":"Bagaimana cara membandingkan dua sel di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4097817764\"><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>Untuk membandingkan dua sel di Excel, Anda bisa menggunakan operator sama dengan saat merujuk ke kedua sel. Dan hasilnya akan mendapatkan TRUE jika kedua nilainya sama dan jika nilainya tidak sama maka akan mendapatkan FALSE pada hasilnya.<\/p><p> Dalam contoh berikut, kita memiliki dua nilai masing-masing di sel A1 dan B1, dan sekarang Anda perlu membandingkan kedua sel tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70595\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-dua-sel\" width=\"383\" height=\"276\"><\/figure><\/div><p> Dalam tutorial ini, kita akan menemukan berbagai metode yang dapat Anda gunakan.<\/p><h2 class=\"wp-block-heading\"> Bandingkan dua sel menggunakan operator sama dengan<\/h2><ol type=\"1\"><li> Pertama, di sel C1, masukkan operator sama dengan untuk memulai rumus.<\/li><li> Setelah itu, rujuk ke sel A1 tempat kita memiliki nilai pertama.<\/li><li> Selanjutnya, masukkan operator sama dengan untuk membandingkan nilai sel.<\/li><li> Sekarang rujuk ke sel B1 tempat Anda memiliki nilai kedua.<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70596\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-comparer-les-cellules-en-utilisant-loperateur-egal.png\" sizes=\"auto, \" srcset=\"\" alt=\"bandingkan-sel-menggunakan-operator yang sama\" width=\"394\" height=\"283\"><\/figure><\/div><p> Seperti yang Anda lihat, pada hasilnya kita mendapatkan FALSE yang artinya kedua nilai di dalam sel tersebut tidak sama. Namun jika Anda mengubah nilai sel B1 menjadi \u201cYa\u201d, Anda akan mendapatkan hasil BENAR. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70597\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Resultat-de-3-cellules-comparees.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil sel dibandingkan\" width=\"417\" height=\"277\"><\/figure><\/div><p> Oleh karena itu, ini adalah cara cepat dan mudah untuk membandingkan dua sel dan mendapatkan hasil TRUE atau FALSE.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1=B1<\/code><\/pre><h2 class=\"wp-block-heading\"> Menggunakan fungsi EXACT untuk mencocokkan nilai teks dari dua sel<\/h2><p> Ada juga fungsi di Excel yang bisa Anda gunakan, yaitu EXACT. Dengan fungsi EXACT, cocokkan nilai teks dari dua sel dan Anda dapat merujuk ke sel yang ingin Anda bandingkan, dan hasilnya akan menghasilkan TRUE atau FALSE.<\/p><p> Kami menggunakan contoh yang sama:<\/p><ol type=\"1\"><li> Pertama, di sel C1, masukkan fungsi EXACT.<\/li><li> Setelah itu, lihat sel A1.<\/li><li> Kemudian masukkan perintah.<\/li><li> Sekarang lihat sel B1.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70598\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonctions-exactes-a-comparer.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi yang tepat untuk dibandingkan\" width=\"446\" height=\"252\"><\/figure><\/div><p> Anda dapat melihat bahwa kami memiliki hasil FALSE karena nilai di sel A1 dan B1 tidak sama.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EXACT(A1,B1)<\/code><\/pre><h2 class=\"wp-block-heading\"> Menggunakan fungsi IF Create Condition untuk membandingkan dua nilai<\/h2><p> Dalam kedua metode yang kita bahas di atas, kita mendapatkan hasil TRUE atau FALSE, tetapi bagaimana jika Anda ingin mendapatkan hasil khusus untuk kedua kasus tersebut? Dalam hal ini, Anda dapat menggunakan fungsi IF untuk membuat kondisi dan mendapatkan hasil khusus.<\/p><ol type=\"1\"><li> Pertama, di sel C1, masukkan fungsi IF.<\/li><li> Setelah itu, gunakan metode yang sama untuk membandingkan sel yang kita gunakan pada metode pertama.<\/li><li> Kemudian, pada argumen kedua fungsi tersebut, masukkan nilai yang ingin Anda peroleh jika kedua nilai tersebut cocok.<\/li><li> Sekarang, di argumen ketiga dari fungsi tersebut, masukkan nilai yang ingin Anda dapatkan jika kedua nilai tersebut tidak cocok.<\/li><li> Pada akhirnya, masukkan tanda kurung penutup dan tutup fungsinya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70599\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-utilisation-si-comparaison-de-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-jika-sel perbandingan\" width=\"537\" height=\"252\"><\/figure><\/div><p> Seperti yang Anda lihat, pada hasil kami memiliki nilai \u201cTidak cocok\u201d karena nilai kedua sel tidak sama.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(A1=B1,\"Matched\",\"Not Matched\")<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/9-comparer-deux-cellules.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><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\/peringkat-bersyarat-peringkat-produk-jika\/\">Pemeringkatan Bersyarat di Excel Menggunakan Fungsi SUMPRODUK [RANKIF].<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kondisi-dalam-jumlah-produk\/\">SUMPRODUK IF untuk membuat rumus kondisional 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-1755","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>Bagaimana cara membandingkan dua sel di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara membandingkan dua sel satu sama lain. Anda juga mempelajari fungsi untuk ini...\" \/>\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\/membandingkan-dua-sel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membandingkan dua sel di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, Anda akan mempelajari cara membandingkan dua sel satu sama lain. Anda juga mempelajari fungsi untuk ini...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.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\/membandingkan-dua-sel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/\",\"name\":\"Bagaimana cara membandingkan dua sel di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png\",\"datePublished\":\"2023-11-06T23:45:43+00:00\",\"dateModified\":\"2023-12-06T06:13:08+00:00\",\"description\":\"Dalam tutorial rumus ini, Anda akan mempelajari cara membandingkan dua sel satu sama lain. Anda juga mempelajari fungsi untuk ini...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membandingkan dua sel di excel?\"}]},{\"@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":"Bagaimana cara membandingkan dua sel di Excel? - Penasihat Excel","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara membandingkan dua sel satu sama lain. Anda juga mempelajari fungsi untuk ini...","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\/membandingkan-dua-sel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membandingkan dua sel di Excel? - Penasihat Excel","og_description":"Dalam tutorial rumus ini, Anda akan mempelajari cara membandingkan dua sel satu sama lain. Anda juga mempelajari fungsi untuk ini...","og_url":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.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\/membandingkan-dua-sel\/","url":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/","name":"Bagaimana cara membandingkan dua sel di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png","datePublished":"2023-11-06T23:45:43+00:00","dateModified":"2023-12-06T06:13:08+00:00","description":"Dalam tutorial rumus ini, Anda akan mempelajari cara membandingkan dua sel satu sama lain. Anda juga mempelajari fungsi untuk ini...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comparer-deux-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/membandingkan-dua-sel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membandingkan dua sel di excel?"}]},{"@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\/1755","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=1755"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1755\/revisions"}],"predecessor-version":[{"id":2268,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1755\/revisions\/2268"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}