{"id":4335,"date":"2023-07-11T22:08:15","date_gmt":"2023-07-11T22:08:15","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-sebaliknya\/"},"modified":"2023-07-11T22:08:15","modified_gmt":"2023-07-11T22:08:15","slug":"vba-sebaliknya","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-sebaliknya\/","title":{"rendered":"Vba: cara menggunakan if not (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan logika IF NOT di VBA untuk menguji apakah suatu kondisi tidak terpenuhi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubIfNot<\/span> ()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 11\n        <span style=\"color: #0000ff;\">If<\/span> Not Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = \" <span style=\"color: #ff0000;\">West<\/span> \" <span style=\"color: #0000ff;\">Then<\/span>\n        Result = \u201c <span style=\"color: #ff0000;\">Not West<\/span> \u201d\n        <span style=\"color: #0000ff;\">Else<\/span>\n        Result = \" <span style=\"color: #ff0000;\">West<\/span> \"\n        <span style=\"color: #0000ff;\">End If<\/span>\n    Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Result\n    <span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini memeriksa apakah setiap sel dalam rentang <strong>B2:B12<\/strong> tidak sama dengan &#8220;Barat&#8221;, lalu menetapkan &#8220;Bukan Barat&#8221; atau &#8220;Barat&#8221; ke setiap sel terkait dalam rentang <strong>C2:C12<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan IF NOT di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang memperlihatkan nama tim dan divisi dari berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34074 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sinon1.jpg\" alt=\"\" width=\"497\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin memberikan nilai &#8220;Barat&#8221; atau &#8220;Bukan Barat&#8221; pada setiap sel di kolom C berdasarkan apakah setiap tim berada di divisi Barat atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubIfNot<\/span> ()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 11\n        <span style=\"color: #0000ff;\">If<\/span> Not Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = \" <span style=\"color: #ff0000;\">West<\/span> \" <span style=\"color: #0000ff;\">Then<\/span>\n        Result = \u201c <span style=\"color: #ff0000;\">Not West<\/span> \u201d\n        <span style=\"color: #0000ff;\">Else<\/span>\n        Result = \" <span style=\"color: #ff0000;\">West<\/span> \"\n        <span style=\"color: #0000ff;\">End If<\/span>\n    Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Result\n    <span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34075 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sinon2.jpg\" alt=\"\" width=\"483\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai di kolom C memberi tahu kita apakah setiap pembagian di kolom B sama dengan \u201cBarat\u201d atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tim A milik \u201cBarat\u201d, jadi kolom C menunjukkan \u201cBarat\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim B milik \u201cTimur\u201d, jadi kolom C menunjukkan \u201cBukan Barat\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim C milik \u201cTimur\u201d, jadi kolom C menunjukkan \u201cBukan Barat\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tim D milik \u201cUtara\u201d, jadi kolom C menunjukkan \u201cTidak ke Barat\u201d<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/vba-jika-atau\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menggunakan IF OR untuk menguji beberapa kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jika-dan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menggunakan IF AND untuk menguji beberapa kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-berisi-string\/\" target=\"_blank\" rel=\"noopener\">VBA: cara memeriksa apakah suatu string berisi string lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggunakan logika IF NOT di VBA untuk menguji apakah suatu kondisi tidak terpenuhi: SubIfNot () Dim i As Integer For i = 2 To 11 If Not Range(&#8221; B &#8221; &amp; i) = &#8221; West &#8221; Then Result = \u201c Not West \u201d Else Result = &#8221; West [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menggunakan IF NOT (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan logika IF NOT di VBA untuk menguji apakah kondisi tertentu tidak terpenuhi, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/vba-sebaliknya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan IF NOT (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan logika IF NOT di VBA untuk menguji apakah kondisi tertentu tidak terpenuhi, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-sebaliknya\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T22:08:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sinon1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-sebaliknya\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-sebaliknya\/\",\"name\":\"VBA: Cara menggunakan IF NOT (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T22:08:15+00:00\",\"dateModified\":\"2023-07-11T22:08:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan logika IF NOT di VBA untuk menguji apakah kondisi tertentu tidak terpenuhi, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-sebaliknya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-sebaliknya\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-sebaliknya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan if not (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara menggunakan IF NOT (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan logika IF NOT di VBA untuk menguji apakah kondisi tertentu tidak terpenuhi, beserta contohnya.","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:\/\/statorials.org\/id\/vba-sebaliknya\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan IF NOT (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan logika IF NOT di VBA untuk menguji apakah kondisi tertentu tidak terpenuhi, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-sebaliknya\/","og_site_name":"Statorials","article_published_time":"2023-07-11T22:08:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sinon1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-sebaliknya\/","url":"https:\/\/statorials.org\/id\/vba-sebaliknya\/","name":"VBA: Cara menggunakan IF NOT (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T22:08:15+00:00","dateModified":"2023-07-11T22:08:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan logika IF NOT di VBA untuk menguji apakah kondisi tertentu tidak terpenuhi, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-sebaliknya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-sebaliknya\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-sebaliknya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan if not (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4335"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4335"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4335\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}