{"id":1816,"date":"2023-11-02T15:07:50","date_gmt":"2023-11-02T15:07:50","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/"},"modified":"2023-12-06T06:20:47","modified_gmt":"2023-12-06T06:20:47","slug":"jika-deklarasi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/","title":{"rendered":"Power query: pernyataan if"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1652231235\"><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 Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus. Misalnya di bawah ini adalah daftar angka (100) pada kolom A. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88939\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-pernyataan-dalam-kuasa-kueri\" width=\"224\" height=\"222\"><\/figure><\/div><p> Anda memerlukan kolom baru dengan pernyataan IF untuk memeriksa apakah suatu angka lebih besar dari atau sama dengan 1000.<\/p><h2 class=\"wp-block-heading\"> Gunakan IF di Power Query<\/h2><p> Berikut langkah-langkah menulis pernyataan IF di Power Query:<\/p><ol><li> Pertama, pilih sel dan buka tab Data &gt; Dapatkan Data &gt; Dari Sumber Lain &gt; Dari Tabel\/Rentang. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-gunakan-jika-dalam-kuasa-kueri\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-si-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-if-in-power-query\" width=\"477\" height=\"337\"><\/li><li> Klik OK untuk mengonversi data menjadi tabel dan memuatnya ke editor kueri tingkat lanjut. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-konversi-data-ke-tabel-dan-muat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-convertir-les-donnees-en-table-et-charger.png\" sizes=\"auto, \" srcset=\"\" alt=\"convert-data-into-table-and-load\" width=\"369\" height=\"133\"><\/li><li> Buka tab \u201cTambahkan Kolom\u201d di Editor Kueri yang Kuat dan klik \u201cKolom Bersyarat\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"Kolom bersyarat dalam 4 klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Colonne-conditionnelle-en-4-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-conditional-column\" width=\"499\" height=\"271\"><\/li><li> Dan ketika Anda mengklik tombol tersebut, Anda akan melihat kotak dialog untuk membuat pernyataan kondisional. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-dialog-untuk-membuat-pernyataan-bersyarat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-boite-de-dialogue-pour-creer-une-instruction-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialog-box-to-create-conditional-statement\" width=\"658\" height=\"271\"><\/li><li id=\"block-12d1fea2-fe89-41da-ac3f-76a8f6ad6909\" class=\"block-editor-block-list__block wp-block is-selected wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"12d1fea2-fe89-41da-ac3f-76a8f6ad6909\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Anda perlu mengikuti langkah-langkah di bawah ini: <\/div><ol id=\"block-13e8ba86-7e9d-4dfa-85f8-8e7781c51f00\" class=\"block-editor-block-list__block wp-block wp-block-list block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List\" data-block=\"13e8ba86-7e9d-4dfa-85f8-8e7781c51f00\" data-type=\"core\/list\" data-title=\"List\" data-is-drop-zone=\"true\"><li id=\"block-65da9307-cc10-4433-b081-92a73d2f0951\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"65da9307-cc10-4433-b081-92a73d2f0951\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Masukkan nama kolom baru \u201cStatus\u201d. <\/div><\/li><li id=\"block-f8f0d664-28ef-4f73-ba86-551008a23a8f\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"f8f0d664-28ef-4f73-ba86-551008a23a8f\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Pilih kolom \u201cAngka\u201d. <\/div><\/li><li id=\"block-69edee46-70e4-4e1b-9a47-949b59b1ce26\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"69edee46-70e4-4e1b-9a47-949b59b1ce26\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Gunakan operator \u201clebih besar dari atau sama dengan\u201d. <\/div><\/li><li id=\"block-b5df48b9-7ab0-4e28-abe7-494ef564e69c\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"b5df48b9-7ab0-4e28-abe7-494ef564e69c\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Masukkan nilai \u201c1000\u201d. <\/div><\/li><li id=\"block-4aa8de0b-76a9-483f-9d10-6bb90baf0c60\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"4aa8de0b-76a9-483f-9d10-6bb90baf0c60\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> \u201cYa\u201d untuk keluar. <\/div><\/li><li id=\"block-5bbc9f99-1ac7-479d-80d8-b531b968581e\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"5bbc9f99-1ac7-479d-80d8-b531b968581e\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> \u201cTidak\u201d untuk sisanya. <\/div><\/li><li id=\"block-0841c1ed-0853-42a0-ae07-8585ec60b6a6\" class=\"block-editor-block-list__block wp-block wp-block-list-item block-editor-block-list__layout tcb-style-wrap\" tabindex=\"0\" role=\"document\" aria-label=\"Block: List item\" data-block=\"0841c1ed-0853-42a0-ae07-8585ec60b6a6\" data-type=\"core\/list-item\" data-title=\"List item\"><div class=\"block-editor-rich-text__editable rich-text\" style=\"white-space: pre-wrap; min-width: 1px;\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"List text\"> Klik Oke. <\/div><\/li><\/ol><p><img loading=\"lazy\" decoding=\"async\" title=\"6-tambahkan-pernyataan bersyarat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ajouter-une-instruction-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-conditional-statement\" width=\"661\" height=\"276\"><\/p><\/li><\/ol><p> Dengan pernyataan IF di atas, Anda meminta PowerQuery untuk membuat kolom baru yang menggunakan &#8220;Ya&#8221; jika angkanya lebih besar atau sama dengan &#8220;1000&#8221;, jika tidak, &#8220;Tidak&#8221;. Dan saat Anda menekan Enter, maka masuk ke kolom baru dengan kondisi yang Anda tulis. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88945\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-nouvelle-colonne-avec-la-condition-que-vous-avez-ecrite.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-baru-dengan-kondisi-yang-Anda-tulis\" width=\"377\" height=\"343\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan IF dengan ELSE-IF di Power Query (IF bertumpuk)<\/h2><p> Anda juga mempunyai pilihan untuk menggunakan pernyataan else if dengan IF (bersarang). Anda dapat melihat opsi untuk menambahkannya di kotak dialog pernyataan IF. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88946\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-si-avec-elseif-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"kueri if-with-else-if-in-power\" width=\"550\" height=\"311\"><\/figure><\/div><ol><li> Saat Anda mengklik tombol \u201cTambahkan Klausul\u201d, Anda akan mendapatkan pernyataan Else IF, sama seperti IF, dan sekarang Anda perlu memasukkan detailnya di sini. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-tambahkan-klausul-untuk-mendapatkan-elseif-pernyataan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-ajouter-une-clause-pour-obtenir-une-instruction-elseif.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-clause-to-get-else-if-statement\" width=\"831\" height=\"247\"><\/li><li> Disini saya akan menggunakan operator lebih besar dari dan sama dengan untuk mendapatkan nilai &#8220;Mungkin&#8221; untuk angka lebih besar dari 500 tetapi kurang dari 1000. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-gunakan-lebih besar-dan-sama-untuk-mendapatkan-mungkin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-utiliser-superieur-et-egal-a-obtenir-peut-etre.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-greater-than-and-equal-to-get-may-be\" width=\"832\" height=\"252\"><\/li><li> Setelah Anda mengklik OK, Anda akan mendapatkan tiga nilai berbeda di kolom &#8220;Status&#8221;, berdasarkan pernyataan IF tertulis Anda. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-tiga-nilai-berbeda-dalam-kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-trois-valeurs-differentes-dans-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"three-different-values-in-the-column\" width=\"391\" height=\"286\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Tulislah rumus IF yang sebenarnya<\/h2><p> Ya, Anda juga bisa menulis rumus IF sebenarnya. Misalnya penulisan rumus IF di PowerQuery sedikit berbeda di Power Query, namun tidak banyak. Jadi, setelah Anda memuat data ke dalam Editor Kueri Tingkat Lanjut, buka tab Kolom dan klik tombol \u201cTambahkan Kolom\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88950\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-ecrire-si-la-formule-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"tulis-jika-rumus-dalam-kuasa-kueri\" width=\"460\" height=\"255\"><\/figure><\/div><p> Lalu, masukkan rumus di bawah ini ke dalam \u201cbilah entri rumus\u201d.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=if [Numbers] &gt;= 1000 then \"Yes\" else \"No\"<\/code><\/pre><p> Ada tiga bagian dalam rumus ini:<\/p><ul><li> if \u2013 kondisi ke teks<\/li><li> kemudian \u2013 nilai jika kondisinya benar.<\/li><li> else \u2013 nilai jika kondisinya salah.<\/li><\/ul><p> Dan pastikan Anda menulis semuanya dalam huruf kecil. Tidak seperti Excel, di Power Query Anda harus merujuk ke seluruh kolom rumus. Dan kami juga memiliki operator yang lebih besar dari yang setara untuk menguji kondisi tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88951\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-font-reference-a-des-colonnes-entieres-dans-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"rujuk-seluruh-kolom-dalam-rumus\" width=\"658\" height=\"409\"><\/figure><\/div><p> Dan jika Anda ingin membuat if bersarang, Anda dapat melakukannya seperti di bawah ini: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=if [Numbers] &gt;= 1000 then \"Yes\" else if [Numbers] &gt;= 500 then \"May Be\" else \"No\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88952\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-creer-imbrique-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat-bersarang-jika\" width=\"668\" height=\"414\"><\/figure><\/div><p> Pada akhirnya, klik OK untuk menambahkan kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88953\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-cliquez-sur-ok-pour-ajouter-un-nuage.png\" sizes=\"auto, \" srcset=\"\" alt=\"klik-ok-untuk-menambahkan-kolom\" width=\"405\" height=\"333\"><\/figure><\/div><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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/si-requete-de-puissance.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/permintaan-kekuatan\/\">Power Query di Excel (Tutorial)<\/a><h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6e9de105\"><div class=\"gb-container gb-container-6e9de105\"><ul><li> Gabungkan [Gabungkan] Beberapa FILE Excel menjadi SATU BUKU CATATAN<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarianv-2\/\">Lakukan VLOOKUP di Power Query di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\">Hapus pivot data di Excel menggunakan Power Query<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rantai\/\">Power Query: menggabungkan nilai (teks dan angka)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\">Power Query: Perbedaan tanggal<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-4eaecde3\"><div class=\"gb-container gb-container-4eaecde3\"><\/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-1816","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>Gunakan pernyataan IF di Power Query untuk menguji kondisi<\/title>\n<meta name=\"description\" content=\"Di Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus.\" \/>\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-deklarasi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gunakan pernyataan IF di Power Query untuk menguji kondisi\" \/>\n<meta property=\"og:description\" content=\"Di Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.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-deklarasi\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/\",\"name\":\"Gunakan pernyataan IF di Power Query untuk menguji kondisi\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\",\"datePublished\":\"2023-11-02T15:07:50+00:00\",\"dateModified\":\"2023-12-06T06:20:47+00:00\",\"description\":\"Di Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power query: pernyataan if\"}]},{\"@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":"Gunakan pernyataan IF di Power Query untuk menguji kondisi","description":"Di Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus.","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-deklarasi\/","og_locale":"id_ID","og_type":"article","og_title":"Gunakan pernyataan IF di Power Query untuk menguji kondisi","og_description":"Di Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus.","og_url":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:47+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.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-deklarasi\/","url":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/","name":"Gunakan pernyataan IF di Power Query untuk menguji kondisi","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png","datePublished":"2023-11-02T15:07:50+00:00","dateModified":"2023-12-06T06:20:47+00:00","description":"Di Power Query, jika Anda ingin membuat pernyataan IF, ada opsi khusus untuk membantu Anda menulisnya tanpa rumus.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-deklarasi\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-if-dans-la-requete-de-puissance.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-deklarasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Power query: pernyataan if"}]},{"@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\/1816","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=1816"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1816\/revisions"}],"predecessor-version":[{"id":2941,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1816\/revisions\/2941"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}