atan2 function behaves different in javascript and excellsheet

Question

I am trying the atan2 Math Function but i am getting wrong value in google excel sheet. but getting correct value in javascript atan2 function. How can i get that value in excelsheet ?

my value in excel is

atan2(8.6,2.7699)=0.3115

while in javascript is

atan2(8.6,2.7699)=1.259206466337312

I have checked javascript value here http://www.univie.ac.at/moe/rechner/rechner.html

can any one say why this happens ?

if i want this value in excel then what formula should i use ?

score 16 · Accepted Answer · answered May 23 '12 at 10:30

16

In Microsoft Excel the atan2 function takes the parameters in reverse order and Google Docs does the same thing for consistency. If you flip the parameters in javascript you get the same "wrong" value.

answered May 23 '12 at 10:30

chucktator

1,828
12
16

score 6 · Answer 2 · answered May 23 '12 at 10:35

6

The function signature for atan2 in Excel is ATAN2(x_num, y_num) while in Javascript it's Math.atan2(y,x). Note the order of arguments.

They should both give your roughly the same answer if you provide the arguments in the appropriate order.

answered May 23 '12 at 10:35

Shawn Chin

84,080
19
162
191

score 0 · Answer 3 · edited Feb 18 '17 at 14:58

0

Excel's ATAN2 requires the x-coordinate followed by the y coordinate ATAN2(x,y) but JavaScript ATAN2 has the arguments reversed : ATAN2(y,x)

edited Feb 18 '17 at 14:58

Maytham Fahmi

31,138
14
118
137

answered May 23 '12 at 10:37

Charles Williams

23,121
5
38
38

atan2 function behaves different in javascript and excellsheet

3 Answers3

Linked