Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default is it possible to find the arctan of an angle in Excel or an add .


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 161
Default is it possible to find the arctan of an angle in Excel or an add .

"JmcD" wrote in message
...
nothing


PLEASE write your question in the body of the post and NOT just the subject
as it gets truncated like yours has

Have a look he http://dts-l.net/goodpost.htm


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 7,247
Default is it possible to find the arctan of an angle in Excel or an add .

You can use the ATAN function. Note that all trig functions in Excel work
with Radians, not Degrees. Thus, you may need to use the RADIANS function to
convert degrees to radians or DEGREES to convert radians to degrees. E.g.,

=DEGREES(ATAN(A1))

returns the number of degrees of the angle whose tangent is in cell A1.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"JmcD" wrote in message
...


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default is it possible to find the arctan of an angle in Excel or an add .

Years later I try to test a math equation using the historically defined ARCTAN using MS Excel and find that good old Microsoft decides that they can redefine math to match their own lame definition.

Wake up, lame programmers at MS...the ARCTAN should return the angle in degrees! As does the TAN return the ratio based on degrees. How hard is it to just provide those two functions without creating your own bias towards radians? Converting to radians should be the added work of the user.

Let me guess....the use of degrees must have some licensing cost which MS is not willing to pay in order to push out a cheaper spreadsheet?

MS is losing market share and profitability. Duh.... not a surprise to the more educated users.



On Wednesday, April 23, 2008 8:17:56 AM UTC-7, Chip Pearson wrote:
You can use the ATAN function. Note that all trig functions in Excel work
with Radians, not Degrees. Thus, you may need to use the RADIANS function to
convert degrees to radians or DEGREES to convert radians to degrees. E.g.,

=DEGREES(ATAN(A1))

returns the number of degrees of the angle whose tangent is in cell A1.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"JmcD" wrote in message
...




On Wednesday, April 23, 2008 8:17:56 AM UTC-7, Chip Pearson wrote:
You can use the ATAN function. Note that all trig functions in Excel work
with Radians, not Degrees. Thus, you may need to use the RADIANS function to
convert degrees to radians or DEGREES to convert radians to degrees. E.g.,

=DEGREES(ATAN(A1))

returns the number of degrees of the angle whose tangent is in cell A1.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com


  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 829
Default is it possible to find the arctan of an angle in Excel or an add .

wrote:
the ARCTAN should return the angle in degrees!
As does the TAN return the ratio based on degrees.


You are entitled to your opinion. But it would be nice if it were an
informed opinion.

In Excel, the argument to the TAN function is in radians, not degrees.

Here is the relevant information from the help page:

TAN(number)
Number is the angle in __radians__ for which you want the tangent.


Reply
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
angle from atan Randall_Fos New Users to Excel 2 April 5th 07 01:30 PM
degree or angle ekkeindoha Excel Worksheet Functions 3 January 29th 07 02:54 PM
Plot R-Theta [angle (0~360 degrees) and amplitude] chart in Excel Wes12 Charts and Charting in Excel 6 January 29th 06 01:29 AM
do you know how i can find the f(x) of the arctan? Kwstas Excel Worksheet Functions 2 January 10th 06 10:50 PM
How do I get Excel to tell me the angle of a line drbob2000 Excel Worksheet Functions 4 October 22nd 05 01:02 AM


All times are GMT +1. The time now is 04:46 PM.

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

About Us

"It's about Microsoft Excel"