ASIN()

Syntax. ASIN(number)

Definition. Use the ASIN() function to calculate the adjacent angle based on the sine (see Figure 16-5).

Argument

  • number (required) The sine of the angle; must be between –1 and 1

Background. This function calculates the angle from a sine value. The result is a radian measure and has to be converted into degrees with the DEGREES() function or by multiplying the result by 180/PI().

Because each angle occurs two times in a full circle, the value range for the arcsine is restricted.

  • If the angle is calculated as a radian measure, the value range spans –π/2 to π/2.

  • If the angle is calculated in degrees, the value range spans –90° to 90°.

The values of the arcsine in a coordinate plane look like this:

Figure 16-5. The ASIN() function. ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.