+ Reply to Thread
Results 1 to 6 of 6

Change radians - degrees setting

  1. #1
    David
    Guest

    Change radians - degrees setting

    How do I change setting for trigonomic functions, radians - degrees.
    I am making a table with many different trig functions, the answers are
    currently in radians, I need degrees.
    Using Excel 2003.
    Thanks.

  2. #2
    Chip Pearson
    Guest

    Re: Change radians - degrees setting

    All of Excel's trig functions use radians, not degrees, and there
    is no way to change that. You can use the DEGREES function to
    convert radians to degrees. E.g.,

    =DEGREES(ASIN(1))


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "David" <[email protected]> wrote in message
    news:[email protected]...
    > How do I change setting for trigonomic functions, radians -
    > degrees.
    > I am making a table with many different trig functions, the
    > answers are
    > currently in radians, I need degrees.
    > Using Excel 2003.
    > Thanks.




  3. #3
    david
    Guest

    Re: Change radians - degrees setting

    OK, thanks for replying.

    David.


    "Chip Pearson" wrote:

    > All of Excel's trig functions use radians, not degrees, and there
    > is no way to change that. You can use the DEGREES function to
    > convert radians to degrees. E.g.,
    >
    > =DEGREES(ASIN(1))
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > "David" <[email protected]> wrote in message
    > news:[email protected]...
    > > How do I change setting for trigonomic functions, radians -
    > > degrees.
    > > I am making a table with many different trig functions, the
    > > answers are
    > > currently in radians, I need degrees.
    > > Using Excel 2003.
    > > Thanks.

    >
    >
    >


  4. #4
    Chip Pearson
    Guest

    Re: Change radians - degrees setting

    I should have added that you can use the RADIANS function to
    convert radians to degrees. E.g.,

    =SIN(RADIANS(45))


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com




    "Chip Pearson" <[email protected]> wrote in message
    news:uwVSA%[email protected]...
    > All of Excel's trig functions use radians, not degrees, and
    > there is no way to change that. You can use the DEGREES
    > function to convert radians to degrees. E.g.,
    >
    > =DEGREES(ASIN(1))
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > "David" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I change setting for trigonomic functions, radians -
    >> degrees.
    >> I am making a table with many different trig functions, the
    >> answers are
    >> currently in radians, I need degrees.
    >> Using Excel 2003.
    >> Thanks.

    >
    >




  5. #5
    Fredrik Wahlgren
    Guest

    Re: Change radians - degrees setting


    "David" <[email protected]> wrote in message
    news:[email protected]...
    > How do I change setting for trigonomic functions, radians - degrees.
    > I am making a table with many different trig functions, the answers are
    > currently in radians, I need degrees.
    > Using Excel 2003.
    > Thanks.
    >


    I think the best way around this would be to create user defined functions
    like DSIN, DCOS, DTAN that internally converts from degrees to radians.

    /Fredrik




  6. #6
    david
    Guest

    Re: Change radians - degrees setting

    Thanks for the replies - I have added some hidden columns with radian /
    degrees conversion.

    "Fredrik Wahlgren" wrote:

    >
    > "David" <[email protected]> wrote in message
    > news:[email protected]...
    > > How do I change setting for trigonomic functions, radians - degrees.
    > > I am making a table with many different trig functions, the answers are
    > > currently in radians, I need degrees.
    > > Using Excel 2003.
    > > Thanks.
    > >

    >
    > I think the best way around this would be to create user defined functions
    > like DSIN, DCOS, DTAN that internally converts from degrees to radians.
    >
    > /Fredrik
    >
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1