how do i enter angles in exel?

[dougsan]

how do i work with Degrees and minutes in angles and enter onto excel

 

[Shane Devenshire]

Hi,

Excel has a DEGREES function and a REDIANS function and PI(). take a look
at the help system for these functions.

You didn't tell us what you want to do with them.

 

[Bernard Liengme]

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

 

[dougsan]

Thank you Shane Devenshire.
I am trying to set up a sheet to calculate navigation direction headings,
i.e. calculate compass headings from true headings, magnetic variation, and
deviation, ect

 

[dougsan]

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

 

[dougsan]

Thanks Chris
I am now on the right track
dougsan