{"id":2131,"date":"2023-09-30T04:41:34","date_gmt":"2023-09-30T04:41:34","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-dan\/"},"modified":"2023-12-06T06:18:24","modified_gmt":"2023-12-06T06:18:24","slug":"jika-dan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-dan\/","title":{"rendered":"Bagaimana cara menggunakan if dengan and di excel vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1987811562\"><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>Anda dapat menggunakan operator <strong>AND<\/strong> dengan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan IF VBA<\/a> untuk menguji beberapa kondisi, dan saat Anda menggunakannya, operator ini memungkinkan Anda menguji dua kondisi secara bersamaan dan mendapatkan nilai true jika kedua kondisi ini benar. Dan, jika salah satu kondisinya salah, hasilnya akan salah.<\/p><h2 class=\"wp-block-heading\"> Gabungkan JIKA DAN<\/h2><ol type=\"1\"><li> Pertama, awali pernyataan IF dengan kata kunci \u201cIF\u201d.<\/li><li> Setelah itu tentukan kondisi pertama yang ingin Anda uji.<\/li><li> Kemudian gunakan kata kunci AND untuk menentukan kondisi kedua<\/li><li> Pada akhirnya, tentukan kondisi kedua yang ingin Anda uji. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57514\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\" sizes=\"auto, \" srcset=\"\" alt=\"pernyataan vba-if\" width=\"819\" height=\"119\"><\/figure><\/div><p> Untuk lebih memahaminya, mari kita lihat sebuah contoh. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If 1 = 1 And 2 &gt; 1 Then MsgBox \"Both of the conditions are true.\" Else MsgBox \"Maybe one or both of the conditions are true.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-vba-si-exemple-dinstruction.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"678\" height=\"351\"><\/figure><\/div><p> Jika Anda melihat contoh di atas, kami telah menetapkan dua kondisi, satu jika (1 = 1) dan yang kedua adalah (2 &gt; 1) dan di sini kedua kondisi tersebut benar, dan itulah sebabnya ia mengeksekusi baris kode yang kami tentukan jika hasilnya benar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57516\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-execute-la-ligne-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"232\" height=\"173\"><\/figure><\/div><p> Sekarang, jika salah satu dari kedua kondisi ini salah, izinkan saya menggunakan kode berbeda di sini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() If 1 = 1 And 2 &lt; 1 Then MsgBox \"Both of the conditions are true.\" Else MsgBox \"Maybe one or both of the conditions are true.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57517\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-deuxieme-condition-est-fausse.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"655\" height=\"351\"><\/figure><\/div><p> Pada kode di atas, kondisi kedua adalah salah (2 &lt; 1) dan ketika Anda <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan makro ini<\/a> , ia akan mengeksekusi baris kode yang kami tentukan jika hasilnya salah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57518\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-le-resultat-est-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"352\" height=\"192\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Berbagai kondisi dengan IF AND<\/h2><p> Demikian pula, Anda juga dapat menguji lebih dari dua kondisi secara bersamaan. Mari lanjutkan contoh di atas dan tambahkan kondisi ketiga ke dalamnya. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() If 1 = 1 And 2 &gt; 1 And 1 - 1 = 0 Then MsgBox \"All the conditions are true.\" Else MsgBox \"Some conditions are false.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57519\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-conditions-multiples-avec-if-et.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"521\" height=\"374\"><\/figure><\/div><p> Kami sekarang memiliki tiga kondisi untuk diuji dan kami menggunakan AND setelah kondisi kedua untuk menentukan kondisi ketiga. Seperti yang Anda pelajari di atas, saat menggunakan AND, semua kondisi harus benar agar hasilnya menjadi benar.<\/p><p> Saat Anda menjalankan kode ini, ia mengeksekusi baris kode yang kami tentukan sebagai true. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-specifie-pour-le-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"211\" height=\"178\"><\/figure><\/div><p> Dan jika salah satu kondisinya salah, seperti yang Anda lakukan pada kode berikut, kondisinya akan kembali salah. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro3() If 1 = 1 And 2 &lt; 1 And 1 + 1 = 0 Then MsgBox \"All the conditions are true.\" Else MsgBox \"Some conditions are false.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-condition-est-fausse.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"221\" height=\"188\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/keluar-jika\/\">VBA Keluar JIKA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">VBA JIKA (JIKA maka yang lain)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-tidak\/\">VBA JIKA TIDAK<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/saya-untuk\/\">VBA JIKA ATAU<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sarang-jika\/\">IF bersarang VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2131","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 menggunakan IF dengan AND di Excel VBA? Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Anda dapat menggunakan operator AND dengan pernyataan IF VBA untuk menguji beberapa kondisi, dan ketika Anda menggunakannya, itu memungkinkan Anda\" \/>\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\/jika-dan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan IF dengan AND di Excel VBA? Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Anda dapat menggunakan operator AND dengan pernyataan IF VBA untuk menguji beberapa kondisi, dan ketika Anda menggunakannya, itu memungkinkan Anda\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-dan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.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\/jika-dan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-dan\/\",\"name\":\"Bagaimana cara menggunakan IF dengan AND di Excel VBA? Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\",\"datePublished\":\"2023-09-30T04:41:34+00:00\",\"dateModified\":\"2023-12-06T06:18:24+00:00\",\"description\":\"Anda dapat menggunakan operator AND dengan pernyataan IF VBA untuk menguji beberapa kondisi, dan ketika Anda menggunakannya, itu memungkinkan Anda\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-dan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan if dengan and di excel vba?\"}]},{\"@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 menggunakan IF dengan AND di Excel VBA? Tutorial 2023)","description":"Anda dapat menggunakan operator AND dengan pernyataan IF VBA untuk menguji beberapa kondisi, dan ketika Anda menggunakannya, itu memungkinkan Anda","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\/jika-dan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan IF dengan AND di Excel VBA? Tutorial 2023)","og_description":"Anda dapat menggunakan operator AND dengan pernyataan IF VBA untuk menguji beberapa kondisi, dan ketika Anda menggunakannya, itu memungkinkan Anda","og_url":"https:\/\/exceladvisor.org\/id\/jika-dan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.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\/jika-dan\/","url":"https:\/\/exceladvisor.org\/id\/jika-dan\/","name":"Bagaimana cara menggunakan IF dengan AND di Excel VBA? Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-dan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-dan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png","datePublished":"2023-09-30T04:41:34+00:00","dateModified":"2023-12-06T06:18:24+00:00","description":"Anda dapat menggunakan operator AND dengan pernyataan IF VBA untuk menguji beberapa kondisi, dan ketika Anda menggunakannya, itu memungkinkan Anda","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-dan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-dan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-dan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-instruction.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-dan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan if dengan and di excel vba?"}]},{"@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\/2131","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=2131"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2131\/revisions"}],"predecessor-version":[{"id":2719,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2131\/revisions\/2719"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}