{"id":1771,"date":"2023-11-06T00:19:21","date_gmt":"2023-11-06T00:19:21","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tidak-sama\/"},"modified":"2023-12-06T06:18:42","modified_gmt":"2023-12-06T06:18:42","slug":"tidak-sama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tidak-sama\/","title":{"rendered":"Bagaimana cara menggunakan operator tidak sama di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1186597845\"><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, jika Anda ingin memeriksa apakah suatu nilai sel tidak sama dengan nilai lainnya, Anda dapat menggunakan operator lain \u201c&lt;&gt;\u201d. Ia mengembalikan FALSE jika nilainya cocok dan TRUE jika tidak cocok. Anda bisa menggunakannya sebagai rumus, atau Anda juga bisa menggunakannya dengan fungsi lain seperti IF, OR, dan AND.<\/p><p> Dalam contoh berikut, Anda memiliki dua nilai di sel A1 dan A2 dan Anda perlu memeriksa apakah nilai 1 tidak sama dengan nilai 2. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69533\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"dua nilai dalam sel\" width=\"363\" height=\"274\"><\/figure><\/div><h2 id=\"h-using-does-not-equals-operator\" class=\"wp-block-heading\"> Menggunakan operator TIDAK SAMA<\/h2><ol type=\"1\"><li> Pertama, di sel B1, masukkan operator sama dengan.<\/li><li> Setelah itu, rujuk ke sel A1 tempat Anda memiliki nilai pertama.<\/li><li> Selanjutnya, masukkan operator non-\u201c&lt;&gt;\u201d.<\/li><li> Sekarang lihat nilai kedua yang kita miliki di sel A2.<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan nilainya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69534\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-loperateur-non-egal-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-tidak-sama-operator\" width=\"379\" height=\"279\"><\/figure><\/div><p> Saat Anda menekan Enter, hasilnya adalah TRUE. Hal ini dikarenakan kedua nilai tersebut tidak sama. Sekarang jika Anda memasukkan \u201cExcel\u201d di sel B1, hasil yang kita dapatkan di sel A1 menjadi FALSE. Alasannya karena kita memiliki nilai yang sama di kedua sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69535\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-changer-la-valeur-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah nilai dalam sel\" width=\"403\" height=\"272\"><\/figure><\/div><h2 id=\"h-using-does-not-equal-with-or-and\" class=\"wp-block-heading\"> Penggunaan TIDAK SAMA dengan OR \u2013 AND<\/h2><p> Seperti yang saya katakan, Anda juga dapat menggunakan operator berbeda dengan fungsi lainnya. Mari kita coba menggunakannya dengan fungsi AND dan OR.<\/p><p> Dengan fungsi OR Anda dapat menguji dua kondisi dan akan menghasilkan TRUE jika salah satu atau kedua kondisi sama. Dalam contoh berikut, kami memiliki dua kondisi untuk diuji. Perbandingan nilai sel A1 dan A2, lalu B1 dan B2. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69536\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-operateur-non-egal-avec-ou.png\" sizes=\"auto, \" srcset=\"\" alt=\"tidak-sama-operator-dengan-atau\" width=\"512\" height=\"269\"><\/figure><\/div><p> Sekarang karena kita menggunakan operator tidak sama pada kedua kondisi, dan pada kondisi pertama kedua nilainya tidak sama, sehingga mengembalikan TRUE. Namun setelah itu pada kondisi kedua nilainya sama, sehingga kondisinya FALSE.<\/p><p> Namun hasilnya kita mendapatkan TRUE, karena seperti yang kita lihat, OR mengembalikan TRUE jika hanya satu kondisi yang TRUE.<\/p><p> Kemudian gunakan hal yang sama dengan fungsi AND. AND mengembalikan TRUE jika semua kondisi yang ditentukan sama, dan FALSE meskipun ada satu kondisi yang FALSE di antara semua kondisi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69537\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-pas-egal-a-loperateur-avec-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"tidak-sama-operator-dengan-akhir\" width=\"473\" height=\"271\"><\/figure><\/div><p> Pada contoh di atas, sekali lagi kita memiliki nilai yang sama, tetapi ketika Anda menggunakan fungsi AND, hasilnya akan kembali FALSE karena kondisi kedua (B1&lt;&gt;B2) tidak benar, kedua nilai tersebut identik.<\/p><h2 id=\"h-use-does-not-equal-operator-with-if-function\" class=\"wp-block-heading\"> Menggunakan operator NOT EQUAL dengan fungsi IF<\/h2><p> Anda juga dapat menggunakan operator tidak sama dalam fungsi IF. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69538\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-pas-egal-a-loperateur-avec-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"tidak-sama-operator-dengan-jika\" width=\"538\" height=\"268\"><\/figure><\/div><ol type=\"1\"><li> Masukkan fungsi IF di sel tempat Anda ingin mendapatkan hasilnya.<\/li><li> Setelah itu rujuk ke sel A1, lalu gunakan operator lain dan rujuk ke sel A2.<\/li><li> Kemudian gunakan nilai untuk mengetahui apakah kondisinya BENAR.<\/li><li> Pada akhirnya, tentukan nilainya jika kondisinya FALSE.<\/li><\/ol><p> Hal terbaik dalam menggunakan IF dengan kondisi &#8220;tidak sama&#8221; adalah Anda dapat mengembalikan nilai tertentu yang Anda peroleh jika kondisinya TRUE atau FALSE. <\/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\"> Dapatkan file Excelnya<\/h2> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/nest-pas-egal-a-2.xlsx\">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> Hitung akar pangkat tiga di Excel<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbedaan-persentase\/\">Hitung persen varians (selisih) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/akar-pangkat-dua\/\">Hitung Akar Pangkat Dua di Excel + Sisipkan Simbol<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nomor-persegi\/\">Kuadratkan angka di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-kurangi-persentase-dari-suatu-angka\/\">Tambahkan-kurangi persentase suatu angka<\/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-1771","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 operator tidak sama di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara membuat rumus untuk menggunakan operator tidak sama dengan di Excel. Operator ini adalah...\" \/>\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\/tidak-sama\/\" \/>\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 operator tidak sama di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara membuat rumus untuk menggunakan operator tidak sama dengan di Excel. Operator ini adalah...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tidak-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-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\/tidak-sama\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tidak-sama\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan operator tidak sama di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-sama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-sama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png\",\"datePublished\":\"2023-11-06T00:19:21+00:00\",\"dateModified\":\"2023-12-06T06:18:42+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara membuat rumus untuk menggunakan operator tidak sama dengan di Excel. Operator ini adalah...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tidak-sama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-sama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tidak-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan operator tidak sama 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":"\u25b7 Bagaimana cara menggunakan operator tidak sama di Excel?","description":"Dalam tutorial ini, Anda akan mempelajari cara membuat rumus untuk menggunakan operator tidak sama dengan di Excel. Operator ini adalah...","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\/tidak-sama\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan operator tidak sama di Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara membuat rumus untuk menggunakan operator tidak sama dengan di Excel. Operator ini adalah...","og_url":"https:\/\/exceladvisor.org\/id\/tidak-sama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:42+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-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\/tidak-sama\/","url":"https:\/\/exceladvisor.org\/id\/tidak-sama\/","name":"\u25b7 Bagaimana cara menggunakan operator tidak sama di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-sama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-sama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png","datePublished":"2023-11-06T00:19:21+00:00","dateModified":"2023-12-06T06:18:42+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara membuat rumus untuk menggunakan operator tidak sama dengan di Excel. Operator ini adalah...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tidak-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tidak-sama\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tidak-sama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deux-valeurs-dans-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tidak-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan operator tidak sama 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\/1771","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=1771"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1771\/revisions"}],"predecessor-version":[{"id":2759,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1771\/revisions\/2759"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}