What is the difference of ATAN and ATAN2 function? ATAN2 returns arctangent (in radians like ATAN) of typed coordinates (in X and Y). Coordinates can be any value: below, above and equal to zero. Now we have two elements of ATAN2 function as =ATAN2(X,Y). Where X and Y can be cells and values. Let’s have a look at the example below.



When you type ATAN2 remember to use semicolon to separate coordinates. In B6 cell we typed =ATAN(A2;B2) and the result was (-1,42646). You don’t have to choose coordinates from one column you can easily type all from A column as well =ATAN(A2;A4) result is 1,325818.

ATAN2 function Exercises