Excel functions / Math
ASIN function
The angle, in radians, whose sine is the number. Wrap it in DEGREES() for degrees.
Syntax
=ASIN(number)
Arguments
number: The sine, from -1 to 1.
When to use it
ASIN gives the angle, in radians, whose sine is a number from -1 to 1. Wrap it in DEGREES to read the angle in degrees.
Examples
The angle whose sine is 0.5
A B C 1 Sine 2 0.5 30 In C2:
=DEGREES(ASIN(A2))→ 30The angle of a ramp that rises 1 m over 4 m of its length
A B C D 1 Rise Length 2 1 4 14.5 In D2:
=DEGREES(ASIN(A2/B2))→ 14.5
Common mistakes
- Outside -1 to 1. A sine can only be from -1 to 1: anything else is #NUM!.
ASIN 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: ARCSIN
- Danish: ARCSIN
- Dutch: BOOGSIN
- Finnish: ASIN
- French: ASIN
- German: ARCSIN
- Hungarian: ARCSIN
- Italian: ARCSEN
- Norwegian: ARCSIN
- Polish: ASIN
- Portuguese (Brazil): ASEN
- Portuguese (Portugal): ASEN
- Russian: ASIN
- Spanish: ASENO
- Swedish: ARCSIN
- Turkish: ASİN