{"id":2723,"date":"2023-07-21T00:24:11","date_gmt":"2023-07-21T00:24:11","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/"},"modified":"2023-07-21T00:24:11","modified_gmt":"2023-07-21T00:24:11","slug":"google-sheet-menemukan-nilai-terdekat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/","title":{"rendered":"Cara menemukan nilai terdekat di google spreadsheet (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut untuk menemukan nilai terdekat dengan angka di Google Spreadsheet:<\/span><\/p>\n

Metode 1: Temukan nilai terdekat<\/strong><\/span><\/p>\n

 =<\/span> FILTER( A2:B15<\/span> ,ABS( D2<\/span> -<\/span> B2:B15<\/span> ) =<\/span> min(ABS( D2<\/span> -<\/span> B2:B15<\/span> )))<\/span>\n<\/strong><\/pre>\n
 Metode ini menemukan baris dalam rentang A2:B15<\/strong> yang nilai dalam rentang B2:B15<\/strong> paling dekat dengan nilai dalam sel D2<\/strong> .<\/span><\/p>\n
 Metode 2: Temukan nilai terdekat (lebih besar dari).<\/strong><\/span><\/p>\n
 =QUERY( A2:B15<\/span> , \" select A, B where B >=<\/span> \"<\/span> &<\/span> D2<\/span> &<\/span> \" order by B limit 1<\/span> \"<\/span> , 0<\/span> )\n<\/span><\/strong><\/pre>\n
 Cara ini mencari baris pada rentang A2:B15<\/strong> yang nilai pada kolom B<\/strong> paling dekat dengan nilai pada sel D2<\/strong> dan juga lebih besar atau sama dengan nilai pada sel D2<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan setiap metode dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: Temukan nilai terdekat<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk mencari garis di A2:B15<\/strong> yang nilai “titiknya” paling dekat dengan 31:<\/span><\/p>\n
 =<\/span> FILTER( A2:B15<\/span> ,ABS( D2<\/span> -<\/span> B2:B15<\/span> ) =<\/span> min(ABS( D2<\/span> -<\/span> B2:B15<\/span> )))<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Google<\/p>\n
 Tim dengan nilai poin terdekat di angka 31<\/strong> adalah Hornets. Mereka memiliki 30<\/strong> poin.<\/span><\/p>\n
 Contoh 2: Temukan nilai terdekat (lebih besar dari)<\/strong><\/span><\/h3>\n
 Kita bisa menggunakan rumus berikut untuk mencari garis di A2:B15<\/strong> yang nilai “titiknya” paling dekat dengan 31 dan juga lebih besar atau sama dengan 31:<\/span><\/p>\n
 =QUERY( A2:B15<\/span> , \" select A, B where B >=<\/span> \"<\/span> &<\/span> D2<\/span> &<\/span> \" order by B limit 1<\/span> \"<\/span> , 0<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Google<\/p>\n
 Tim dengan nilai poin paling dekat dengan 31<\/strong> dan berada pada atau di atas 31<\/strong> adalah Knicks. Mereka mengumpulkan 36<\/strong> poin.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a>
 Google Spreadsheet: Cara menggunakan COUNTIF dengan banyak rentang<\/a>
 Google Sheets: Cara menggunakan COUNTIFS dengan rentang tanggal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut untuk menemukan nilai terdekat dengan angka di Google Spreadsheet: Metode 1: Temukan nilai terdekat = FILTER( A2:B15 ,ABS( D2 – B2:B15 ) = min(ABS( D2 – B2:B15 ))) Metode ini menemukan baris dalam rentang A2:B15 yang nilai dalam rentang B2:B15 paling dekat dengan nilai dalam sel D2 . Metode 2: […]<\/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 Menemukan Nilai Terdekat di Google Sheets (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan nilai terdekat 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\/google-sheet-menemukan-nilai-terdekat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menemukan Nilai Terdekat di Google Sheets (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan nilai terdekat di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T00:24:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fermer0.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-menemukan-nilai-terdekat\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/\",\"name\":\"Cara Menemukan Nilai Terdekat di Google Sheets (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T00:24:11+00:00\",\"dateModified\":\"2023-07-21T00:24:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan nilai terdekat di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan nilai terdekat 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 Menemukan Nilai Terdekat di Google Sheets (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menemukan nilai terdekat 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\/google-sheet-menemukan-nilai-terdekat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menemukan Nilai Terdekat di Google Sheets (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menemukan nilai terdekat di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/","og_site_name":"Statorials","article_published_time":"2023-07-21T00:24:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fermer0.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-menemukan-nilai-terdekat\/","url":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/","name":"Cara Menemukan Nilai Terdekat di Google Sheets (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T00:24:11+00:00","dateModified":"2023-07-21T00:24:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan nilai terdekat di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-terdekat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan nilai terdekat 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\/2723"}],"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=2723"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2723\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}