{"id":4637,"date":"2023-07-09T10:14:19","date_gmt":"2023-07-09T10:14:19","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/"},"modified":"2023-07-09T10:14:19","modified_gmt":"2023-07-09T10:14:19","slug":"google-sheet-jika-nol-maka-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/","title":{"rendered":"Google sheets: cara mengembalikan konten kosong, bukan nol"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk mengembalikan spasi, bukan nol saat menggunakan rumus di Google Spreadsheet:<\/span><\/p>\n

 =IF( B2<\/span> \/ C2<\/span> = 0<\/span> , \"\", B2<\/span> \/ C2<\/span> )<\/strong>\n<\/pre>\n
 Rumus khusus ini mencoba membagi nilai sel B2<\/strong> dengan nilai sel C2<\/strong> .<\/span><\/p>\n
 Jika hasilnya nol, Google Spreadsheet akan mengembalikan kosong.<\/span><\/p>\n
 Jika tidak, ia akan mengembalikan hasil B2<\/strong> dibagi C2<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Kembalikan kosong, bukan nol dalam rumus Google Spreadsheet<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut yang menunjukkan total penjualan dan pengembalian untuk berbagai produk:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita mengetikkan rumus berikut di sel D2<\/strong> untuk menghitung tingkat pengembalian produk A:<\/span><\/p>\n
 = B2<\/span> \/ C2<\/span><\/strong><\/pre>\n
 Jika kita mengklik dan menyeret rumus ini ke setiap sel di kolom D, kita akan melihat bahwa beberapa hasil sama dengan nol:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk mengembalikan nilai kosong dan bukan nol, kita bisa mengetikkan rumus berikut di sel D2<\/strong> :<\/span><\/p>\n
 =IF( B2<\/span> \/ C2<\/span> = 0<\/span> , \"\", B2<\/span> \/ C2<\/span> )<\/strong><\/pre>\n
 Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n
\"Google<\/p>\n
 Perhatikan bahwa setiap sel yang rumusnya akan mengembalikan nol kini mengembalikan nilai kosong.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Bagaimana cara mengganti nilai #N\/A di Google Sheets<\/a>
 Bagaimana cara mengganti teks di Google Sheets<\/a>
 Bagaimana cara mengganti spasi dengan Dash di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk mengembalikan spasi, bukan nol saat menggunakan rumus di Google Spreadsheet: =IF( B2 \/ C2 = 0 , “”, B2 \/ C2 ) Rumus khusus ini mencoba membagi nilai sel B2 dengan nilai sel C2 . Jika hasilnya nol, Google Spreadsheet akan mengembalikan kosong. Jika tidak, ia akan mengembalikan […]<\/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":"\nGoogle Spreadsheet: Cara mengembalikan kosong, bukan nol - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengembalikan spasi jika hasil rumus di Google Sheets nol, beserta contohnya.\" \/>\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-jika-nol-maka-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengembalikan kosong, bukan nol - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengembalikan spasi jika hasil rumus di Google Sheets nol, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T10:14:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rr1.png\" \/>\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-jika-nol-maka-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/\",\"name\":\"Google Spreadsheet: Cara mengembalikan kosong, bukan nol - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T10:14:19+00:00\",\"dateModified\":\"2023-07-09T10:14:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengembalikan spasi jika hasil rumus di Google Sheets nol, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengembalikan konten kosong, bukan nol\"}]},{\"@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":"Google Spreadsheet: Cara mengembalikan kosong, bukan nol - Statorial","description":"Tutorial ini menjelaskan cara mengembalikan spasi jika hasil rumus di Google Sheets nol, beserta contohnya.","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-jika-nol-maka-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengembalikan kosong, bukan nol - Statorial","og_description":"Tutorial ini menjelaskan cara mengembalikan spasi jika hasil rumus di Google Sheets nol, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-09T10:14:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rr1.png"}],"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-jika-nol-maka-kosong\/","url":"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/","name":"Google Spreadsheet: Cara mengembalikan kosong, bukan nol - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T10:14:19+00:00","dateModified":"2023-07-09T10:14:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengembalikan spasi jika hasil rumus di Google Sheets nol, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-jika-nol-maka-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengembalikan konten kosong, bukan nol"}]},{"@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\/4637"}],"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=4637"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4637\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}