{"id":1810,"date":"2023-11-03T03:25:57","date_gmt":"2023-11-03T03:25:57","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/"},"modified":"2023-12-06T06:19:48","modified_gmt":"2023-12-06T06:19:48","slug":"kesalahan-nilai","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/","title":{"rendered":"Cara memperbaiki #value! kesalahan di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-154951158\"><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 Excel, #VALUE! Kesalahan terjadi ketika jenis nilai masukan tidak benar. Misalkan Anda ingin menambahkan dua angka dari dua sel, tetapi di sel kedua nilainya adalah teks. Jadi di sini melakukan perhitungan ini tidak dapat dilakukan karena Anda tidak dapat menambahkan angka atau teks. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70013\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\" sizes=\"auto, \" srcset=\"\" alt=\"memperbaiki kesalahan nilai\" width=\"503\" height=\"282\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah untuk Memperbaiki #VALUE! Kesalahan di Excel<\/h2><ol type=\"1\"><li> Langkah pertama untuk menyetel #VALUE! kesalahannya adalah memverifikasi bahwa nilai yang Anda tentukan dalam rumus berada dalam tipe yang benar.<\/li><li> Periksa apakah nilai yang Anda tentukan dalam argumen valid atau tidak. Misalnya, jika saya ingin mengekstrak karakter <sup>ke-25<\/sup> dari sebuah teks tetapi teks ini hanya memiliki 20 karakter.<\/li><li> Setelah itu pastikan untuk memeriksa dimensi tabel yang Anda maksud. Misalnya, dalam satu baris Anda memiliki 10 sel dan di sel kedua Anda memiliki 12 sel. Hal ini juga menyebabkan #VALUE! kesalahan.<\/li><li> Periksa apakah suatu nilai dalam data masukan Anda memiliki #VALUE! kesalahan sudah. Hal ini juga dapat menyebabkan #VALUE! kesalahan pada hasilnya.<\/li><\/ol><p> Di atas adalah beberapa pemeriksaan awal yang dapat Anda lakukan untuk memperbaiki kesalahan tersebut. Sekarang kita akan melihat beberapa contoh dunia nyata untuk lebih memahaminya.<\/p><h2 class=\"wp-block-heading\"> #NILAI! Kesalahan dengan SUMPRODUK<\/h2><p> Pada contoh berikut, kita telah menggunakan fungsi SUMPRODUK dan pada tabel kedua kita mengacu pada rentang sepuluh sel, dan pada rentang kedua kita secara keliru merujuk pada B1:B9 yang memiliki 9 sel. Dan itu mengarah pada memiliki #VALUE! <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70014\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-erreur-de-valeur-avec-sumproduct.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai kesalahan dengan jumlah produk\" width=\"512\" height=\"374\"><\/figure><\/div><p> Hal ini juga dapat terjadi dengan fungsi lain, seperti SUMIF, SUMIFS, AVERAGEIF, dan AVERAGEIFS.<\/p><h2 class=\"wp-block-heading\"> #NILAI! Kesalahan saat tanggal kerja<\/h2><p> Dalam contoh berikut, kita memiliki tanggal di sel A1 yang disimpan sebagai teks dan dalam format yang salah. Sekarang jika kita mencoba menggunakan tanggal ini dalam perhitungan, maka #VALUE! <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70015\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-erreur-de-valeur-pendant-les-dates-de-travail.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai-kesalahan-selama-tanggal kerja\" width=\"508\" height=\"266\"><\/figure><\/div><p> Alasannya adalah ketika Anda mencoba melakukan penghitungan dan tanggal tersebut adalah ujian, fungsi atau bahkan rumus tersebut tidak dapat mengidentifikasi tanggal tersebut, meskipun format tanggal tersebut dapat dibaca manusia.<\/p><h2 class=\"wp-block-heading\"> #NILAI! Saat memasukkan nilai spasi dalam perhitungan<\/h2><p> Pada contoh berikut, ketika saya mencoba menambahkan sel A1 dan A2, saya mendapatkan #VALUE! kesalahan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70016\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-valeur-quand-inclure-la-valeur-de-lespace.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai-ketika-sertakan-ruang-nilai\" width=\"422\" height=\"329\"><\/figure><\/div><p> Alasannya begini: di sel A1 kita memiliki ruang yang tidak terlihat oleh pengguna mana pun. Dan ketika saya merujuknya dalam perhitungan, saya mendapat #VALUE!<\/p><p> Berikut adalah beberapa alasan mengapa Anda mungkin menghadapi #VALUE! kesalahan di Excel. Namun cara terbaik untuk mengatasi kesalahan ini adalah dengan melihat nilai yang Anda referensikan dalam rumus. <\/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\/11\/corriger-lerreur-de-valeur.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\/kesalahan-pembagian\/\">Kesalahan #DIV\/0<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-tumpahan\/\">#MENYEBAR! Kesalahan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengabaikan-kesalahan\/\">Abaikan semua kesalahan di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tidak-ada-kesalahan\/\">#N\/A Kesalahan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-referensi\/\">#REF! Kesalahan 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-1810","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 memperbaiki #VALUE! Kesalahan di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, Anda memahami #VALUE! kesalahan, kapan kita dihadapkan padanya, dan apa cara untuk memperbaikinya?\" \/>\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\/kesalahan-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memperbaiki #VALUE! Kesalahan di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, Anda memahami #VALUE! kesalahan, kapan kita dihadapkan padanya, dan apa cara untuk memperbaikinya?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.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\/kesalahan-nilai\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/\",\"name\":\"Cara memperbaiki #VALUE! Kesalahan di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\",\"datePublished\":\"2023-11-03T03:25:57+00:00\",\"dateModified\":\"2023-12-06T06:19:48+00:00\",\"description\":\"Dalam tutorial rumus ini, Anda memahami #VALUE! kesalahan, kapan kita dihadapkan padanya, dan apa cara untuk memperbaikinya?\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memperbaiki #value! kesalahan 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 memperbaiki #VALUE! Kesalahan di Excel? - Penasihat Excel","description":"Dalam tutorial rumus ini, Anda memahami #VALUE! kesalahan, kapan kita dihadapkan padanya, dan apa cara untuk memperbaikinya?","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\/kesalahan-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memperbaiki #VALUE! Kesalahan di Excel? - Penasihat Excel","og_description":"Dalam tutorial rumus ini, Anda memahami #VALUE! kesalahan, kapan kita dihadapkan padanya, dan apa cara untuk memperbaikinya?","og_url":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:48+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.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\/kesalahan-nilai\/","url":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/","name":"Cara memperbaiki #VALUE! Kesalahan di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png","datePublished":"2023-11-03T03:25:57+00:00","dateModified":"2023-12-06T06:19:48+00:00","description":"Dalam tutorial rumus ini, Anda memahami #VALUE! kesalahan, kapan kita dihadapkan padanya, dan apa cara untuk memperbaikinya?","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memperbaiki #value! kesalahan 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\/1810","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=1810"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1810\/revisions"}],"predecessor-version":[{"id":2879,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1810\/revisions\/2879"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}