{"id":1680,"date":"2023-11-11T16:10:09","date_gmt":"2023-11-11T16:10:09","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/median-jika-2\/"},"modified":"2023-12-06T06:20:23","modified_gmt":"2023-12-06T06:20:23","slug":"median-jika-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/median-jika-2\/","title":{"rendered":"Kriteria bersyarat untuk menggunakan median dengan if"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3926819204\"><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>Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama Anda perlu menggunakan fungsi MEDIAN, lalu untuk membuat kondisi Anda perlu memasukkan fungsi IF. Dalam SI, mengacu pada rentang yang ingin Anda uji kondisinya. Setelah itu, lihat rentang di mana Anda memiliki datanya. Terakhir, masukkan rumus sebagai rumus array. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79414\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"median-dengan-jika\" width=\"536\" height=\"386\"><\/figure><\/div><p> Pada tutorial kali ini kita akan mempelajari cara menulis rumus menghitung median dengan syarat.<\/p><h2 class=\"wp-block-heading\"> Rumus kondisional untuk menghitung MEDIAN IF<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol><li> Pertama masukkan fungsi MEDIAN dalam sel.<\/li><li> Setelah itu masuk ke fungsi IF dengan MEDIAN.<\/li><li> Sekarang dalam argumen (logical_test) lihat rentang A1:A1.<\/li><li> Dari sana, dalam argumen yang sama, masukkan operator sama dengan dan masukkan &#8220;Hari 1&#8221; untuk digunakan sebagai kondisi pengujian.<\/li><li> Kemudian di (value_if_true) di IF, lihat rentang B1:B12 di mana Anda memiliki data untuk menghitung MEDIAN.<\/li><li> Terakhir, masukkan tanda kurung tutup untuk menutup fungsi. Dan gunakan <strong>Ctrl + Shift + Enter<\/strong> untuk mendapatkan hasil rumusnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79415\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-calculer-la-mediane-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"hitung-median-jika\" width=\"642\" height=\"355\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MEDIAN(IF(A1:A12=\"Day 1\",B1:B12))<\/code><\/pre><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Untuk memahami rumus ini, Anda perlu memahami bahwa saat Anda memasukkan rumus dalam bentuk tabel, rumus tersebut berfungsi pada seluruh rentang, bukan hanya pada satu sel. Anda perlu membagi rumus ini menjadi dua bagian untuk memahaminya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79416\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comprend-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"memahami rumusnya\" width=\"675\" height=\"341\"><\/figure><\/div><p> Di <strong><strong><mark class=\"has-inline-color\" style=\"background-color: #eedc82; color: #ed573c;\">BAGIAN SATU<\/mark><\/strong><\/strong> , Anda memiliki kondisi untuk diuji dalam rentang A1:A12. Dalam rentang ini kami memiliki dua nilai, Hari 1 dan Hari 2, kami ingin menguji sel di mana kami memiliki sel Hari 1. Seperti yang Anda lihat pada contoh di atas, kami memiliki TRUE untuk semua sel yang kami setel ke Hari 1 dan FALSE untuk sel lainnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79417\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-conditions-a-tester-en-premiere-partie1.png\" sizes=\"auto, \" srcset=\"\" alt=\"kondisi-untuk-diuji-di-bagian-pertama\" width=\"671\" height=\"329\"><\/figure><\/div><p> Setelah itu, pada argumen kedua fungsi IF, Anda mengacu pada rentang B1:B12 di mana kita memiliki data untuk menghitung median. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fait-reference-a-la-gamme-dans-la-deuxieme-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi-ke-skala-di-bagian-kedua\" width=\"705\" height=\"337\"><\/figure><\/div><p> Di <strong><mark class=\"has-inline-color\" style=\"background-color: #eedc82; color: #ed573c;\">BAGIAN DUA<\/mark><\/strong> , IF mengembalikan data untuk semua nilai yang kita punya HARI 1 dalam rentang A1:A12, dan FALSE untuk nilai lainnya. Dan MEDIAN mengembalikan median hanya untuk nilai-nilai ini. <\/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\/08\/mediane-si.xlsx\" rel=\"nofollow\">Unduh<\/a><\/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-dan-1\/\">Gabungkan fungsi IF dan AND 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-1680","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>Kriteria bersyarat untuk menggunakan MEDIAN dengan IF<\/title>\n<meta name=\"description\" content=\"Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama\" \/>\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\/median-jika-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kriteria bersyarat untuk menggunakan MEDIAN dengan IF\" \/>\n<meta property=\"og:description\" content=\"Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/median-jika-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.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\/median-jika-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/median-jika-2\/\",\"name\":\"Kriteria bersyarat untuk menggunakan MEDIAN dengan IF\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/median-jika-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/median-jika-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\",\"datePublished\":\"2023-11-11T16:10:09+00:00\",\"dateModified\":\"2023-12-06T06:20:23+00:00\",\"description\":\"Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/median-jika-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/median-jika-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/median-jika-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/median-jika-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kriteria bersyarat untuk menggunakan median dengan 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":"Kriteria bersyarat untuk menggunakan MEDIAN dengan IF","description":"Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama","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\/median-jika-2\/","og_locale":"id_ID","og_type":"article","og_title":"Kriteria bersyarat untuk menggunakan MEDIAN dengan IF","og_description":"Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama","og_url":"https:\/\/exceladvisor.org\/id\/median-jika-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:23+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.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\/median-jika-2\/","url":"https:\/\/exceladvisor.org\/id\/median-jika-2\/","name":"Kriteria bersyarat untuk menggunakan MEDIAN dengan IF","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/median-jika-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/median-jika-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png","datePublished":"2023-11-11T16:10:09+00:00","dateModified":"2023-12-06T06:20:23+00:00","description":"Untuk menulis rumus MEDIAN IF di Excel, Anda perlu menggunakan fungsi MEDIAN yang dipadukan dengan fungsi IF. Pertama","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/median-jika-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/median-jika-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/median-jika-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mediane-avec-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/median-jika-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kriteria bersyarat untuk menggunakan median dengan 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\/1680","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=1680"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1680\/revisions"}],"predecessor-version":[{"id":2915,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1680\/revisions\/2915"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}