Skip to main content

Excel ASIN function

doc asin function 1


Description

The ASIN function calculates the arcsine of a give number, and returns an angle which is in radians between -π/2 and π/2.

Syntax and arguments

Formula syntax

=ASIN(number)

Arguments

  • Number: Required. The ration of the opposite side over the hypotenuse of a right triangle which must be from -1 to 1.

doc asin function 2

Return Value

The ASIN function returns an angle of triangle in radian.

Usage and Examples

Take 0.2 for instance.

To return an angle in radian

Formula

=ASIN(0.2)

Return: 0.20136

To return an angle in degrees

Formula

=ASIN(0.2)*180/PI()
or
=DEGREES(ASIN(0.2))

Return: 11.537

Download Sample File

doc sample file


Relative Functions:


The Best Office Productivity Tools

Kutools for Excel - Helps You To Stand Out From Crowd

Popular Features: Find/Highlight/Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ...
Super VLookup: Multiple Criteria  |  Multiple Value   |  Across Multi-Sheets  |  Fuzzy Lookup...
Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List...
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Unhide Columns  |  Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager  |  Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Cells ...)  |  ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

Supports Office/Excel 2007-2021 and 365   |   Available in 44 Languages   |   Easy to Uninstall Completely

Full-Featured 30-Day Free Trial  |  60-Day Unconditional Money-Back GuaranteeRead MoreDownload

Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
Full-Featured 30-Day Free Trial  |  60-Day Unconditional Money-Back GuaranteeRead More Download
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations