{"id":2812,"date":"2023-07-20T14:26:52","date_gmt":"2023-07-20T14:26:52","guid":{"rendered":"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/"},"modified":"2023-07-20T14:26:52","modified_gmt":"2023-07-20T14:26:52","slug":"sisakan-fungsi-mod-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/","title":{"rendered":"Cara mendapatkan sisanya di google sheets menggunakan fungsi mod"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <b>MOD<\/b> di Google Sheets untuk menghitung sisanya setelah operasi pembagian.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">MOD<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">dividend, divisor)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Emas:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>dividen<\/strong> : Jumlah yang akan dibagi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>pembagi<\/strong> : Bilangan yang akan dibagi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan penggunaan fungsi ini dalam berbagai skenario di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menggunakan fungsi MOD tanpa sisa<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>MOD<\/strong> dalam situasi di mana tidak ada sisa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24695 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod1.jpg\" alt=\"\" width=\"482\" height=\"373\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasil tersebut terlihat bahwa sisa 36 dibagi 6 adalah <strong>nol<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Memang benar 6 habis dibagi 36 tepat 6 kali dan tidak ada sisa.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menggunakan fungsi MOD dengan sisa<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>MOD<\/strong> dalam situasi dimana ada sisa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24696 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod2.jpg\" alt=\"\" width=\"499\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasil tersebut terlihat bahwa sisa 36 dibagi 7 <strong>sama dengan satu<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sesungguhnya 7 habis dibagi 36 sebanyak 5 kali dan ada sisa 1.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Menggunakan fungsi MOD saat membagi dengan nol<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan hasil penggunaan fungsi <strong>MOD<\/strong> saat kita mencoba membagi dengan nol:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24697 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod3.jpg\" alt=\"\" width=\"504\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami menerima <strong>#DIV\/0!<\/strong> kesalahan karena tidak mungkin membagi dengan nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita ingin menghilangkan kesalahan ini, kita bisa menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=IFERROR(MOD( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> , <span dir=\"auto\" style=\"color: #800080;\">B2<\/span> ), <span class=\" string \" dir=\"auto\">\"\"<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24698 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod4.jpg\" alt=\"\" width=\"506\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Karena kami mencoba membagi dengan nol, rumusnya hanya mengembalikan nilai kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi online lengkap untuk fungsi <b>MOD<\/b> <a href=\"https:\/\/support.google.com\/docs\/answer\/3093497?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 menggunakan fungsi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-spreadsheet-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi AVERAGEIFS di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi ISERROR 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 fungsi MOD di Google Sheets untuk menghitung sisanya setelah operasi pembagian. Fungsi ini menggunakan sintaks dasar berikut: = MOD ( dividend, divisor) Emas: dividen : Jumlah yang akan dibagi pembagi : Bilangan yang akan dibagi Contoh berikut menunjukkan penggunaan fungsi ini dalam berbagai skenario di Google Spreadsheet. Contoh 1: Menggunakan fungsi MOD [&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 mendapatkan sisanya di Google Sheets menggunakan fungsi MOD - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung sisa soal pembagian di Google Sheets menggunakan fungsi MOD.\" \/>\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\/sisakan-fungsi-mod-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mendapatkan sisanya di Google Sheets menggunakan fungsi MOD - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung sisa soal pembagian di Google Sheets menggunakan fungsi MOD.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:26:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod1.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\/sisakan-fungsi-mod-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/\",\"name\":\"Cara mendapatkan sisanya di Google Sheets menggunakan fungsi MOD - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:26:52+00:00\",\"dateModified\":\"2023-07-20T14:26:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung sisa soal pembagian di Google Sheets menggunakan fungsi MOD.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mendapatkan sisanya di google sheets menggunakan fungsi mod\"}]},{\"@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 mendapatkan sisanya di Google Sheets menggunakan fungsi MOD - Statorials","description":"Tutorial ini menjelaskan cara menghitung sisa soal pembagian di Google Sheets menggunakan fungsi MOD.","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\/sisakan-fungsi-mod-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mendapatkan sisanya di Google Sheets menggunakan fungsi MOD - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung sisa soal pembagian di Google Sheets menggunakan fungsi MOD.","og_url":"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:26:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod1.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\/sisakan-fungsi-mod-google-sheet\/","url":"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/","name":"Cara mendapatkan sisanya di Google Sheets menggunakan fungsi MOD - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:26:52+00:00","dateModified":"2023-07-20T14:26:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung sisa soal pembagian di Google Sheets menggunakan fungsi MOD.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sisakan-fungsi-mod-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mendapatkan sisanya di google sheets menggunakan fungsi mod"}]},{"@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\/2812"}],"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=2812"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2812\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}