{"id":1600,"date":"2023-11-15T14:20:43","date_gmt":"2023-11-15T14:20:43","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/"},"modified":"2023-12-06T06:16:10","modified_gmt":"2023-12-06T06:16:10","slug":"jika-dan-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/","title":{"rendered":"Bagaimana cara menggabungkan fungsi if dan and di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-876280560\"><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>Seperti yang saya katakan, dengan menggabungkan IF dengan fungsi lain Anda dapat meningkatkan kekuatannya. Fungsi AND adalah salah satu fungsi yang paling berguna untuk digabungkan dengan fungsi IF.<\/p><p> Saat Anda menggabungkan fungsi <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">IF dan OR<\/a> untuk menguji beberapa kondisi. Dengan cara yang sama, Anda dapat menggabungkan fungsi IF dan AND.<\/p><p> Ada sedikit perbedaan penggunaan fungsi OR dan AND dengan IF. Pada artikel ini Anda akan mempelajari cara menggabungkan fungsi IF &amp; AND dan Anda juga akan mempelajari mengapa kita perlu menggabungkan keduanya.<\/p><h2 id=\"1\" class=\"wp-block-heading\"> Pengenalan cepat<\/h2><p> Kedua fungsi ini berguna tetapi dengan menggunakannya bersama-sama Anda dapat memecahkan beberapa masalah di dunia nyata. Berikut pengenalan singkat keduanya.<\/p><ol><li> <strong>Fungsi IF<\/strong> \u2013 Untuk menguji suatu kondisi dan mengembalikan nilai tertentu jika kondisi ini benar atau nilai spesifik lainnya jika kondisi ini salah.<\/li><li> <strong>DAN Fungsi<\/strong> \u2013 Untuk menguji beberapa kondisi. Jika semua kondisi benar maka akan menghasilkan nilai benar dan jika salah satu kondisi salah maka akan menghasilkan salah.<\/li><\/ol><h2 class=\"wp-block-heading\"> <strong>Mengapa ini penting?<\/strong><\/h2><ol><li> Anda dapat menguji beberapa kondisi dengan fungsi IF.<\/li><li> Ini akan mengembalikan nilai tertentu jika semua kondisi benar.<\/li><li> Atau, ia akan mengembalikan nilai spesifik lainnya jika salah satu kondisinya salah.<\/li><\/ol><h2 class=\"wp-block-heading\"> Bagaimana cara kerja fungsi IF dan AND?<\/h2><p> Untuk menggabungkan fungsi IF dan AND, Anda cukup mengganti argumen logika_test pada fungsi IF dengan fungsi AND. Dengan menggunakan fungsi AND, Anda dapat menentukan beberapa kondisi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9625\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menggabungkan fungsi if dan dan menggantikan tes logika\" width=\"486\" height=\"140\"><\/figure><\/div><p> <span style=\"font-size: inherit; background-color: initial;\">Sekarang fungsi AND akan menguji semua kondisi Anda di sini.<\/span> <span style=\"font-size: inherit; background-color: initial;\">Jika semua kondisi benar, fungsi AND akan mengembalikan nilai benar dan fungsi IF akan mengembalikan nilai yang Anda tentukan untuk nilai benar.<\/span><\/p><p> <span style=\"font-size: inherit; background-color: initial;\">Dan, jika salah satu kondisi salah, fungsi AND akan mengembalikan nilai salah dan fungsi IF akan mengembalikan nilai yang Anda tentukan untuk salah.<\/span> <span style=\"font-size: inherit; background-color: initial;\">Izinkan saya menunjukkan kepada Anda sebuah contoh konkrit.<\/span><\/p><h2 id=\"3\" class=\"wp-block-heading\"> Contoh<\/h2><p> Di sini saya memiliki lembar nilai siswa. Dan, saya ingin menambahkan beberapa catatan pada lembar ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9630\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-la-table-des-fonctions-pour-ajouter-un-statut-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menggabungkan tabel if dan dan fungsi untuk menambah status\" width=\"569\" height=\"221\"><\/figure><\/div><p> Jika seorang siswa lulus kedua mata pelajaran dengan 40 poin atau lebih, statusnya harus \u201cLulus\u201d. Dan jika seorang siswa mempunyai nilai kurang dari 40 pada kedua mata pelajaran atau bahkan pada satu mata pelajaran, maka statusnya adalah \u201cGagal\u201d. Rumusnya akan menjadi. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(AND(B2&gt;=40,C2&gt;=40),\"Pass\",\"Fail\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9631\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-fonctions-inserer-une-formule-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menggabungkan fungsi if dan dan menyisipkan rumus\" width=\"572\" height=\"267\"><\/figure><\/div><p> Dalam rumus di atas, jika ada nilai yang lebih besar atau sama dengan 40 di salah satu sel (B2 dan C2), fungsi AND akan mengembalikan nilai true dan IF akan mengembalikan nilai \u201cLulus\u201d. Artinya, jika seorang siswa lulus kedua mata pelajaran tersebut, maka ia akan lulus.<\/p><p> Namun, jika kedua sel memiliki nilai kurang dari 40, AND akan mengembalikan nilai false dan IF akan mengembalikan nilai \u201cGagal\u201d. Jika seorang siswa gagal dalam salah satu mata pelajaran, dia akan gagal. <\/p><div class=\"wp-block-group download-box is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Unduh file contoh <\/h2><ul id=\"ub_styled_list-da8638b8-2d76-405d-a27d-456029ffc773\" class=\"ub_styled_list\"><li class=\"ub_styled_list_item\"> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/si-la-cellule-est-vide-2.xlsx\" rel=\"nofollow\">Contoh berkas<\/a><\/li><\/ul><\/div><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\">Centang IF 0 (nol) lalu kosongkan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/periksa-apakah-ada-nilai-dalam-suatu-rentang\/\">Periksa apakah ada nilai dalam rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">Gabungkan fungsi IF dan OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\">IF Cell kosong (kosong) menggunakan IF + ISBLANK di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\">JIKA negatif maka nol (0) di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1600","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>Cara menggunakan kombinasi fungsi IF dan AND di Excel<\/title>\n<meta name=\"description\" content=\"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan AND. Anda dapat menggunakan AND untuk menguji beberapa kondisi &amp; IF untuk mengujinya\" \/>\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-dan-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan kombinasi fungsi IF dan AND di Excel\" \/>\n<meta property=\"og:description\" content=\"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan AND. Anda dapat menggunakan AND untuk menguji beberapa kondisi &amp; IF untuk mengujinya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.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-dan-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\",\"name\":\"Cara menggunakan kombinasi fungsi IF dan AND di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png\",\"datePublished\":\"2023-11-15T14:20:43+00:00\",\"dateModified\":\"2023-12-06T06:16:10+00:00\",\"description\":\"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan AND. Anda dapat menggunakan AND untuk menguji beberapa kondisi &amp; IF untuk mengujinya\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggabungkan fungsi if dan and di excel?\"}]},{\"@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":"Cara menggunakan kombinasi fungsi IF dan AND di Excel","description":"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan AND. Anda dapat menggunakan AND untuk menguji beberapa kondisi &amp; IF untuk mengujinya","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-dan-1\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan kombinasi fungsi IF dan AND di Excel","og_description":"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan AND. Anda dapat menggunakan AND untuk menguji beberapa kondisi &amp; IF untuk mengujinya","og_url":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.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-dan-1\/","url":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/","name":"Cara menggunakan kombinasi fungsi IF dan AND di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png","datePublished":"2023-11-15T14:20:43+00:00","dateModified":"2023-12-06T06:16:10+00:00","description":"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan AND. Anda dapat menggunakan AND untuk menguji beberapa kondisi &amp; IF untuk mengujinya","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-dan-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-si-et-et-les-fonctions-remplacent-le-test-logique-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-dan-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggabungkan fungsi if dan and di excel?"}]},{"@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\/1600","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=1600"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1600\/revisions"}],"predecessor-version":[{"id":2501,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1600\/revisions\/2501"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}