{"id":1747,"date":"2023-11-07T21:54:41","date_gmt":"2023-11-07T21:54:41","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/benar-salah\/"},"modified":"2023-11-07T21:54:41","modified_gmt":"2023-11-07T21:54:41","slug":"benar-salah","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/benar-salah\/","title":{"rendered":"True dan false di excel (nilai boolean)"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-215365318\"><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>TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya 1 = 1 BENAR dan 1 = 2 SALAH. Dalam kedua kasus tersebut kami memiliki nilai Boolean yang membantu Anda memahami hasilnya. Ini juga disebut nilai kebenaran.<\/p><p> Di Excel, ada dua cara untuk menggunakan nilai Boolean ini.<\/p><ul><li> Anda memasukkannya ke dalam sel.<\/li><li> Anda mendapatkannya kembali sesuai kebutuhan.<\/li><\/ul><p> Dalam kebanyakan kasus (saat bekerja di Excel), Anda tidak perlu memasukkannya secara manual ke dalam sel. Dan ada beberapa cara lain yang bisa Anda gunakan untuk mendapatkan TRUE dan FALSE dalam sel yang sesuai.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> TRUE dan FALSE masing-masing setara dengan 1 dan 0.<\/p><h2 class=\"wp-block-heading\"> Gunakan fungsi TRUE dan FALSE<\/h2><p> Anda memiliki dua fungsi spesifik di Excel, TRUE dan FALSE, untuk mendapatkan dua nilai Boolean. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89018\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"benar atau salah di excel\" width=\"378\" height=\"256\"><\/figure><\/div><p> Dalam fungsi ini, Anda tidak perlu menentukan argumen apa pun dalam fungsi tersebut.<\/p><pre class=\"wp-block-preformatted\"> =TRUE()\n=FALSE()<\/pre><h2 class=\"wp-block-heading\"> Dapatkan hasilnya dengan menguji pada kondisi<\/h2><p> Saat Anda menguji suatu kondisi, hasilnya selalu TURE atau FALSE. Dan ini adalah situasi di mana Anda banyak berurusan dengan TRUE dan FALSE di Excel.<\/p><p> Jika Anda menguji 1 = 1, rumus Anda akan menghasilkan TRUE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89019\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-renvoie-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-mengembalikan-benar\" width=\"427\" height=\"239\"><\/figure><\/div><p> Namun jika Anda menguji 1=2, rumus Anda mengembalikan FALSE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89020\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-formule-renvoie-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-pengembalian-salah\" width=\"423\" height=\"201\"><\/figure><\/div><p> TRUE dan FALSE merupakan dasar untuk menyatakan hasil suatu kondisi di Excel. Padahal fungsi IF di Excel juga berfungsi dengan TRUE dan FALSE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89021\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-vrai-et-faux-expriment-le-resultat-de-la-condition.png\" sizes=\"auto, \" srcset=\"\" alt=\"benar-dan-salah-menyatakan-akibat-kondisi-itu\" width=\"266\" height=\"128\"><\/figure><\/div><p> Semua kerja fungsi IF didasarkan pada nilai TRUE dan FALSE.<\/p><h2 class=\"wp-block-heading\"> Menggunakan operator logika<\/h2><p> Di Excel, Anda memiliki operator logika yang membantu Anda mendapatkan kondisi pengujian. Operator logika ini juga mengembalikan hasil dalam nilai TRUE dan FALSE.<\/p><ul><li> Lebih besar dari &lt;<\/li><li> Kurang dari&gt;<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tidak-sama\/\">Tidak sama dengan<\/a> &lt;&gt; <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89022\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-utiliser-des-operations-logiques.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggunakan operasi logis\" width=\"530\" height=\"306\"><\/figure><\/div><p> Bahkan menguji nilai pengujian satu sama lain kita mendapatkan hasil BENAR atau SALAH.<\/p><h2 class=\"wp-block-heading\"> Konversi BENAR-SALAH menjadi 1-0<\/h2><p> Ada dua cara untuk mengubah nilai Boolean menjadi 0 dan 1.<\/p><ul><li> Fungsi N<\/li><li> Tanda minus ganda <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89023\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-convertir-vrai-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"konversi-benar-salah\" width=\"732\" height=\"160\"><\/figure><\/div><p> Pada contoh di atas, pertama-tama kita menggunakan fungsi N, lalu tanda minus ganda (\u2013), dan keduanya mengonversi TRUE dan FALSE menjadi 1 dan 0.<\/p><p> Dari kedua metode tersebut, hanya ada sedikit manfaat menggunakan tanda minus ganda. Misalnya, jika Anda ingin menghitung sel dengan TRUE, Anda bisa menggunakannya dengan SUM. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89024\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-converti-vrai-et-faux-en-1-et-0.png\" sizes=\"auto, \" srcset=\"\" alt=\"dikonversi-benar-dan-salah-ke-1-dan-0\" width=\"448\" height=\"321\"><\/figure><\/div><figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\"> &gt; <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/FAUX.xlsx\"><strong>Unduh file contoh<\/strong><\/a><\/div><\/figure>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1747","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 BENAR dan SALAH di Excel (Nilai Boolean)<\/title>\n<meta name=\"description\" content=\"Di Excel, TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya...\" \/>\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\/benar-salah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 BENAR dan SALAH di Excel (Nilai Boolean)\" \/>\n<meta property=\"og:description\" content=\"Di Excel, TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/benar-salah\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.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\/benar-salah\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/benar-salah\/\",\"name\":\"\u25b7 BENAR dan SALAH di Excel (Nilai Boolean)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/benar-salah\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/benar-salah\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png\",\"datePublished\":\"2023-11-07T21:54:41+00:00\",\"description\":\"Di Excel, TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/benar-salah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/benar-salah\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/benar-salah\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/benar-salah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"True dan false di excel (nilai boolean)\"}]},{\"@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 BENAR dan SALAH di Excel (Nilai Boolean)","description":"Di Excel, TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya...","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\/benar-salah\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 BENAR dan SALAH di Excel (Nilai Boolean)","og_description":"Di Excel, TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya...","og_url":"https:\/\/exceladvisor.org\/id\/benar-salah\/","og_site_name":"Excel Advisor","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.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\/benar-salah\/","url":"https:\/\/exceladvisor.org\/id\/benar-salah\/","name":"\u25b7 BENAR dan SALAH di Excel (Nilai Boolean)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/benar-salah\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/benar-salah\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png","datePublished":"2023-11-07T21:54:41+00:00","description":"Di Excel, TRUE dan FALSE adalah nilai Boolean. Kedua nilai tersebut mewakili hasil dari suatu kondisi. Misalnya...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/benar-salah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/benar-salah\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/benar-salah\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vrai-ou-faux-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/benar-salah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"True dan false di excel (nilai boolean)"}]},{"@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\/1747","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=1747"}],"version-history":[{"count":0,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1747\/revisions"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}