ASIN

ASIN(number)

Returns the angle in radians for a given sine ratio.

numberThe sine ratio.

REMARKS
* For an illustrated example refer to the Trigonometric Functions page.
* This function always returns an angle between -PI/2 and PI/2.
* If "number" is not numeric, then #VALUE! is returned.
* If "number" > 1, then #NUM! is returned.
* If "number" < -1, then #NUM! is returned.
* To convert a number from degress to radians, multiply it by PI/180.
* To convert a number from radians to degrees, multiply it by 180/PI.
* The inverse of this function is the SIN function.
* You can use the SIN function to return the sine of a number.
* You can use the ACOS function to return the arc-cosine.
* You can use the ACOT function to return the the arc-cotangent.
* You can use the ATAN function to return the arc-tangent.
* You can use the RADIANS function to convert from degrees to radians.
* You can use the DEGREES function to convert from radians to degrees or multiply it by 180/PI.
* For the Microsoft documentation refer to support.microsoft.com

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

1 - What is the angle in radians for a sine ratio of -1.
2 - What is the angle in radians for a sine ratio of -0.5
3 - What is the angle in radians for a sine ratio of 0
4 - What is the angle in radians for a sine ratio of 0.5
5 - What is the angle in radians for a sine ratio of 1
6 - When number is >1
7 - What is the angle in degrees for a sine ratio of 0.5
8 - What is the angle in degrees for a sine ratio of 0.5
9 - What is the inverse of sine.
10 - When number is not numeric

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top