{"id":1938,"date":"2023-10-27T14:59:30","date_gmt":"2023-10-27T14:59:30","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/atn\/"},"modified":"2023-12-06T06:16:46","modified_gmt":"2023-12-06T06:16:46","slug":"atn","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/atn\/","title":{"rendered":"Bagaimana cara menggunakan fungsi vba atn?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-87739604\"><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>Fungsi VBA ATN tercantum dalam kategori matematika fungsi VBA. Saat Anda menggunakannya dalam kode VBA, <strong>ini dapat mengembalikan tangen angka yang Anda berikan.<\/strong> Secara sederhana, arctangent digunakan untuk menghitung sudut segitiga siku-siku dan ATN mengembalikannya untuk angka yang Anda tentukan.<\/p><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> <strong>Atn (Nomor)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>Nomor<\/strong> : Nomor yang ingin Anda hitung garis singgung busurnya.<\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Untuk memahami secara praktis cara menggunakan fungsi VBA ATN, Anda perlu melihat contoh di bawah ini di mana kami telah menulis kode VBA menggunakan fungsi tersebut: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"contoh-vba-atn-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-atn-function\" width=\"718\" height=\"452\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_ATN() Range(\"B1\").Value = Atn(Range(\"A1\")) End Sub<\/code><\/pre><p> Dalam contoh di atas, kami menggunakan nilai dari sel A1 di mana kami memiliki angka yang ingin kami hitung tangen busurnya, lalu kami menggunakan ATN untuk mengonversi nilai tersebut menjadi angka absolut dan memasukkan nilai tersebut di sel B1.<\/p><h2 class=\"wp-block-heading\"> Komentar<\/h2><ul><li> Jika nilai yang ditentukan adalah nilai selain angka atau angka yang tidak dapat dikenali sebagai angka, VBA akan mengembalikan runtime error 13.<\/li><li> Anda dapat mengalikan hasil yang dikembalikan oleh ATN dengan pi\/180 untuk mengubahnya menjadi radian dan 180\/pi untuk mengubahnya menjadi derajat. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-51\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/perut-1\/\">ABS VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/karena\/\">Karena VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pengalaman\/\">PENGALAMAN VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/memperbaiki\/\">PERBAIKAN VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ke-dalam\/\">VBA INT<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><\/div><\/div><\/div><\/div>","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-1938","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>Bagaimana cara menggunakan fungsi VBA ATN? (Sintaks + Contoh)<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan fungsi VBA ATN dengan sintaks, argumen, dan contoh dengan kode contoh.\" \/>\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\/atn\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan fungsi VBA ATN? (Sintaks + Contoh)\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan fungsi VBA ATN dengan sintaks, argumen, dan contoh dengan kode contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/atn\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.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\/atn\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/atn\/\",\"name\":\"Bagaimana cara menggunakan fungsi VBA ATN? (Sintaks + Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/atn\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/atn\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png\",\"datePublished\":\"2023-10-27T14:59:30+00:00\",\"dateModified\":\"2023-12-06T06:16:46+00:00\",\"description\":\"Pelajari cara menggunakan fungsi VBA ATN dengan sintaks, argumen, dan contoh dengan kode contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/atn\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/atn\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/atn\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/atn\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi vba atn?\"}]},{\"@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":"Bagaimana cara menggunakan fungsi VBA ATN? (Sintaks + Contoh)","description":"Pelajari cara menggunakan fungsi VBA ATN dengan sintaks, argumen, dan contoh dengan kode contoh.","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\/atn\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi VBA ATN? (Sintaks + Contoh)","og_description":"Pelajari cara menggunakan fungsi VBA ATN dengan sintaks, argumen, dan contoh dengan kode contoh.","og_url":"https:\/\/exceladvisor.org\/id\/atn\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.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\/atn\/","url":"https:\/\/exceladvisor.org\/id\/atn\/","name":"Bagaimana cara menggunakan fungsi VBA ATN? (Sintaks + Contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/atn\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/atn\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png","datePublished":"2023-10-27T14:59:30+00:00","dateModified":"2023-12-06T06:16:46+00:00","description":"Pelajari cara menggunakan fungsi VBA ATN dengan sintaks, argumen, dan contoh dengan kode contoh.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/atn\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/atn\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/atn\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-atn.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/atn\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi vba atn?"}]},{"@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\/1938","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=1938"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1938\/revisions"}],"predecessor-version":[{"id":2556,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1938\/revisions\/2556"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}