Changing Radians to Degrees

  • Thread starter Thread starter Leonard
  • Start date Start date
L

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
 
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
Click to expand...

As far as I know, that is not an available option in Excel.
--ron
 
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
 
Thanks Niek.
Leon.



Niek Otten said:
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
Click to expand...
 
Back
Top