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

Ask a Question

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.