How to use the Excel SIN function

SIN Excel function is an inbuilt trigonometric function in excel which is used to calculate the sine value of given number or in terms of trigonometry the sine value of a given angle, here the angle is a number in excel and this function takes only a single argument which is the input number provided.

Syntax: =SIN (number)

The SIN function syntax has the following arguments:

  • number – The angle in radians for which you want the sine.

Example: Let’s look at some Excel SIN function examples and explore how to use the SIN function as a worksheet function in Microsoft Excel:

Excel SIN function - How to use the Excel SIN function

Syntax:  =SIN(RADIANS(A2))

Result:

SIN function - How to use the Excel SIN function

Based on the Excel spreadsheet above, the following SIN examples would return:

Syntax: =SIN(RADIANS(A3))
Result: 0.866025404

Syntax: =SIN(RADIANS(A4))
Result: 0.5

Syntax: =SIN(RADIANS(A5))
Result: 0.996194698

Syntax: =SIN(RADIANS(A6))
Result: 1

Syntax: =SIN(RADIANS(A7))
Result: 0.000000000

Syntax: =SIN(PI())
Result: 0.000000000

Syntax: =SIN(PI()/2)
Result: 1.000000000

Syntax: =SIN(30*PI()/180)
Result: 0.500000000

Syntax: =SIN(PI()/6)
Result: 0.500000000

Syntax: =SIN(-PI()/6)
Result: -0.500000000

Syntax: =SIN(-PI()/3)
Result: -0.866025404

Syntax: =SIN(0.85)
Result: 0.751280405

Note:

  • The SIN function returns the sine of an angle provided in radians. In geometric terms, the sine of an angle returns the ratio of a right triangle’s opposite side over its hypotenuse. For example, the sine of PI()/6 radians (30°) returns the ratio 0.5. ( =SIN (PI()/6) returns 0.5).
  • Convert the number as required in Radian or Degree using either RADIANS function or DEGREES function .
  • You can use PI() function to get exact results of SIN function while working with π.
READ:  How to use the Excel MMULT function

Add a Comment

Your email address will not be published. Required fields are marked *