{"id":1774,"date":"2023-11-05T18:30:11","date_gmt":"2023-11-05T18:30:11","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/"},"modified":"2023-12-06T06:19:49","modified_gmt":"2023-12-06T06:19:49","slug":"jika-atau-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/","title":{"rendered":"Cara menggabungkan fungsi if dan or di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4225906426\"><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>Fungsi IF adalah salah satu fungsi paling kuat di Excel. Dan bagian terbaiknya adalah Anda dapat menggabungkan fungsi lain dengan IF untuk meningkatkan kekuatannya.<\/p><p> Kombinasi fungsi IF dan OR merupakan salah satu kombinasi rumus yang berguna di Excel. Pada artikel ini, saya akan menunjukkan mengapa kita perlu menggabungkan fungsi IF dan OR. Dan mengapa ini sangat berguna bagi Anda.<\/p><h2 id=\"1\" class=\"wp-block-heading\"> Pengenalan cepat<\/h2><p> Saya yakin Anda telah menggunakan kedua fungsi ini, namun izinkan saya memberi Anda pengenalan singkat.<\/p><ul><li> <strong>IF<\/strong> \u2013 Gunakan fungsi ini untuk menguji suatu kondisi. Ini akan mengembalikan nilai tertentu jika kondisi ini benar, atau nilai spesifik lainnya jika kondisi ini salah.<\/li><li> <strong>ATAU<\/strong> \u2013 Beberapa kondisi pengujian. Ini akan menghasilkan nilai benar jika salah satu kondisi ini benar, dan salah jika semua kondisi ini salah.<\/li><\/ul><p> <em>Inti dari kedua fungsi tersebut adalah fungsi IF hanya dapat menguji satu kondisi dalam satu waktu. Dan, fungsi OR dapat menguji beberapa kondisi tetapi hanya mengembalikan nilai benar\/salah. Dan, jika kita menggabungkan kedua fungsi ini, kita dapat menguji beberapa kondisi dengan OR dan mengembalikan nilai tertentu dengan IF.<\/em><\/p><h2 id=\"2\" class=\"wp-block-heading\"> Bagaimana cara kerja fungsi IF dan OR?<\/h2><p> Dalam sintaksis fungsi IF, miliki argumen pengujian logis yang kita gunakan untuk menentukan kondisi yang akan diuji.<\/p><p> JIKA ( <strong>pengujian_logis<\/strong> , nilai_jika_benar, nilai_jika_false)<\/p><p> Dan, kemudian, ia mengembalikan nilai berdasarkan hasil dari kondisi tersebut. Sekarang jika kita menggunakan fungsi OR untuk argumen ini dan menentukan beberapa kondisi untuk ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9594\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menggabungkan fungsi if dan or dan mengganti argumen logis dengan atau\" width=\"488\" height=\"139\"><\/figure><\/div><p> Jika salah satu kondisi benar, OR akan mengembalikan nilai benar dan IF akan mengembalikan nilai spesifik. Dan, jika tidak ada kondisi yang benar OR dengan return FALSE IF akan mengembalikan nilai spesifik lainnya. Dengan cara ini kita bisa menguji lebih dari satu nilai dengan fungsi IF. Mari beralih ke beberapa contoh konkrit.<\/p><h2 id=\"3\" class=\"wp-block-heading\"> Contoh<\/h2><p> Di sini saya memiliki tabel dengan <a href=\"https:\/\/exceladvisor.org\/id\/templat-manajemen-inventaris-formulir-pengguna-excel-vba\/\">rincian inventaris<\/a> dua gudang. Sekarang saya ingin memperbarui status di tabel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9595\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-pour-obtenir-le-statut-dans-la-table-des-stocks-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menggabungkan fungsi if dan or untuk mendapatkan status di tabel stok\" width=\"502\" height=\"251\"><\/figure><\/div><p> Jika tidak ada stok di kedua gudang, maka statusnya adalah &#8220;Stok habis&#8221;. Dan jika ada stok di salah satu gudang, statusnya harus \u201cIn Stock\u201d. Jadi di sini saya perlu memeriksa dua kondisi berbeda \u201cGudang-1\u201d &amp; \u201cGudang-2\u201d.<br> Dan rumusnya akan menjadi seperti itu. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(OR(B2&gt;0,C2&gt;0),\"In-Stock\",\"Out of Stock\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9596\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-pour-obtenir-le-statut-dans-la-formule-dinsertion-de-la-table-de-stock-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara menggabungkan fungsi if dan or untuk mendapatkan status dalam rumus sisipan tabel stok\" width=\"544\" height=\"297\"><\/figure><\/div><p> Dalam rumus di atas, jika ada nilai yang lebih besar dari nol di salah satu sel (B2 dan C2), fungsi OR akan mengembalikan nilai true dan IF akan mengembalikan nilai \u201cTersedia\u201d. Namun, jika kedua sel bernilai nol, OR akan menghasilkan false dan IF akan mengembalikan nilai \u201cOut of stock\u201d. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Dapatkan file Excelnya <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/comment-combiner-les-fonctions-if-et-or.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><\/div><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Kata-kata terakhir<\/h2><p> Kedua fungsi tersebut sama-sama berguna namun bila Anda menggabungkannya, Anda dapat menggunakannya dengan lebih efektif. Seperti yang saya katakan, dengan menggabungkan fungsi IF dan OR Anda dapat menguji lebih dari satu kondisi. Anda dapat menyelesaikan kedua masalah Anda dengan kombinasi fungsi ini.<\/p><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-dan-1\/\">Gabungkan fungsi IF dan AND 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-1774","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 Menggabungkan Fungsi IF dan OR di Excel<\/title>\n<meta name=\"description\" content=\"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan OR. Anda dapat menggunakan OR untuk menguji beberapa kondisi.\" \/>\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-atau-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggabungkan Fungsi IF dan OR di Excel\" \/>\n<meta property=\"og:description\" content=\"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan OR. Anda dapat menggunakan OR untuk menguji beberapa kondisi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-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-atau-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\",\"name\":\"Cara Menggabungkan Fungsi IF dan OR di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png\",\"datePublished\":\"2023-11-05T18:30:11+00:00\",\"dateModified\":\"2023-12-06T06:19:49+00:00\",\"description\":\"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan OR. Anda dapat menggunakan OR untuk menguji beberapa kondisi.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan fungsi if dan or 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 Menggabungkan Fungsi IF dan OR di Excel","description":"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan OR. Anda dapat menggunakan OR untuk menguji beberapa kondisi.","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-atau-1\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggabungkan Fungsi IF dan OR di Excel","og_description":"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan OR. Anda dapat menggunakan OR untuk menguji beberapa kondisi.","og_url":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:49+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-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-atau-1\/","url":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/","name":"Cara Menggabungkan Fungsi IF dan OR di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png","datePublished":"2023-11-05T18:30:11+00:00","dateModified":"2023-12-06T06:19:49+00:00","description":"Pada artikel ini, Anda akan mempelajari cara menggabungkan fungsi IF dan OR. Anda dapat menggunakan OR untuk menguji beberapa kondisi.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-atau-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-combiner-les-fonctions-if-et-or-et-remplacer-largument-logique-par-or-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-atau-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan fungsi if dan or 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\/1774","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=1774"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1774\/revisions"}],"predecessor-version":[{"id":2880,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1774\/revisions\/2880"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}