{"id":2141,"date":"2023-09-29T01:34:04","date_gmt":"2023-09-29T01:34:04","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sarang-jika\/"},"modified":"2023-12-06T06:16:36","modified_gmt":"2023-12-06T06:16:36","slug":"sarang-jika","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sarang-jika\/","title":{"rendered":"Bagaimana cara menggunakan fungsi if bersarang vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3548408172\"><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 VBA, Anda bisa menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan IF<\/a> di dalam pernyataan IF lainnya untuk membuat IF bertingkat. Sederhananya, Anda dapat mengeksekusi pernyataan pengujian menggunakan IF berdasarkan hasil pernyataan IF lainnya. Dalam pernyataan bersyarat jenis ini, Anda perlu menguji kondisi kompleks. Mari kita lihat contohnya: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57650\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-bersarang-jika\" width=\"388\" height=\"438\"><\/figure><\/div><p> Pada contoh di atas, kita menguji dua kondisi, kondisi1 (1+1=2) dan kondisi2 (2+2=4).<\/p><p> Namun karena pernyataan IF berada di dalam pernyataan IF, VBA akan menguji kondisi pertama terlebih dahulu, lalu melanjutkan ke IF berikutnya.<\/p><p> Pada IF kedua kita mempunyai <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> untuk menunjukkan apakah kondisinya TRUE.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() 'first if statement If 1 + 1 = 2 Then 'second if statement If 2 + 2 = 4 Then MsgBox True End If Else MsgBox False End If End Sub<\/code><\/pre><p> Berikut adalah contoh penggunaan beberapa IF dalam satu IF. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57651\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-exemple-pour-utiliser-plusieurs-ifs-dans-un-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"562\" height=\"613\"><\/figure><\/div><p> Ada perbedaan antara contoh yang kita gunakan sebelumnya dan contoh di atas: Dalam kode ini, kita menggunakan kondisi bersarang untuk &#8220;Else&#8221;.<\/p><p> Jika kondisi pertama tidak benar, VBA akan melompat ke \u201cElse\u201d dan menguji kondisi tersebut, dan jika kondisi tersebut tidak benar, maka lanjutkan ke kondisi berikutnya.<\/p><p> Dengan cara ini kita memiliki total empat kondisi untuk diuji.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() Dim myScore As Single: myScore = Range(\"A1\").Value If myScore &gt;= 80 Then MsgBox \"Excellent\" Else If myScore &gt;= 60 And myScore &lt; 80 Then MsgBox \"Good\" Else If myScore &gt;= 40 And myScore &lt; 60 Then MsgBox \"Average\" Else If myScore &lt; 40 Then MsgBox \"Poor\" End If End If End If End If End Sub<\/code><\/pre><p> Pernyataan IF bertingkat ini akan menguji skor sel A1 dan menampilkan kotak pesan yang sesuai.<\/p><h2 class=\"wp-block-heading\"> IF bersarang VBA dengan banyak baris (IF)<\/h2><p> Anda juga dapat menggunakan dua IF berbeda untuk menjalankan kedua hasil (Benar dan Salah). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57652\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-imbrique-si-avec-plusieurs-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"638\" height=\"473\"><\/figure><\/div><p> Pada contoh di atas, seperti yang Anda lihat, pertama kita mempunyai satu kondisi untuk diuji, dan jika kondisi itu BENAR, maka Anda memiliki kondisi lain untuk diuji, dan jika kondisi kedua itu BENAR, Anda akan mendapatkan kotak pesan.<\/p><p> Dan jika kondisi utama salah, Anda memiliki kondisi lain untuk diuji dan Anda akan mendapatkan kotak pesan jika kondisi tersebut benar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro3() If 1 + 1 = 2 Then If 2 - 1 = 1 Then MsgBox \"Condition1 is TRUE.\" End If Else If 3 - 2 = 1 Then MsgBox \"Condition2 is TRUE.\" End If End If End Sub<\/code><\/pre><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\/saya-untuk\/\">VBA JIKA ATAU<\/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-2141","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 fungsi IF bersarang VBA?<\/title>\n<meta name=\"description\" content=\"Anda dapat menggunakan pernyataan IF di dalam pernyataan IF lainnya untuk membuat IF bertingkat, yaitu beberapa pernyataan IF\" \/>\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\/sarang-jika\/\" \/>\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 fungsi IF bersarang VBA?\" \/>\n<meta property=\"og:description\" content=\"Anda dapat menggunakan pernyataan IF di dalam pernyataan IF lainnya untuk membuat IF bertingkat, yaitu beberapa pernyataan IF\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sarang-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.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\/sarang-jika\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sarang-jika\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan fungsi IF bersarang VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sarang-jika\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sarang-jika\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\",\"datePublished\":\"2023-09-29T01:34:04+00:00\",\"dateModified\":\"2023-12-06T06:16:36+00:00\",\"description\":\"Anda dapat menggunakan pernyataan IF di dalam pernyataan IF lainnya untuk membuat IF bertingkat, yaitu beberapa pernyataan IF\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sarang-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sarang-jika\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sarang-jika\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sarang-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi if bersarang 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":"\u25b7 Bagaimana cara menggunakan fungsi IF bersarang VBA?","description":"Anda dapat menggunakan pernyataan IF di dalam pernyataan IF lainnya untuk membuat IF bertingkat, yaitu beberapa pernyataan IF","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\/sarang-jika\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan fungsi IF bersarang VBA?","og_description":"Anda dapat menggunakan pernyataan IF di dalam pernyataan IF lainnya untuk membuat IF bertingkat, yaitu beberapa pernyataan IF","og_url":"https:\/\/exceladvisor.org\/id\/sarang-jika\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.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\/sarang-jika\/","url":"https:\/\/exceladvisor.org\/id\/sarang-jika\/","name":"\u25b7 Bagaimana cara menggunakan fungsi IF bersarang VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sarang-jika\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sarang-jika\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","datePublished":"2023-09-29T01:34:04+00:00","dateModified":"2023-12-06T06:16:36+00:00","description":"Anda dapat menggunakan pernyataan IF di dalam pernyataan IF lainnya untuk membuat IF bertingkat, yaitu beberapa pernyataan IF","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sarang-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sarang-jika\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sarang-jika\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/sarang-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi if bersarang 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\/2141","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=2141"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2141\/revisions"}],"predecessor-version":[{"id":2545,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2141\/revisions\/2545"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}