Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > ASIN

 

ASIN(number)

 
 Returns the arcsine of a number in radians.

 numberThe number you want the arcsine of.

 REMARKS
 
  • The arcsine of an angle is the inverse of the SIN() function.
     
  • The "number" is the angle in radians.
     
  • If "number" is not numeric, then #VALUE! is returned.
     
  • If "number" > 1, then #NUM! is returned.
     
  • If "number" < -1, then #NUM! is returned.
     
  • The returned angle is given 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.

     EXAMPLES
     
     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(-1)) = -90
    6=ASIN(-0.5)*180/PI() = -30
    7=ASIN(ASINH(0.5)) = 0.502
    8=ASIN(1.01) = #NUM!
    9=ASIN(-1.01) = #NUM!
    10=ASIN(6) = #NUM!
    11=ASIN("some text") = #VALUE!
     

     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top