{"id":1281,"date":"2023-07-27T00:58:16","date_gmt":"2023-07-27T00:58:16","guid":{"rendered":"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/"},"modified":"2023-07-27T00:58:16","modified_gmt":"2023-07-27T00:58:16","slug":"angka-penting-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/","title":{"rendered":"Cara membulatkan ke angka penting di google sheets"},"content":{"rendered":"
\n

Seringkali, Anda mungkin ingin membulatkan suatu nilai ke sejumlah angka penting tertentu di Google Spreadsheet.<\/span><\/p>\n

Anda dapat menggunakan rumus berikut untuk melakukan ini:<\/span><\/p>\n

 = ROUND<\/span> (value,figures-(1+ INT<\/span> ( LOG10<\/span> ( ABS<\/span> (value)))))\n<\/strong><\/pre>\n
 dimana value<\/strong> adalah nilai yang ingin dibulatkan dan digit<\/strong> adalah jumlah digit penting yang ingin dibulatkan.<\/span><\/p>\n
 Berikut ringkasan fungsi rumusnya:<\/span><\/p>\n
 1.<\/strong> ABS<\/strong> mengubah nilai menjadi nilai positif.<\/span><\/p>\n
 2. LOG10<\/strong> menemukan eksponen nilainya.<\/span><\/p>\n
 3. INT<\/strong> menghilangkan tempat desimal dari nilai.<\/span><\/p>\n
 4. ROUND<\/strong> kemudian mencari jumlah digit penting yang akan dibulatkan.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Pembulatan ke Digit Penting di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara membulatkan nilai 934745<\/strong> menjadi 1<\/strong> angka penting:<\/span> <\/p>\n
\"Digit<\/p>\n
 Kita melihat bahwa nilai 934745<\/strong> dibulatkan menjadi 900000<\/strong> :<\/span> <\/p>\n
\"Angka<\/p>\n
 Perhatikan bahwa kita dapat membulatkan ke angka penting sebanyak yang kita inginkan:<\/span> <\/p>\n
\"Dibulatkan<\/p>\n
 Anda dapat menemukan tutorial Google Spreadsheet lainnya di sini .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali, Anda mungkin ingin membulatkan suatu nilai ke sejumlah angka penting tertentu di Google Spreadsheet. Anda dapat menggunakan rumus berikut untuk melakukan ini: = ROUND (value,figures-(1+ INT ( LOG10 ( ABS (value))))) dimana value adalah nilai yang ingin dibulatkan dan digit adalah jumlah digit penting yang ingin dibulatkan. Berikut ringkasan fungsi rumusnya: 1. ABS mengubah […]<\/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 membulatkan ke angka penting di Google Sheets<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membulatkan ke angka penting di Google Sheets, 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\/angka-penting-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membulatkan ke angka penting di Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membulatkan ke angka penting di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T00:58:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sigfiggooglesheets1.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\/angka-penting-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/\",\"name\":\"Cara membulatkan ke angka penting di Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T00:58:16+00:00\",\"dateModified\":\"2023-07-27T00:58:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membulatkan ke angka penting di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membulatkan ke angka penting 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 membulatkan ke angka penting di Google Sheets","description":"Tutorial ini menjelaskan cara membulatkan ke angka penting di Google Sheets, 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\/angka-penting-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membulatkan ke angka penting di Google Sheets","og_description":"Tutorial ini menjelaskan cara membulatkan ke angka penting di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T00:58:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sigfiggooglesheets1.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\/angka-penting-google-sheet\/","url":"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/","name":"Cara membulatkan ke angka penting di Google Sheets","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T00:58:16+00:00","dateModified":"2023-07-27T00:58:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membulatkan ke angka penting di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/angka-penting-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membulatkan ke angka penting 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\/1281"}],"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=1281"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1281\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}