Forum Discussion
DayoungPark
Jul 25, 2025Copper Contributor
ATAN(), ATAN2() return same value?
In below site, M365 said that ATAN2(a,b) is the same as ATAN(b/a), except that a can be zero in ATAN2. (https://support.microsoft.com/ko-kr/office/atan2-%ED%95%A8%EC%88%98-c04592ab-b9e3-4908-b42...
PeterBartholomew1
Jul 26, 2025Silver Contributor
As SergeiBaklan pointed out, you have omitted as set of parentheses in the division.
However, care needs to be taken because ATAN loses sign information when the division is carried out and only returns angles in the range -π/2 to +π/2. ATAN2 retains information on the sign of each parameter and so can return angles in the range 0 to 2π.
The angles returned by the two functions may differ by π. In the present case, I believe entering a value of 32.176 in cell $C$3 will still make the corrected formulas give different results because it results in a sign change.