Geek asks and answers

Atan2 function behaves differently in javascript and excellsheet

I am trying to use the atan2 math function, but I am getting the wrong value in google excel sheet. but getting the correct value in javascript atan2 function. How can I get this value in excelsheet?

my value in excel

atan2(8.6,2.7699)=0.3115

and in javascript -

atan2(8.6,2.7699)=1.259206466337312

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

can anyone say why this is happening?

If I want this value in excel, then what formula should I use?

+3
source share
3 answers

Microsoft Excel atan2 , Google Docs . javascript, "" .

+6

atan2 Excel - ATAN2 (x _num, y _num) while Javascript Math.atan2 ( y, x). .

, .

+4

Excel ATAN2 x -, y ATAN2(x,y), JavaScript ATAN2 : ATAN2(y,x)

0

More articles:


All Articles