{"id":2842,"date":"2023-07-20T11:08:25","date_gmt":"2023-07-20T11:08:25","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/"},"modified":"2023-07-20T11:08:25","modified_gmt":"2023-07-20T11:08:25","slug":"google-sheet-ganti-na","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/","title":{"rendered":"Bagaimana cara mengganti nilai #n\/a di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengganti nilai #N\/A di Google Spreadsheet dengan nol atau spasi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#replace #N\/A with zero<\/span>\n=IFERROR(FORMULA, \"0\")\n\n<span style=\"color: #008080;\">#replace #N\/A with blank\n<\/span>=IFERROR(FORMULA, \"\") \n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaks ini dalam praktiknya untuk mengganti nilai #N\/A dalam VLOOKUP dengan nol atau spasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Cara Mengganti Sel Kosong dengan Nol di Google Sheets<\/a><\/span><\/p>\n<h3> <strong>Contoh: Ganti nilai #N\/A di Google Sheets<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan nama tim dan poin yang dicetak untuk berbagai tim bola basket:<br \/><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24893 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesreplace1.jpg\" alt=\"\" width=\"457\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan misalkan kita menggunakan fungsi <strong>VLOOKUP()<\/strong> untuk mencari poin berdasarkan nama tim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24895 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesreplace2.jpg\" alt=\"\" width=\"561\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa beberapa nilai yang dikembalikan dalam <strong>VLOOKUP()<\/strong> adalah nilai <strong>#N\/A<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mengubah nilai tersebut menjadi nol menggunakan fungsi <strong>IFERROR()<\/strong> sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFERROR(VLOOKUP( <span style=\"color: #ff6600;\">A2<\/span> , <span style=\"color: #800080;\">$A$2:$B$11<\/span> , <span style=\"color: #3366ff;\">2<\/span> , <span style=\"color: #3366ff;\">FALSE<\/span> ), \u201c <span style=\"color: #008000;\">0<\/span> \u201d)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24894\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesreplace3.jpg\" alt=\"Google Spreadsheet menggantikan nilai #N\/A\" width=\"569\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>VLOOKUP()<\/strong> kini mengembalikan nilai 0, bukan <strong>#N\/A<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Alternatifnya, kita dapat mengubah nilai <strong>#N\/A<\/strong> menjadi kosong menggunakan fungsi <strong>IFERROR()<\/strong> sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #008080;\">#replace #N\/A with blank<\/span>\n=IFERROR(VLOOKUP( <span style=\"color: #ff6600;\">A2<\/span> , <span style=\"color: #800080;\">$A$2:$B$11<\/span> , <span style=\"color: #3366ff;\">2<\/span> , <span style=\"color: #3366ff;\">FALSE<\/span> ), \"\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24896 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesreplace4.jpg\" alt=\"\" width=\"570\" height=\"472\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap nilai yang sebelumnya <strong>#N\/A<\/strong> sekarang kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perlu dicatat bahwa kita dapat menggunakan fungsi <strong>IFERROR()<\/strong> untuk mengganti nilai <strong>#N\/A<\/strong> dengan nilai apa pun yang kita inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada contoh sebelumnya, kita cukup mengganti nilai <strong>#N\/A<\/strong> dengan nol atau spasi, karena ini adalah nilai pengganti yang paling umum digunakan dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengabaikan-sel-kosong\/\" target=\"_blank\" rel=\"noopener\">Cara mengabaikan sel kosong dengan rumus di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-abaikan-na\/\" target=\"_blank\" rel=\"noopener\">Cara mengabaikan nilai #N\/A dengan rumus di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengganti nilai #N\/A di Google Spreadsheet dengan nol atau spasi: #replace #N\/A with zero =IFERROR(FORMULA, &#8220;0&#8221;) #replace #N\/A with blank =IFERROR(FORMULA, &#8220;&#8221;) Contoh berikut menunjukkan cara menggunakan sintaks ini dalam praktiknya untuk mengganti nilai #N\/A dalam VLOOKUP dengan nol atau spasi. Terkait: Cara Mengganti Sel Kosong dengan Nol [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara mengganti nilai #N\/A di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti nilai #N\/A di Google Sheets, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengganti nilai #N\/A di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti nilai #N\/A di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T11:08:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesreplace1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/\",\"name\":\"Cara mengganti nilai #N\/A di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T11:08:25+00:00\",\"dateModified\":\"2023-07-20T11:08:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti nilai #N\/A di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengganti nilai #n\/a di google sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara mengganti nilai #N\/A di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengganti nilai #N\/A di Google Sheets, dengan sebuah contoh.","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:\/\/statorials.org\/id\/google-sheet-ganti-na\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengganti nilai #N\/A di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengganti nilai #N\/A di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/","og_site_name":"Statorials","article_published_time":"2023-07-20T11:08:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesreplace1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/","url":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/","name":"Cara mengganti nilai #N\/A di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T11:08:25+00:00","dateModified":"2023-07-20T11:08:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti nilai #N\/A di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-ganti-na\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-ganti-na\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengganti nilai #n\/a di google sheets"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2842"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2842"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2842\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}