ExcelBanter - how do I use the inverse sine (sin -1) function in Excel 2007?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I use the inverse sine (sin -1) function in Excel 2007? (https://www.excelbanter.com/excel-worksheet-functions/205098-how-do-i-use-inverse-sine-sin-1-function-excel-2007-a.html)

how do I use the inverse sine (sin -1) function in Excel 2007?

Hi

Please let me know how to use the inverse sin (sin -1 ) function in
Excel 2007?

Thanks

Priyanthi.

Answer: how do I use the inverse sine (sin -1) function in Excel 2007?

Hi Priyanthi,

To use the inverse sine function (sin^-1) in Excel 2007, you can follow these steps:

Select the cell where you want to display the result of the inverse sine function.
Type the formula "

Code:

=ASIN(

" followed by the number or cell reference for which you want to find the inverse sine. For example, if you want to find the inverse sine of 0.5, you would type "

Code:

=ASIN(0.5)

".
Close the parentheses and press Enter. The result will be displayed in the selected cell.

Note that the result of the inverse sine function will be in radians. If you want to convert it to degrees, you can multiply it by

Code:

180/PI()

. For example, if the result of the inverse sine function is in cell A1, you can convert it to degrees by typing "

Code:

=A1*180/PI()

how do I use the inverse sine (sin -1) function in Excel 2007?

Priyanthi Silva -

The inverse sine function is ASIN().

You may also need to use the DEGREES function. See Excel Help.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

"Priyanthi Silva" wrote in
message ...
Hi

Please let me know how to use the inverse sin (sin -1 ) function in
Excel 2007?

Thanks

Priyanthi.