ASIN function
ASIN takes a sine value and returns the angle that has it, in radians from -PI/2 to PI/2. Inputs outside -1 to 1 give a #NUM! error.
Example
Read it as a sentence: find the angle, in radians, whose sine is 1.
A
B
C
D
1
1.570796327
2
3
Syntax
ASIN(number)
-
number(required) - A sine value between -1 and 1.
Returns: The angle in radians, from -PI/2 to PI/2.
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 |
|---|---|---|
=ASIN(0.5) | 0.523598776 | Positive |
=ASIN(0) | 0 | Zero |
=ASIN(-0.5) | -0.523598776 | Negative |
=ASIN("0.5") | 0.523598776 | Text number "0.5" |
=ASIN(TRUE) | 1.570796327 | TRUE |
=ASIN({0.1,0.2}) | 0.100167421 | Array constant spills |
=ASIN(2) | #NUM! | Larger value |
=ASIN("abc") | #VALUE! | Non-numeric text |
Watch out for
- Inputs outside -1 to 1 give #NUM!.
Where it works
- Excel
- ASIN 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 .