{"id":1687,"date":"2023-11-11T12:56:33","date_gmt":"2023-11-11T12:56:33","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/"},"modified":"2023-12-06T06:19:57","modified_gmt":"2023-12-06T06:19:57","slug":"nilai-sel-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/","title":{"rendered":"Dapatkan nilai sel di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-472291842\"><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 mendapatkan nilai sel di Excel, Anda bisa menggunakan dua metode berbeda. Dalam metode ini, Anda perlu menulis rumus cepat untuk mendapatkan nilainya. Dalam tutorial ini, kita akan belajar cara menulis rumus berikut: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79843\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"mendapatkan nilai sel\" width=\"626\" height=\"391\"><\/figure><\/div><h2 id=\"h-use-index-to-get-the-value-from-a-cell-by-referring-to-a-range\" class=\"wp-block-heading\"> Gunakan INDEX untuk mendapatkan nilai sel dengan mengacu pada suatu rentang<\/h2><p> Jika Anda memiliki rentang sel dan ingin mendapatkan nilai sel dari sel tertentu dalam rentang tersebut. Dengan fungsi INDEX Anda dapat menentukan rentang dan menggunakan nomor indeks dan fungsi tersebut akan mengembalikan nilainya.<\/p><p> Pada contoh berikut, kita memiliki empat nilai dalam rentang A1:A4. Dan Anda perlu mendapatkan nilai dari sel kedua dalam rentang tersebut. Untuk melakukannya, Anda dapat menggunakan fungsi INDEX sebagai berikut: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(A1:A4,2)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79844\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-fonction-dindex-pour-obtenir-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"indeks-fungsi-untuk-mendapatkan-nilai\" width=\"552\" height=\"296\"><\/figure><\/div><p> Setelah Anda menekan Enter, ini mengembalikan nilai \u201cDUA\u201d dari sel kedua dalam rentang yaitu A2.<\/p><h2 id=\"h-use-a-combination-of-indirect-and-address\" class=\"wp-block-heading\"> Gunakan kombinasi INDIRECT dan ADDRESS<\/h2><p> Anda juga dapat menggunakan kombinasi fungsi INDIRECT dan ADDRESS:<\/p><ul><li> TIDAK LANGSUNG: Memungkinkan Anda mendapatkan nilai sel dengan menentukan alamat sel. Anda dapat menggunakan gaya referensi A1 dan R1C1.<\/li><li> ALAMAT: Memungkinkan Anda membuat alamat sel menggunakan nomor baris dan kolom. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79845\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-combinaison-dindirect-et-dadresse.png\" sizes=\"auto, \" srcset=\"\" alt=\"kombinasi-tidak langsung-dan-alamat\" width=\"597\" height=\"309\"><\/figure><\/div><p> Sekarang mari kita gabungkan kedua fungsi ini:<\/p><ol type=\"1\"><li> Pertama masukkan fungsi tidak langsung ke dalam sel.<\/li><li> Selanjutnya, masukkan fungsi alamat.<\/li><li> Sekarang pada fungsi alamat masukkan nomor baris dan nomor kolom.<\/li><li> Terakhir, tutup rumus dan tekan Enter untuk mendapatkan hasilnya.<\/li><\/ol><p> Dan begitu Anda menekan enter, itu akan mengembalikan nilai sel yang ada di baris ke-2 dan kolom ke-1 (A1). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79846\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-resultat-de-la-fonction-dadresse-indirecte.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil dari fungsi alamat tidak langsung\" width=\"669\" height=\"307\"><\/figure><\/div><p> Untuk memahami rumus ini, Anda perlu membaginya menjadi dua bagian:<\/p><p> <strong>Bagian Satu:<\/strong> Seperti yang kita lihat sebelumnya, ADDRESS membuat alamat sel berdasarkan nomor baris dan kolom yang Anda tentukan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79847\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-premiere-partie-dindirect-et-dadresse.png\" sizes=\"auto, \" srcset=\"\" alt=\"bagian pertama dari tidak langsung dan alamat\" width=\"508\" height=\"248\"><\/figure><\/div><p> <strong>Bagian kedua:<\/strong> Menggunakan alamat sel yang dikembalikan oleh fungsi ADDRESS, fungsi INDIRECT mengembalikan nilai sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79848\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-deuxieme-partie-dindirect-et-dadresse.png\" sizes=\"auto, \" srcset=\"\" alt=\"bagian kedua dari tidak langsung dan alamat\" width=\"416\" height=\"256\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> INDIRECT adalah fungsi yang mudah menguap, yang memperbarui nilainya setiap kali Anda memperbarui apa pun di lembar kerja Anda. Sangat menyenangkan untuk selalu memperbarui nilai sel, tetapi itu juga membuat Excel sedikit lebih lambat. <\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/obtenir-la-valeur-de-la-cellule.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/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-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghasilkan-kelompok-acak\/\">Hasilkan grup acak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bandingkan-saluran-2\/\">Bandingkan dua string (teks)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mendapatkan-domain\/\">Dapatkan domain dari id email<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ekstrak-hanya-angka\/\">Ekstrak hanya angka dari teks (string)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/teks-setelah-sebelumnya\/\">Ekstrak teks setelah dan sebelum karakter di Excel<\/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-1687","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>Dapatkan nilai sel di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan nilai sel tertentu. Mari kita periksa ini\u2026\" \/>\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\/nilai-sel-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dapatkan nilai sel di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan nilai sel tertentu. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.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\/nilai-sel-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/\",\"name\":\"Dapatkan nilai sel di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png\",\"datePublished\":\"2023-11-11T12:56:33+00:00\",\"dateModified\":\"2023-12-06T06:19:57+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan nilai sel tertentu. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dapatkan nilai sel 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":"Dapatkan nilai sel di Excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan nilai sel tertentu. Mari kita periksa ini\u2026","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\/nilai-sel-1\/","og_locale":"id_ID","og_type":"article","og_title":"Dapatkan nilai sel di Excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan nilai sel tertentu. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:57+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.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\/nilai-sel-1\/","url":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/","name":"Dapatkan nilai sel di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png","datePublished":"2023-11-11T12:56:33+00:00","dateModified":"2023-12-06T06:19:57+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mendapatkan nilai sel tertentu. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/nilai-sel-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-la-valeur-dune-cellule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/nilai-sel-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Dapatkan nilai sel 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\/1687","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=1687"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1687\/revisions"}],"predecessor-version":[{"id":2888,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1687\/revisions\/2888"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}