The Excel SIN Function

Related Functions:
COS Function
TAN Function

Sine of an Angle

For the simple right-angled triangle below, the sine of the angle θ, is the ratio of the opposite side, o, to the hypotenuse, h.

Right-Angled Triangle

i.e. for the triangle above,

Sine Equation

The trig. ratios are discussed further on the Wikipedia Trigonometric Ratios Page

Basic Description

The Excel SIN function calculates the sine of a given angle (which is supplied in radians).

The format of the function is :

SIN( number )

Where the number argument is the angle, in radians, that you want to calculate the sine of.

Converting from Radians to Degrees

If your angle is in degrees, you will need to convert it into radians before supplying it to the cos function.

The easiest way to do this is to use the Excel Radians function:

=RADIANS( degrees )

Examples of this are given below.

Sin Function Examples

Column B of the spreadsheet below, shows examples of the Excel Sin Function, used to calculate the sine of different angles, which are in either degrees or radians.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

  A B
1 0.785398163 Radians =SIN( 0.785398163 )
2 π/6 Radians =SIN( PI()/6 )
3 60 Degrees =SIN( RADIANS( 60 ) )
4 -30 Degrees =SIN( RADIANS( -30 ) )
  A B
1 0.785398163 Radians 0.707106781
2 π/6 Radians 0.5
3 60 Degrees 0.866025404
4 -30 Degrees -0.5

Further information and examples of the Excel Sin function can be found on the Microsoft Office website.

Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2015