View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dougsan dougsan is offline
external usenet poster
 
Posts: 9
Default how do i enter angles in exel?

Thank you, Bernard Liengme,
i will see how i go
dougsan

"Bernard Liengme" wrote:

Chip has some stuff about degrees and minutes at
http://www.cpearson.com/excel/LatLong.aspx

To reinforce what Shane told you:
A1 holds value 60 (degrees) and you want SIN of that angle; use
=SIN(RADIANS(A1))
which first converts degrees to radians then finds the Sine

B1 holds number like .5678 and you want the Arcsine in Degrees; use
=DEGREES(ASIN(B1))

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dougsan" wrote in message
...
how do i work with Degrees and minutes in angles and enter onto excel