{"id":1779,"date":"2023-11-05T12:18:21","date_gmt":"2023-11-05T12:18:21","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/"},"modified":"2023-12-06T06:20:04","modified_gmt":"2023-12-06T06:20:04","slug":"bilangan-bulat-3","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/","title":{"rendered":"Fungsi excel: int"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-774156652\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>INT <strong>mengembalikan bagian integer dari angka desimal<\/strong> . Dengan kata sederhana, ini membulatkan angka tertentu dengan menghilangkan tempat desimalnya dan hanya mengembalikan angka bulat (angka tanpa pecahan atau desimal). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72702\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi int\" width=\"482\" height=\"169\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> INT(angka)<\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>number:<\/strong> angka yang ingin dibulatkan ke bawah ke bilangan bulat terdekat.<\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Pada contoh di bawah ini kita memiliki angka dengan empat tempat desimal dan ketika Anda menggunakan fungsi INT dan menentukan nilai yang Anda miliki di sel B1, ia akan mengembalikan angka yang sama dengan tetapi tanpa tempat desimal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66958\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-int-1-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-int-fungsi-contoh-1\" width=\"485\" height=\"280\"><\/figure><\/div><p> Jadi jika Anda memiliki 101,4868 pada nilai aslinya, INT mengembalikan 101 pada hasil setelah menghilangkan tempat desimal.<\/p><p> Sekarang, di dunia nyata, INT sangat berguna, dan salah satu contohnya adalah ketika Anda perlu menghapus waktu dari nilai datetime. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66959\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-int-fonction-date-separee.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-int-tanggal-dipisahkan-fungsi\" width=\"431\" height=\"161\"><\/figure><\/div><p> Demikian pula, Anda dapat menggunakannya untuk menghapus tanggal dari nilai tanggal dan waktu, seperti yang kami gunakan pada contoh di bawah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66960\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-int-fonction-temps-separe.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-int-fungsi-dipisahkan waktu\" width=\"472\" height=\"165\"><\/figure><\/div><p> <strong><em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/entier-2.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">contoh-file.xlsx<\/a><\/em><\/strong><\/p><h2 class=\"wp-block-heading\"> Poin penting<\/h2><ol><li> Ini akan membulatkan angka positif dan negatif. Namun jika Anda membulatkan angka negatif, maka angka tersebut akan membulatkannya dari nol. Jadi ketika Anda membulatkan -3,9 hasilnya akan menjadi 4.<\/li><li> Anda mendapatkan #REF! kesalahan jika nomor yang Anda tentukan tidak valid, dan kesalahan #VALUE! Kesalahan jika Anda menentukan teks dan bukan angka.<\/li><\/ol>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1779","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>INT (Fungsi Excel dengan contoh + file contoh)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan fungsi INT di Excel. Pahami fungsinya dengan contoh yang mudah diikuti.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INT (Fungsi Excel dengan contoh + file contoh)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan fungsi INT di Excel. Pahami fungsinya dengan contoh yang mudah diikuti.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/\",\"name\":\"INT (Fungsi Excel dengan contoh + file contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png\",\"datePublished\":\"2023-11-05T12:18:21+00:00\",\"dateModified\":\"2023-12-06T06:20:04+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan fungsi INT di Excel. Pahami fungsinya dengan contoh yang mudah diikuti.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fungsi excel: int\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"INT (Fungsi Excel dengan contoh + file contoh)","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan fungsi INT di Excel. Pahami fungsinya dengan contoh yang mudah diikuti.","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:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/","og_locale":"id_ID","og_type":"article","og_title":"INT (Fungsi Excel dengan contoh + file contoh)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan fungsi INT di Excel. Pahami fungsinya dengan contoh yang mudah diikuti.","og_url":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/","url":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/","name":"INT (Fungsi Excel dengan contoh + file contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png","datePublished":"2023-11-05T12:18:21+00:00","dateModified":"2023-12-06T06:20:04+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan fungsi INT di Excel. Pahami fungsinya dengan contoh yang mudah diikuti.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-entiere.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bilangan-bulat-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Fungsi excel: int"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1779"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1779\/revisions"}],"predecessor-version":[{"id":2895,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1779\/revisions\/2895"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}