{"id":16665,"date":"2023-11-04T11:15:49","date_gmt":"2023-11-04T11:15:49","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=16665"},"modified":"2023-11-04T11:18:42","modified_gmt":"2023-11-04T11:18:42","slug":"atan","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/atan\/","title":{"rendered":"ATAN Function"},"content":{"rendered":"\n
Excel’s ATAN function returns the arctangent of a number, which is the angle whose tangent is a specified number. In simpler terms, it helps you find the angle in degrees for which the tangent of that angle equals the given number.<\/p>\n\n\n\n
ATAN(number)<\/strong><\/p>\n\n\n\n To use the ATAN function, follow these steps:<\/p>\n\n\n\n Let’s look at a few examples to understand how to use the ATAN function:<\/p>\n\n\n\n Example 1:<\/strong> Find the arctangent of 1. Calculate the angle for which the tangent is 1.<\/p>\n\n\n\n Result: 45 degrees <\/p>\n\n\n\n Example 2:<\/strong> Calculate the arctangent of a cell reference, say B2, which contains the number.<\/p>\n\n\n\n Result: Angle in radians<\/p>\n\n\n\n Example 3:<\/strong> If you want the result in degrees, convert it using the (180\/PI()) formula as mentioned earlier.<\/p>\n\n\n\n Result: Angle in degrees<\/p>\n\n\n\n Example 4:<\/strong> Using the ATAN function in a larger formula, e.g., calculating the angle between two points in a coordinate system.<\/p>\n\n\n\n Result: Angle in radians These examples show how you can use the ATAN function to find angles in various scenarios.<\/p>\n\n\n\n The ATAN function returns values in radians. If you need the result in degrees, you can use the (180\/PI()) conversion formula.<\/p>\n\n\n\n The arctangent function is useful in trigonometry, physics, and engineering to calculate angles based on ratios of sides in right triangles or other geometric situations.<\/p>\n\n\n\n ATAN is the inverse of the TAN function, which calculates the tangent of an angle.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel’s ATAN function returns the arctangent of a number, which is the angle whose tangent is a specified number. In simpler terms, it…<\/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":"\nArguments<\/h2>\n\n\n\n
number<\/strong><\/td> The number for which you want to find the arctangent.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
\n
=ATAN(number)<\/code><\/li>\n\n\n\n
=ATAN(number) * (180\/PI())<\/code><\/li>\n<\/ol>\n\n\n\n
Examples<\/h2>\n\n\n\n
=ATAN(1)<\/code><\/pre>\n\n\n\n
=ATAN(B2)<\/code><\/pre>\n\n\n\n
=ATAN(B2) * (180\/PI())<\/code><\/pre>\n\n\n\n
=ATAN((Y2-Y1)\/(X2-X1))<\/code><\/pre>\n\n\n\n
Additional information<\/h2>\n\n\n\n