Returns the sine of an angle given in radians. Essential for trigonometry, wave analysis, engineering calculations, and periodic function modeling. Sine values range from -1 to 1.
Master the fundamentals of Excel SIN function
The SIN function returns the sine of an angle given in radians. Sine is one of the fundamental trigonometric functions, representing the y-coordinate on the unit circle. SIN returns values between -1 and 1 and creates a periodic wave pattern. Essential for trigonometry, wave analysis (sine waves, sound, light), engineering calculations, and modeling periodic phenomena.
Input angle must be in radians
Output is always between -1 and 1
Repeats every 2π radians (360°)
sin(0°)=0, sin(30°)=0.5, sin(90°)=1, sin(180°)=0
Function-specific parameters
Function-specific return type
Solve triangle problems and angle calculations
Model periodic waves and oscillations
Calculate forces, vectors, and rotations
Perform scientific and mathematical analysis
Exact matching required
Returns numeric position
Handles missing text gracefully
=SIN(number)The angle in radians for which you want the sine. If angle is in degrees, use RADIANS() to convert first.
The sine of the angle (between -1 and 1)
Description: Returns the sine of an angle given in radians
Calculate sine of angle
Returns 0 because sin(0°) = 0. SIN(0) = sin(0 radians) = sin(0°) = 0.
Use SIN function in VBA
' Basic SIN in VBA
Range("C1").Value = Application.WorksheetFunction.Sin(Application.WorksheetFunction.Radians(30))
' Returns: 0.5
' Calculate sine of angle in degrees
Sub CalculateSine()
Dim angleDegrees As Double
angleDegrees = Range("A1").Value
Dim angleRadians As Double
Dim sine As Double
angleRadians = Application.WorksheetFunction.Radians(angleDegrees)
sine = Application.WorksheetFunction.Sin(angleRadians)
Range("B1").Value = sine
End Sub
' Generate sine wave
Sub GenerateSineWave()
Dim i As Integer
For i = 0 To 360 Step 10
Dim angleRadians As Double
Dim sine As Double
angleRadians = Application.WorksheetFunction.Radians(i)
sine = Application.WorksheetFunction.Sin(angleRadians)
Range("A" & (i / 10 + 1)).Value = i
Range("B" & (i / 10 + 1)).Value = sine
Next i
End Sub
' Calculate opposite side in triangle
Sub TriangleOpposite()
Dim angleDegrees As Double, hypotenuse As Double
angleDegrees = Range("A1").Value
hypotenuse = Range("B1").Value
Dim opposite As Double
opposite = Application.WorksheetFunction.Sin( _
Application.WorksheetFunction.Radians(angleDegrees)) * hypotenuse
Range("C1").Value = opposite
End SubCalculate opposite side in right triangle
Generate sine wave pattern
Calculate vertical component of vector
Model periodic phenomena
SIN returns unexpected value with degrees
=SIN(RADIANS(30)) not =SIN(30)Solution: SIN requires radians, not degrees. Always convert: SIN(RADIANS(degrees)). SIN(30) is not sin(30°), it's sin(30 radians).
SIN returns unexpected results
Always use SIN(RADIANS(angle)) for degreesSolution: Check if angle is in radians. Use RADIANS() for degrees. Verify: SIN(RADIANS(0)) = 0, SIN(RADIANS(90)) = 1.
SIN results have unexpected precision
=ROUND(SIN(RADIANS(30)), 4)Solution: Use ROUND for display: ROUND(SIN(RADIANS(angle)), digits). SIN can return values very close to 0 that may display as scientific notation.
Uncertainty about SIN vs ASIN relationship
SIN(ASIN(0.5)) = 0.5Solution: SIN is inverse of ASIN: SIN(ASIN(value)) = value (if value is between -1 and 1). ASIN(SIN(angle)) = angle (in radians).