Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Asin-Function

Search this site: Custom Search

Arcsine The Arcsine is the inverse of the sine. Therefore, for the simple right-angled triangle below, the arcsine of the opposite side, o, divided by the hypotenuse, h, is equal to the angle θ. i.e. for the triangle above, The Inverse trig. functions are discussed further on the Wikipedia Inverse Trigonometric Functions Page

Basic Description

The Excel ASIN function calculates the arcsine (ie. the inverse sine) of a given number, and returns an angle, in radians, between -π/2 and π/2.

The format of the function is :

Where the Number argument is the value, between -1 and +1, for which you want to calculate the arcsine.

Example

Column A of the spreadsheet below, shows examples of the Excel Asin Function, used to calculate the arcsine of different values. In the example in cell A4, the result is converted from radians, into degrees.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Further information and examples of the Excel Asin function can be found on the Microsoft Office website.

Common Error

If you get the #NUM! error from your Excel Asin function this is likely to be because the supplied Number argument is not in the range -1 to +1.