{"id":2807,"date":"2023-07-20T14:57:04","date_gmt":"2023-07-20T14:57:04","guid":{"rendered":"https:\/\/statorials.org\/id\/iserror-lembar-google\/"},"modified":"2023-07-20T14:57:04","modified_gmt":"2023-07-20T14:57:04","slug":"iserror-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/iserror-lembar-google\/","title":{"rendered":"Cara menggunakan iserror di google spreadsheet (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Fungsi ISERROR<\/b> Google Sheets dapat digunakan untuk memeriksa apakah suatu nilai dalam sel tertentu merupakan kesalahan.<\/span><\/p>\n

Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n

 =<\/span> ISERROR<\/span> (<\/span> A1<\/span> )<\/span><\/strong><\/pre>\n
 Fungsi ini mengembalikan TRUE<\/strong> jika nilai dalam sel A1<\/strong> adalah kesalahan, jika tidak maka akan mengembalikan FALSE<\/strong> .<\/span><\/span><\/p>\n
 Contoh berikut menunjukkan penggunaan fungsi ini dalam dua skenario berbeda di Google Spreadsheet.<\/span><\/span><\/p>\n
 Contoh 1: Gunakan ISERROR untuk mengembalikan nilai baru<\/strong><\/span><\/h3>\n
 Misalkan kita mencoba membagi nilai di kolom A dengan nilai di kolom B pada spreadsheet Google Sheets berikut:<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Membagi dengan nol menghasilkan #DIV\/0!<\/strong> sesuai di kolom C.<\/span><\/p>\n
 Kita bisa menggunakan rumus berikut untuk mengembalikan nilai “Divisi Tidak Valid”:<\/span><\/p>\n
 =<\/span> IF(ISERROR<\/span> (<\/span> A2<\/span> \/ B2<\/span> ), \"Invalid Division\", A2<\/span> \/ B2<\/span> )<\/span>\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Jika ISERROR(A2\/B2)<\/strong> adalah TRUE<\/strong> , maka \u201cPembagian Tidak Valid\u201d dikembalikan.<\/span><\/p>\n
 Sebaliknya, jika fungsi ISERROR(A2\/B2)<\/strong> adalah FALSE<\/strong> , maka hasil A2\/B2 akan dikembalikan.<\/span><\/p>\n
 Contoh 2: Menggunakan ISERROR dengan VLOOKUP<\/strong><\/span><\/h3>\n
 Misalkan kita mencoba melakukan VLOOKUP<\/strong> pada lembar kerja berikut untuk menemukan nilai di kolom Poin<\/strong> yang sesuai dengan nama “Mag” di kolom Tim<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Karena nama “Mag” tidak ada di kolom Tim<\/strong> , kami menerima #N\/A<\/strong> sebagai hasilnya.<\/span><\/p>\n
 Sebagai gantinya, kita bisa menggunakan rumus berikut untuk mengembalikan “Tim tidak ada” jika rumus VLOOKUP<\/strong> gagal menemukan nama tim:<\/span><\/p>\n
 =<\/span> IF<\/span> (<\/span> ISERROR<\/span> (<\/span> VLOOKUP<\/span> (<\/span> \" Mag<\/span> \"<\/span> ,<\/span> A1:B11,2<\/span> ,<\/span> FALSE<\/span> )<\/span> )<\/span> ,<\/span> \" Team<\/span> Does Not Exist<\/span> \"<\/span> ,<\/span> VLOOKUP<\/span> (<\/span> \"<\/span> Mag<\/span> \"<\/span> ,<\/span> A1<\/span> :<\/span> B11,2<\/span> ,<\/span> FALSE<\/span> )<\/span> )<\/span> \n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Karena nama “Mag” tidak ada di kolom Tim<\/strong> , rumusnya akan mengembalikan “Tim tidak ada” sebagai hasilnya, bukan #N\/A<\/strong> .<\/span><\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi online lengkap untuk fungsi ISERROR<\/b> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Bagaimana cara mengganti teks di Google Sheets<\/a>
 Bagaimana cara mengganti sel kosong dengan nol di Google Sheets<\/a>
 Cara menggunakan VLOOKUP peka huruf besar-kecil di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Fungsi ISERROR Google Sheets dapat digunakan untuk memeriksa apakah suatu nilai dalam sel tertentu merupakan kesalahan. Fungsi ini menggunakan sintaks dasar berikut: = ISERROR ( A1 ) Fungsi ini mengembalikan TRUE jika nilai dalam sel A1 adalah kesalahan, jika tidak maka akan mengembalikan FALSE . Contoh berikut menunjukkan penggunaan fungsi ini dalam dua skenario berbeda […]<\/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":"\nCara Menggunakan ISERROR di Google Sheets (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi ISERROR di Google Sheets, dengan beberapa 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\/iserror-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan ISERROR di Google Sheets (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi ISERROR di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:57:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iserror1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\",\"name\":\"Cara Menggunakan ISERROR di Google Sheets (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:57:04+00:00\",\"dateModified\":\"2023-07-20T14:57:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi ISERROR di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/iserror-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/iserror-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan iserror di google spreadsheet (dengan contoh)\"}]},{\"@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 Menggunakan ISERROR di Google Sheets (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi ISERROR di Google Sheets, dengan beberapa 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\/iserror-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan ISERROR di Google Sheets (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi ISERROR di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/iserror-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:57:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/iserror1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/iserror-lembar-google\/","url":"https:\/\/statorials.org\/id\/iserror-lembar-google\/","name":"Cara Menggunakan ISERROR di Google Sheets (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:57:04+00:00","dateModified":"2023-07-20T14:57:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi ISERROR di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/iserror-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/iserror-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/iserror-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan iserror di google spreadsheet (dengan contoh)"}]},{"@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\/2807"}],"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=2807"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2807\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}