How to use the Excel ATAN2 function

The Excel ATAN2 function returns the arctangent from the x and y coordinates of a point. In geometric terms, the function returns the radian angle corresponding to the coordinates of the input point. If you imagine a ray starting from the origin of the coordinate system and extending outwards, every point along the ray will return the same angle value. A circle of radius one demonstrates all possible return values for the function.

Syntax: =ATAN2(x_num, y_num)

The ATAN2 function syntax has the following arguments:

  • X_num (Required): The x-coordinate of the point.
  • Y_num (Required): The y-coordinate of the point.

Example: Let’s look at some Excel ATAN2 function examples and explore how to use the ATAN2 function as a worksheet function in Microsoft Excel:

Excel ATAN2 function - How to use the Excel ATAN2 function

Syntax:  =ATAN2(F11,G11)

Result:

Excel ATAN2 function 1 - How to use the Excel ATAN2 function

Based on the Excel spreadsheet above, the following ATAN2 examples would return:

Syntax: =ATAN2(F12,G12)
Result: 0.321750554

Syntax: =ATAN2(F13,G13)
Result: 0.643501109

Syntax: =ATAN2(F14,G14)
Result: 1.047184849

Syntax: =ATAN2(F15,G15)
Result: 1.352127381

Syntax: =ATAN2(F16,G16)
Result: 1.373400767

Syntax: =ATAN2(F17,G17)
Result: 1.768191887

Syntax: =ATAN2(F18,G18)
Result: 2.077894831

Syntax: =ATAN2(F19,G19)
Result: 2.498091545

……

READ:  How to use the Excel LOG function

Add a Comment

Your email address will not be published. Required fields are marked *