SIN function
SIN returns the sine of an angle, a number from -1 to 1. The angle must be in radians, so convert degrees with RADIANS first.
Example
Read it as a sentence: take pi, divide it by 2, then find the sine, which gives 1.
A
B
C
D
1
1
2
3
Syntax
SIN(number)
-
number(required) - An angle in radians.
Returns: The sine, from -1 to 1.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SIN(0.5) | 0.479425539 | Positive |
=SIN(0) | 0 | Zero |
=SIN(-0.5) | -0.479425539 | Negative |
=SIN(2) | 0.909297427 | Larger value |
=SIN("0.5") | 0.479425539 | Text number "0.5" |
=SIN(TRUE) | 0.841470985 | TRUE |
=SIN("abc") | #VALUE! | Non-numeric text |
=SIN(2^27+1) | #NUM! | Beyond 2^27 |
Watch out for
- Degrees must be converted with RADIANS.
Where it works
- Excel
- SIN is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .