{"id":16668,"date":"2023-11-04T11:16:52","date_gmt":"2023-11-04T11:16:52","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=16668"},"modified":"2023-11-04T11:19:16","modified_gmt":"2023-11-04T11:19:16","slug":"atan2","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/atan2\/","title":{"rendered":"ATAN2 Function"},"content":{"rendered":"\n<p>Excel ATAN2 Function is a mathematical function used to calculate the arctangent of the specified x and y coordinates. It is often used in trigonometry and geometry to find the angle of a point in a Cartesian coordinate system relative to the positive x-axis. In simpler terms, it helps you determine the angle at which a point is located from the origin.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>ATAN2(number_x, number_y)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>number_x<\/strong><\/td><td>The x-coordinate of the point.<\/td><\/tr><tr><td><strong>number_y<\/strong><\/td><td>The y-coordinate of the point.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>You can use the ATAN2 function in Excel to find the arctangent of a point&#8217;s x and y coordinates. Here&#8217;s how you can use it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ATAN2(number_x, number_y)<\/code><\/pre>\n\n\n\n<p>Let&#8217;s take an example to understand how to use the ATAN2 function. Suppose you have a point with coordinates (3, 4). You can find the angle at which this point is located from the origin (0, 0) using the ATAN2 function as follows:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ATAN2(4, 3)<\/code><\/pre>\n\n\n\n<p>This formula will return the angle in radians, which in this case is approximately 0.643501 radians.<\/p>\n\n\n\n<p>If you want the result in degrees, you can convert it by multiplying the result by 180\/\u03c0:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ATAN2(4, 3) * 180\/PI()<\/code><\/pre>\n\n\n\n<p>This will give you the angle in degrees, which is approximately 36.8699 degrees.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional information<\/h2>\n\n\n\n<p>The ATAN2 function is a valuable tool for various applications in Excel, including trigonometry, physics, and engineering. It returns results in radians, so if you need the angle in degrees, you can use the conversion factor mentioned earlier.<\/p>\n\n\n\n<p>Keep in mind that the ATAN2 function is most commonly used to find the angle in a two-dimensional Cartesian coordinate system.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel ATAN2 Function is a mathematical function used to calculate the arctangent of the specified x and y coordinates. It is often used&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ATAN2 Function<\/title>\n<meta name=\"description\" content=\"Learn how to use the Excel ATAN2 function to calculate the arctangent of coordinates and find the angle of a point relative to the x-axis.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ATAN2 Function\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the Excel ATAN2 function to calculate the arctangent of coordinates and find the angle of a point relative to the x-axis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-04T11:16:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-04T11:19:16+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ATAN2 Function\",\"datePublished\":\"2023-11-04T11:16:52+00:00\",\"dateModified\":\"2023-11-04T11:19:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\"},\"wordCount\":259,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\",\"name\":\"ATAN2 Function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2023-11-04T11:16:52+00:00\",\"dateModified\":\"2023-11-04T11:19:16+00:00\",\"description\":\"Learn how to use the Excel ATAN2 function to calculate the arctangent of coordinates and find the angle of a point relative to the x-axis.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/atan2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/atan2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ATAN2 Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ATAN2 Function","description":"Learn how to use the Excel ATAN2 function to calculate the arctangent of coordinates and find the angle of a point relative to the x-axis.","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:\/\/officetuts.net\/excel\/functions\/atan2\/","og_locale":"en_US","og_type":"article","og_title":"ATAN2 Function","og_description":"Learn how to use the Excel ATAN2 function to calculate the arctangent of coordinates and find the angle of a point relative to the x-axis.","og_url":"https:\/\/officetuts.net\/excel\/functions\/atan2\/","article_published_time":"2023-11-04T11:16:52+00:00","article_modified_time":"2023-11-04T11:19:16+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/atan2\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/atan2\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ATAN2 Function","datePublished":"2023-11-04T11:16:52+00:00","dateModified":"2023-11-04T11:19:16+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/atan2\/"},"wordCount":259,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/atan2\/","url":"https:\/\/officetuts.net\/excel\/functions\/atan2\/","name":"ATAN2 Function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2023-11-04T11:16:52+00:00","dateModified":"2023-11-04T11:19:16+00:00","description":"Learn how to use the Excel ATAN2 function to calculate the arctangent of coordinates and find the angle of a point relative to the x-axis.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/atan2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/atan2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/atan2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ATAN2 Function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16668"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=16668"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16668\/revisions"}],"predecessor-version":[{"id":16673,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16668\/revisions\/16673"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=16668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=16668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=16668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}