ATAN2 function
the arctangent from x- and y-coordinates.
Math and trigonometry
Where can you use it?
Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.
Scenario in the workbook
Find direction from horizontal and vertical coordinates. Excel takes the horizontal coordinate first. Equal positive coordinates give 45 degrees.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 1 | 1 |
| 8 | 2 | 2 |
| 9 | 3 | 3 |
Record 1
=ATAN2(A7,B7)Expected result0.7853981634
See the inputs and instructions for all 3 examplesSyntax
ATAN2(x_num, y_num)
Copyable formulas
English Excel · en-US
=ATAN2(A7,B7)Turkish Excel · tr-TR
=ATAN2(A7;B7)Worked examples
Find direction from horizontal and vertical coordinates. Excel takes the horizontal coordinate first. Equal positive coordinates give 45 degrees.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 1 | 1 |
| 8 | 2 | 2 |
| 9 | 3 | 3 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =ATAN2(A7,B7) |
0.7853981634 |
| Record 2 | =ATAN2(A8,B8) |
0.7853981634 |
| Record 3 | =ATAN2(A9,B9) |
0.7853981634 |