Changing Radians to Degrees

[Leonard]

Hi,
I am using Excell 2007, and I prefer to use degrees rather than radians.
When I calculate Sin (angle), excel identifies the angle as in Radians. How
can I make "degrees" to be my default unit of angles?
Leo

 

[Ron Rosenfeld]

Hi,
I am using Excell 2007, and I prefer to use degrees rather than radians.
When I calculate Sin (angle), excel identifies the angle as in Radians. How
can I make "degrees" to be my default unit of angles?
Leo

As far as I know, that is not an available option in Excel.
--ron

 

[Niek Otten]

Not possible

Get used to
=SIN(RADIANS(Angle))
instead

 

[Niek Otten]

But of course you could make your own Sin function:

Function Sinus(a As Double) As Double
Sinus = Sin(WorksheetFunction.Radians(a))
End Function

ALT+F11 gets you to the VB Editor
Insert>Module
Paste the code above
ALT+F11 brings you back in Excel
You can now use the Sinus() function with degrees as an argument

 

[Leonard akwilapo]

Thanks Niek.
Leon.

But of course you could make your own Sin function:

Function Sinus(a As Double) As Double
Sinus = Sin(WorksheetFunction.Radians(a))
End Function

ALT+F11 gets you to the VB Editor
Insert>Module
Paste the code above
ALT+F11 brings you back in Excel
You can now use the Sinus() function with degrees as an argument

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[herochenna]

Visit www.ExcelGoodies.Com