Excel functions / Math
SIN function
The sine of an angle given in radians.
Syntax
=SIN(number)
Arguments
number: The angle, in radians. Wrap degrees in RADIANS().
When to use it
SIN gives the sine of an angle. Like every trigonometric function in Excel it expects the angle in radians, not degrees. For an angle in degrees, wrap it in RADIANS first: =SIN(RADIANS(30)).
COS and TAN work the same way, and ASIN, ACOS and ATAN go back from a ratio to an angle, also in radians.
Examples
The sine of 30 degrees
A B C 1 Degrees 2 30 0.5 In C2:
=SIN(RADIANS(A2))→ 0.5How high a 10 metre ramp rises at 20 degrees
A B C D 1 Length Angle 2 10 20 3.42 In D2:
=A2*SIN(RADIANS(B2))→ 3.42What happens without RADIANS
A B C 1 Degrees 2 30 -0.99 In C2:
=SIN(A2)→ -0.99Excel read 30 as 30 radians, which is nearly five full turns.
Common mistakes
- Degrees. SIN(30) is not 0.5. Convert degrees with RADIANS, or multiply by PI()/180.
- Tiny numbers instead of zero. SIN(PI()) shows something like 1.2E-16 rather than 0, because π cannot be stored exactly. Round the result.
Common questions
How do I use SIN with degrees in Excel?
Convert the angle first: =SIN(RADIANS(A2)), where A2 holds the angle in degrees. Excel's trigonometric functions all work in radians.
SIN in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SIN
- Danish: SIN
- Dutch: SIN
- Finnish: SIN
- French: SIN
- German: SIN
- Hungarian: SIN
- Italian: SEN
- Norwegian: SIN
- Polish: SIN
- Portuguese (Brazil): SEN
- Portuguese (Portugal): SEN
- Russian: SIN
- Spanish: SENO
- Swedish: SIN
- Turkish: SİN
Related functions
- COS: The cosine of an angle given in radians.
- TAN: The tangent of an angle given in radians.
- ASIN: The angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
- RADIANS: Turns degrees into radians, which is what SIN, COS and TAN take.
- DEGREES: Turns radians into degrees.
- PI: The number π (3.14159…).