{"id":1817,"date":"2023-11-02T14:37:33","date_gmt":"2023-11-02T14:37:33","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/"},"modified":"2023-12-06T06:17:28","modified_gmt":"2023-12-06T06:17:28","slug":"berhenti-jika-benar-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/","title":{"rendered":"Bagaimana cara menghentikan if true dalam format bersyarat?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-63810728\"><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>Dalam pemformatan bersyarat, Anda mungkin melihat kotak centang &#8220;Hentikan JIKA Benar&#8221; saat Anda membuka kotak dialog manajemen aturan. Dan dalam tutorial ini, kita akan mempelajari cara menggunakan kotak centang ini.<\/p><h2 class=\"wp-block-heading\"> Untuk apa Stop IF True digunakan dalam pemformatan bersyarat?<\/h2><p> Misalkan dua aturan berlaku pada rentang sel yang sama. Dengan Stop IF True, Anda bisa memberi tahu Excel untuk tidak menggunakan aturan kedua di sel yang aturan pertamanya BENAR. Dalam tutorial ini, kami mengambil contoh sederhana untuk memahami hal ini.<\/p><h2 class=\"wp-block-heading\"> Contoh Penggunaan Stop If True dalam Pemformatan Bersyarat<\/h2><p> Pada contoh di bawah ini kita memiliki ikon yang disetel ke rentang yang berisi angka. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91394\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"sebuah-ikon-disetel-pada-jarak-berhenti-jika-benar-\" width=\"650\" height=\"312\"><\/figure><\/div><p> Dalam aturan kumpulan ikon ini, Anda memiliki titik hijau untuk nilai di atas 85, titik kuning untuk nilai antara 84 dan 45, dan titik merah untuk nilai di bawah 45.<\/p><p> Di sini kita hanya membutuhkan titik hijau, dan tanda centang \u201cHentikan JIKA Benar\u201d dapat membantu kita. Untuk melakukan ini, mari buat aturan baru. Buka Beranda &gt; Pemformatan Bersyarat &gt; Aturan Baru. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91395\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-nous-navons-besoin-que-de-points-verts-sarreter-si-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"kita-hanya-perlu-titik-hijau-berhenti-jika-benar\" width=\"205\" height=\"346\"><\/figure><\/div><p> Sekarang, di kotak dialog aturan baru, klik &#8220;Format hanya sel yang berisi&#8221;, dan pilih &#8220;bukan di antara&#8221;. Setelah itu masukkan 85 dan 100 untuk membuat rentang angka.<\/p><p> Dengan ini Anda membuat aturan untuk memformat angka yang tidak berada dalam rentang ini. Ingat, ini adalah rentang angka yang sama yang tidak memiliki ikon hijau dalam aturan kumpulan ikon yang sudah ditetapkan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91396\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-creer-une-plage-de-nombres-stop-si-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat-rentang-angka-berhenti-jika-benar\" width=\"601\" height=\"372\"><\/figure><\/div><p> Dalam aturan ini, Anda tidak perlu menentukan format apa pun. Jadi, klik OK untuk membuat aturan. Dan ketika Anda mengklik OK, itu tidak akan melakukan apa pun.<\/p><p> Sekali lagi, buka Beranda &gt; Pemformatan Bersyarat &gt; Manajer Aturan. Dan dari sana, centang kotak \u201cHentikan JIKA Benar\u201d dan klik Terapkan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-91397\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-case-a-cocher-et-cliquez-sur-appliquer-stop-si-vrai.png\" sizes=\"auto, \" srcset=\"\" alt=\"kotak centang-dan-klik-terapkan-berhenti-jika-benar\" width=\"811\" height=\"498\"><\/figure><\/div><p> Dan saat Anda mengklik OK, itu akan menampilkan ikon hijau pada sel yang nilainya lebih besar dari atau sama dengan 85.<\/p><p> Hentikan IF True bekerja berdasarkan urutan aturan yang Anda miliki di Rules Manager. Jadi ketika ada sel yang aturannya benar, tidak ada aturan lain yang diterapkan pada sel tersebut.<\/p><p> Dan hal yang sama terjadi di sini ketika aturan pertama, yang kita terapkan pada sel dengan nilai 0 hingga 84, adalah benar; itu tidak menerapkan aturan kedua pada sel-sel ini, itulah sebabnya kita hanya memiliki ikon hijau. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/stop-si-vrai.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-6076ba72 gb-container-mt\"> <a class=\"gb-button gb-button-76e6a499 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Pelajari dasar-dasar Excel<\/a><h2 class=\"gb-headline gb-headline-a9e9e206 gb-headline-text gb-headline-mt-heading\"> Pelajari lebih lanjut tentang <a href=\"https:\/\/exceladvisor.org\/id\/pemformatan-bersyarat\/\">pemformatan bersyarat<\/a> <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-790317cb gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-a9845ede\"><div class=\"gb-container gb-container-a9845ede\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-pemformatan-bersyarat\/\">Terapkan pemformatan bersyarat ke tabel pivot<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menarik\/\">Hapus Pemformatan Bersyarat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-kosong\/\">Terapkan Pemformatan Bersyarat pada Sel Kosong di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membandingkan-kolom\/\">Bandingkan dua kolom menggunakan pemformatan bersyarat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-lain\/\">Terapkan pemformatan bersyarat berdasarkan sel lain<\/a><\/li><\/ul><\/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-1817","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 menghentikan IF True dalam format bersyarat Excel?<\/title>\n<meta name=\"description\" content=\"Anda mungkin melihat kotak centang &quot;Hentikan JIKA Benar&quot; saat membuka dialog pengelolaan aturan.\" \/>\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\/berhenti-jika-benar-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghentikan IF True dalam format bersyarat Excel?\" \/>\n<meta property=\"og:description\" content=\"Anda mungkin melihat kotak centang &quot;Hentikan JIKA Benar&quot; saat membuka dialog pengelolaan aturan.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.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\/berhenti-jika-benar-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/\",\"name\":\"Bagaimana cara menghentikan IF True dalam format bersyarat Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png\",\"datePublished\":\"2023-11-02T14:37:33+00:00\",\"dateModified\":\"2023-12-06T06:17:28+00:00\",\"description\":\"Anda mungkin melihat kotak centang &quot;Hentikan JIKA Benar&quot; saat membuka dialog pengelolaan aturan.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghentikan if true dalam format bersyarat?\"}]},{\"@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 menghentikan IF True dalam format bersyarat Excel?","description":"Anda mungkin melihat kotak centang &quot;Hentikan JIKA Benar&quot; saat membuka dialog pengelolaan aturan.","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\/berhenti-jika-benar-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghentikan IF True dalam format bersyarat Excel?","og_description":"Anda mungkin melihat kotak centang &quot;Hentikan JIKA Benar&quot; saat membuka dialog pengelolaan aturan.","og_url":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.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\/berhenti-jika-benar-2\/","url":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/","name":"Bagaimana cara menghentikan IF True dalam format bersyarat Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png","datePublished":"2023-11-02T14:37:33+00:00","dateModified":"2023-12-06T06:17:28+00:00","description":"Anda mungkin melihat kotak centang &quot;Hentikan JIKA Benar&quot; saat membuka dialog pengelolaan aturan.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-une-icone-definie-sur-un-arret-de-plage-si-vrai.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/berhenti-jika-benar-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghentikan if true dalam format bersyarat?"}]},{"@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\/1817","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=1817"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1817\/revisions"}],"predecessor-version":[{"id":2603,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1817\/revisions\/2603"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}