Name
ATAN2
Synopsis
Use ATAN2 to determine the arctangent if you have the x and y coordinates for an angle. The result of the function is expressed in radians.
To Calculate
=ATAN2(X_Num
,Y_Num
)
The X_Num
and
Y_Num
arguments are required for this
function.
-
X_Num
Specifies a numeric value that represents the x-coordinate of the point.
-
Y_Num
Specifies a numeric value that represents the y-coordinate of the point.
Example
Figure 14-4 illustrates how you can take the x and y coordinates for an angle and determine the arctangent. This figure also uses DEGREES to convert the radian measurement that is returned by ATAN2 to a degree value.
Figure 14-4. If you know the x and y coordinates of an angle you can determine the arctangent
Get Excel 2000 in a Nutshell 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.