ATAN2()
Syntax. ATAN2(x_num,y_num)
Definition. This function returns the arctangent based on an x-coordinate or a y-coordinate. The arctangent is the angle between the x-axis and a line through the origin (0, 0) and a point defined by the x-coordinate and y-coordinate.
The angle is returned as a radian measure between –π and π, excluding –π.
Arguments
x_num (required) The x-coordinate of the point
y_num (required) The y-coordinate of the point
Background. The ATAN2() function is another inverse tangent function (see Figure 16-8). However, the result is not calculated based on a tangent but on an xy-coordinate. The result is a radian measure and has to be converted into degrees with the DEGREES() function or by multiplying the result with 180/PI().
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
