Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Sine to Angle (Excel XP)

    <img src=/S/heavy.gif border=0 alt=heavy width=40 height=34> I use the following formula to derive the Sine of an angle that I include inside the ().

    =SIN(RADIANS(45))

    Which returns a value of 0.7071 as the Sine for an angle of 45 degrees.

    If I change the 45 to 30, the Sine value is 0.50.

    Now I want to write a formula to derive the angle when I know the Sine. I would like to enter the Sine in a cell and then have the formula reference that cell. I can do it with HLOOKUP, but that
    Bob Wall

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sine to Angle (Excel XP)

    To find the angle (in degrees) with sine 0.5, use the formula

    =DEGREES(ASIN(0.5))

    Of course, you can use a cell reference instead of a literal value:

    =DEGREES(ASIN(A1))

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Re: Sine to Angle (Excel XP)

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> You have no idea how much paper I wasted trying to figure this out, and I never thought about DEGREES. Thank you.
    Bob Wall

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sine to Angle (Excel XP)

    Since you knew about RADIANS(), then if you had gone to Excel's Help for the RADIANS() function and clicked on the "See Also" no the second line, it would have pointed you to the DEGREES() function. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Legare Coleman

Posting Permissions

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