# How to Use Excel ASIN Function?

We all know that Microsoft Excel is one of the most powerful tools for performing various kinds of mathematical calculations. Because it offers built-in formulas and functions. It also provides many advanced features like VBA and Macros to automate any operations in the spreadsheet. If you want to get the ASIN values of some numbers, then we can use the ASIN Function.

In this article, we are going to see how to use the Excel ASIN Function in Office 365 with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Explanation of ASIN Function

• It is one of the built-in functions in Microsoft Excel.
• This function returns the inverse sine of a given number in radians.
• The inputs to the ASIN function must be between -1 and 1.
• For example, ASIN(0.25) returns the output value of 0.253

## Syntax

• Here, you will see the syntax of the ASIN function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=ASIN(number)

Argument Description

Number – The input value to get the inverse sine number. It should be between -1 and 1.

Note:
1) If the argument is a non-numeric value and then it will return #VALUE! Error.
2) If the input number is greater than 1 or less than -1, it will return the #NUM! Error.

## Examples

Here, we come up with some examples to know how to use the ASIN function in the Excel spreadsheet.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For instance, we have given the input values in Column B and we will get the corresponding inverse sine values in Column D.
• Then, you have to enter the formula in the cell as shown below to get the result.
• After entering the formula, you need to click the to get the output, as shown below. You can drag down the cell to fill the remaining cells.

## Input that Causes Error

• If the argument is a non-numeric value and then it will return #VALUE! Error.
• In case, the input number is greater than 1 or less than -1, it will return the #NUM! Error.