{"id":2130,"date":"2023-09-30T04:50:34","date_gmt":"2023-09-30T04:50:34","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/saya-untuk\/"},"modified":"2023-12-06T06:18:25","modified_gmt":"2023-12-06T06:18:25","slug":"saya-untuk","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/saya-untuk\/","title":{"rendered":"Bagaimana cara menggunakan if dengan or di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3388475077\"><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>OR<\/strong> dengan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan VBA IF<\/a> untuk menguji beberapa kondisi. Saat Anda menggunakannya, ini memungkinkan Anda menguji dua atau lebih kondisi secara bersamaan dan <strong>mengembalikan nilai true jika salah satu kondisi ini benar<\/strong> . Tetapi jika semua kondisi salah, maka hasilnya akan salah.<\/p><h2 class=\"wp-block-heading\"> Menggunakan OR dengan IF<\/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 OR 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-57529\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-jika-atau-kondisi\" width=\"728\" height=\"142\"><\/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() 'two conditions to test using OR If 1 = 1 Or 2 &lt; 1 Then MsgBox \"One of the conditions is true.\" Else MsgBox \"None 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-57530\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-specifie-deux-conditions.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"581\" height=\"488\"><\/figure><\/div><p> Jika Anda melihat contoh di atas, kami telah menentukan dua kondisi, satu jika (1 = 1) dan yang kedua adalah (2 &lt; 1), dan di sini hanya kondisi pertama yang benar, dan bahkan jika baris kode yang kami eksekusi dieksekusi. ditentukan jika hasilnya benar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57531\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-la-premiere-condition-est-vraie.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"242\" height=\"192\"><\/figure><\/div><p> Sekarang mari kita lihat apakah kedua kondisi tersebut salah, izinkan saya menggunakan kode yang berbeda di sini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'two conditions to test using OR If 1 = 2 Or 2 &lt; 1 Then MsgBox \"One of the conditions is true.\" Else MsgBox \"None 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-57532\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-les-deux-conditions-sont-fausses.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"546\" height=\"475\"><\/figure><\/div><p> Pada kode di atas, kedua kondisi tersebut salah, dan saat Anda <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan kode ini<\/a> , baris kode yang kami tentukan akan dijalankan jika hasilnya salah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57533\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-specifie-si-le-resultat-est-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"233\" height=\"172\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Berbagai kondisi dengan IF OR<\/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 myMacro() 'three conditions to test using OR If 1 = 1 And 2 &gt; 1 And 1 - 1 = 0 Then MsgBox \"one of the conditions is true.\" Else MsgBox \"none 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-57534\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-conditions-multiples-avec-if-ou.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"555\" height=\"472\"><\/figure><\/div><p> Kami sekarang memiliki tiga kondisi untuk diuji dan kami menggunakan OR setelah kondisi kedua untuk menentukan kondisi ketiga. Seperti yang Anda pelajari di atas, saat Anda menggunakan OR, salah satu kondisi harus benar agar hasilnya menjadi benar. 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-57535\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-specifie-pour-le-vrai-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"225\" height=\"178\"><\/figure><\/div><p> Dan jika semua kondisi salah, seperti yang Anda lakukan pada kode berikut, maka hasilnya salah. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'three conditions to test using OR If 1 &lt; 1 And 2 &lt; 1 And 1 + 1 = 0 Then MsgBox \"one of the conditions is true.\" Else MsgBox \"none 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-57536\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-toutes-les-conditions-sont-fausses.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"247\" height=\"182\"><\/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-dan\/\">VBA JIKA Dan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-tidak\/\">VBA JIKA TIDAK<\/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-2130","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 OR di VBA Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dengan VBA OR, Anda dapat menguji beberapa kondisi secara bersamaan. Ini mengembalikan nilai benar jika salah satu kondisi ini benar.\" \/>\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\/saya-untuk\/\" \/>\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 OR di VBA Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dengan VBA OR, Anda dapat menguji beberapa kondisi secara bersamaan. Ini mengembalikan nilai benar jika salah satu kondisi ini benar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/saya-untuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.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\/saya-untuk\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/saya-untuk\/\",\"name\":\"Bagaimana cara menggunakan IF dengan OR di VBA Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/saya-untuk\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/saya-untuk\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\",\"datePublished\":\"2023-09-30T04:50:34+00:00\",\"dateModified\":\"2023-12-06T06:18:25+00:00\",\"description\":\"Dengan VBA OR, Anda dapat menguji beberapa kondisi secara bersamaan. Ini mengembalikan nilai benar jika salah satu kondisi ini benar.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/saya-untuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/saya-untuk\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/saya-untuk\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/saya-untuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan if dengan or di 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 OR di VBA Excel? (Tutorial 2023)","description":"Dengan VBA OR, Anda dapat menguji beberapa kondisi secara bersamaan. Ini mengembalikan nilai benar jika salah satu kondisi ini benar.","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\/saya-untuk\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan IF dengan OR di VBA Excel? (Tutorial 2023)","og_description":"Dengan VBA OR, Anda dapat menguji beberapa kondisi secara bersamaan. Ini mengembalikan nilai benar jika salah satu kondisi ini benar.","og_url":"https:\/\/exceladvisor.org\/id\/saya-untuk\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.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\/saya-untuk\/","url":"https:\/\/exceladvisor.org\/id\/saya-untuk\/","name":"Bagaimana cara menggunakan IF dengan OR di VBA Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/saya-untuk\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/saya-untuk\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","datePublished":"2023-09-30T04:50:34+00:00","dateModified":"2023-12-06T06:18:25+00:00","description":"Dengan VBA OR, Anda dapat menguji beberapa kondisi secara bersamaan. Ini mengembalikan nilai benar jika salah satu kondisi ini benar.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/saya-untuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/saya-untuk\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/saya-untuk\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/saya-untuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan if dengan or di 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\/2130","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=2130"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2130\/revisions"}],"predecessor-version":[{"id":2721,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2130\/revisions\/2721"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}