ExcelBanter - how do I use "inv sine" in a worksheet

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

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

- - how do I use "inv sine" in a worksheet (https://www.excelbanter.com/excel-worksheet-functions/6585-how-do-i-use-%22inv-sine%22-worksheet.html)

Elimits

how do I use "inv sine" in a worksheet

I need to inv sine a value in a spreadsheet, I have already converted deg to
rads. I have tried "Asin" but this does not work

Bernie Deitrick

Elimits,

You convert to degrees AFTER you do the ASIN, since ASIN only take values
from -1 to 1:

=ASIN(-0.5)*180/PI()

or, if the value is in cell A1
=ASIN(A1)*180/PI()

HTH,
Bernie
MS Excel MVP

"Elimits" wrote in message
...
I need to inv sine a value in a spreadsheet, I have already converted deg
to
rads. I have tried "Asin" but this does not work

All times are GMT +1. The time now is 10:13 PM.