+ Reply to Thread
Results 1 to 3 of 3

SIN function

  1. #1
    Registered User
    Join Date
    04-15-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    11

    SIN function

    I have a formula that goes like this;

    Fhk = Fh0k / K90 * sin^2 alpha + cos^2 alpha

    At this point in time alpha is 90 degrees.

    Using my calculator (with degrees setting) i get sin 90 = 1

    However in excel even typing into a separate cell =sin(90) i get 0.8939

    This result is in radians, but i dont want it in radians, i only want it in degrees.

    Is this an excel setting or do i need to specify in the formula that i want a result in degrees??

    Thanks

    Tom

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: SIN function

    Not my area I'm afraid but from:

    http://phoenix.phys.clemson.edu/tuto...xcel/trig.html

    I suspect:

    =SIN(RADIANS(90))

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: SIN function

    The SIN function expects the angle in radians.

    You can use the DEGREES and RADIAN function to convert

    In fact the help on the function say

    Returns the sine of the given angle.

    Syntax

    SIN(number)

    Number is the angle in radians for which you want the sine.

    Remark

    If your argument is in degrees, multiply it by PI()/180 or use the RADIANS function to convert it to radians.
    Cheers
    Andy
    www.andypope.info

+ 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