LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Celeste
 
Posts: n/a
Default The description of the ATAN2 function in Microsoft Excel is not 1.

The description of the ATAN2 function in Microsoft Excel help does not seem
100% accurate to me. It states "ATAN2(a,b) equals ATAN(b/a), except that a
can equal 0 in ATAN2. "

I don't think that is accurate because ATAN2 takes into account the quadrant
in which z lies and has the range of -pi to pi (excluding -pi). This
special inverse tangent uses the sign of x and y to determine the quadrant,
and allows for answers in quandrant 2 (-x, +y) and quadrant 3
(-x,-y) whereas the standard arctan is restricted to quadrants 1 and 4
(range of -pi/2 to +pi/2).

There are cases in which ATAN(y/x) does not equal ATAN2(x,y), other than
when x = 0. For example, when x = -5 and y =-15, ATAN(-15/-5) = 1.249 and
ATAN2(-5,-15) = -1.89

I'm not a math expert, but this description seems misleading to me. I
suggest a description similar to the C++ ATAN2(x,y) function "The atan2()
function computes the arc tangent of y/x, using the signs of the arguments to
compute the quadrant of the return value. "

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF function yak10 Excel Worksheet Functions 0 February 12th 05 05:12 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
recherche into a special range Maileen Excel Worksheet Functions 6 December 28th 04 03:16 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"