is it possible to find the arctan of an angle in Excel or an add .

Discussion in 'Excel Beginners' started by Gordon, Apr 23, 2008.

  1. Gordon

    Gordon Guest

    "JmcD" <> wrote in message
    news:D...
    >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 here: http://dts-l.net/goodpost.htm
     
    Gordon, Apr 23, 2008
    #1
    1. Advertisements

  2. Gordon

    Chip Pearson Guest

    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
    news:D...
    >
     
    Chip Pearson, Apr 23, 2008
    #2
    1. Advertisements

  3. Gordon

    Guest

    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 themore 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 functionto
    > 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
    > news:D...
    > >




    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 functionto
    > 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
     
    , Feb 19, 2014
    #3
  4. Gordon

    joeu2004 Guest

    <> 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.
     
    joeu2004, Feb 19, 2014
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Chris_7_1
    Replies:
    1
    Views:
    93
    Don Guillett
    Jan 7, 2005
  2. Pete
    Replies:
    1
    Views:
    102
    JulieD
    Feb 2, 2005
  3. Khan
    Replies:
    2
    Views:
    84
    Ken Wright
    May 13, 2005
  4. Simon
    Replies:
    5
    Views:
    127
    Simon
    May 29, 2005
  5. Kasper

    Need to angle the borders in a column

    Kasper, Dec 29, 2005, in forum: Excel Beginners
    Replies:
    2
    Views:
    193
    surg4u1975
    Dec 29, 2005
  6. formula calculation

    how cani multiply cosine of an angle with a number,Ex cos60*2

    formula calculation, Feb 20, 2007, in forum: Excel Beginners
    Replies:
    1
    Views:
    204
    JE McGimpsey
    Feb 20, 2007
  7. Randall_Fos

    angle from atan

    Randall_Fos, Apr 3, 2007, in forum: Excel Beginners
    Replies:
    2
    Views:
    94
    Randall_Fos
    Apr 5, 2007
  8. Fooz
    Replies:
    0
    Views:
    203
Loading...