how do i enter angles in exel?
 

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

how do i enter angles in exel?
 

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"dougsan" wrote:

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

how do i enter angles in exel?
 

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

how do i enter angles in exel?
 

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
"Shane Devenshire" wrote:

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"dougsan" wrote:

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

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

how do i enter angles in exel?
 

There are several ways to measure the size of an angle. One way is to use
units of degrees. (Radian measure is another way.)

In a complete circle there are three hundred and sixty degrees.

In a full circle there are 360 degrees.
Each degree is split up into 60 parts, each part being 1/60 of a degree.
These parts are called minutes.
Each minute is split up into 60 parts, each part being 1/60 of a minute.
These parts are called seconds.

thus,
1 degree is equal to 60 minutes
1 minute is equal to 60 seconds
eg
use this formula for converting degree to minutes
40 degree 20 min 50 sec = 40 + (20/60) + (50/3600) degrees

1 minute = 1/60 degree



Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1

how do i enter angles in exel?
 

Thanks Chris
I am now on the right track
dougsan

"Chris_Bode via OfficeKB.com" wrote:

There are several ways to measure the size of an angle. One way is to use
units of degrees. (Radian measure is another way.)

In a complete circle there are three hundred and sixty degrees.

In a full circle there are 360 degrees.
Each degree is split up into 60 parts, each part being 1/60 of a degree.
These parts are called minutes.
Each minute is split up into 60 parts, each part being 1/60 of a minute.
These parts are called seconds.

thus,
1 degree is equal to 60 minutes
1 minute is equal to 60 seconds
eg
use this formula for converting degree to minutes
40 degree 20 min 50 sec = 40 + (20/60) + (50/3600) degrees

1 minute = 1/60 degree



Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1

how do i enter angles in exel?
 

Thanks Chris,

Your post was awesome, I got my way.

Puruzweb




Chris_Bode wrote:
There are several ways to measure the size of an angle. One way is to use
units of degrees. (Radian measure is another way.)

In a complete circle there are three hundred and sixty degrees.

In a full circle there are 360 degrees.
Each degree is split up into 60 parts, each part being 1/60 of a degree.
These parts are called minutes.
Each minute is split up into 60 parts, each part being 1/60 of a minute.
These parts are called seconds.

thus,
1 degree is equal to 60 minutes
1 minute is equal to 60 seconds
eg
use this formula for converting degree to minutes
40 degree 20 min 50 sec = 40 + (20/60) + (50/3600) degrees

1 minute = 1/60 degree

Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com