Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Changing Radians to Degrees

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Data read  
Author Message
Leonard

External


Since: Nov 15, 2009
Posts: 1



(Msg. 1) Posted: Sun Nov 15, 2009 5:25 am
Post subject: Changing Radians to Degrees
Archived from groups: microsoft>public>excel (more info?)

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

 >> Stay informed about: Changing Radians to Degrees 
Back to top
Login to vote
Ron Rosenfeld

External


Since: Jan 21, 2009
Posts: 4



(Msg. 2) Posted: Sun Nov 15, 2009 6:12 am
Post subject: Re: Changing Radians to Degrees
Archived from groups: per prev. post (more info?)

On Sun, 15 Nov 2009 12:34:13 +0300, "Leonard" wrote:

>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

 >> Stay informed about: Changing Radians to Degrees 
Back to top
Login to vote
Niek Otten

External


Since: Dec 9, 2008
Posts: 4



(Msg. 3) Posted: Sun Nov 15, 2009 9:25 am
Post subject: Re: Changing Radians to Degrees
Archived from groups: per prev. post (more info?)

Not possible

Get used to
=SIN(RADIANS(Angle))
instead
 >> Stay informed about: Changing Radians to Degrees 
Back to top
Login to vote
Niek Otten

External


Since: Dec 9, 2008
Posts: 4



(Msg. 4) Posted: Sun Nov 15, 2009 9:25 am
Post subject: Re: Changing Radians to Degrees
Archived from groups: per prev. post (more info?)

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
 >> Stay informed about: Changing Radians to Degrees 
Back to top
Login to vote
Leonard akwilapo

External


Since: Nov 15, 2009
Posts: 1



(Msg. 5) Posted: Sun Nov 15, 2009 12:25 pm
Post subject: Re: Changing Radians to Degrees
Archived from groups: per prev. post (more info?)

Thanks Niek.
Leon.



"Niek Otten" wrote in message

> 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
>
> "Leonard" wrote in message

>> 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
>
 >> Stay informed about: Changing Radians to Degrees 
Back to top
Login to vote
herochenna

External


Since: Dec 16, 2009
Posts: 1



(Msg. 6) Posted: Wed Dec 16, 2009 8:58 am
Post subject: Re: Changing Radians to Degrees
Archived from groups: per prev. post (more info?)

Visit [URL="http://www.ExcelGoodies.Com"]www.ExcelGoodies.Com[/URL]

---
frmsrcurl: [URL="http://msgroups.net/microsoft.public.excel/Changing-Radians-to-Degrees"]http://msgroups.net/microsoft.public.excel/Changing-Radians-to-Degrees[/URL]
 >> Stay informed about: Changing Radians to Degrees 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Format changing - I have some issues with an Excel file that I will try to explain. The file contains worksheets; 12 monthly progress reports, 1 data sheet, 1 information sheet, 12 comment sheets (to show progress against objectives set in the report). It is stored in....

Changing pivot datasource by formulas? - Hi guys :) I not quite sure if there is any solution to this. My last chance is to cry for help in this room of qualifications... (aaaargh!!) This monthly "cut-off" report of mine is based on one chosen dataset (the last monthly) - placed in ...

How to Past cells with formulas not using "$" without chan.. - Hello, I would like to copy / past a large amount of cells in which "$" has not been used in formules. Problem : referenced are changed (because "$" is not there). Example in A1 : "=B1+C1" if I copy A1 to A50 : the con...

INDEX MATCH HELL ooops.. I mean HELP! - I know (or at least I think I do) that I can do this with INDEX MATCH. Here is what I want to do. I want to place this formula in cell C4 of Sheet 1. What I want this formula to do is to match the value of B2 of Sheet 1 with a list that is in Sheet 2...

Notation Bugs - Did anybody notice that Excel handles math notations (symbols) in an incorrect way? Try this: write -2 in cell A1. Write =1-A1^2 in a different cell. Write =-A1^2+1 in another cell. The two expressions are equivalent, shouldn't they? Well, the former..
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]