ASIN(number)

Returns the arc-sine of a number.

numberThe number you want the arcsine of.

* The arc-sine (or inverse sine function) of an angle is the inverse of the SIN function.
* The "number" is the sine of an angle in radians.
* If "number" is not numeric, then #VALUE! is returned.
* If "number" > 1, then #NUM! is returned. Example 8.
* If "number" < -1, then #NUM! is returned. Example 9.
* The angle returned is in radians between -PI/2 and PI/2.
* If your argument is in degrees, multiply by PI/180 to convert it to radians
* If you want to convert the result from radians to degrees, multiply it by 180/PI.
* You can use the DEGREES function to convert from radians to degrees.
* For a working example refer to the Trigonometry page.
* For the Microsoft documentation refer to support.office.com.

 A
1=ASIN(0.5) = 0.524
2=ASIN(1) = 1.571
3=ASIN(-1) = -1.571
4=ASIN(SIN(1)) = 1
5=DEGREES(ASIN(0.5)) = 30
6=DEGREES(ASIN(-1)) = -90
7=ASIN(-0.5)*180/PI() = -30
8=ASIN(1.01) = #NUM!
9=ASIN(-1.01) = #NUM!
10=ASIN(6) = #NUM!
11=ASIN("some text") = #VALUE!

1 - What is the arc-sine of 0.5 radians.
2 - What is the arc-sine of 1 radian.
5 - What is the arc-since of 0.5 radians in degrees.


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited