Convert Radian to degree angle for COS function

's Computer Specifications

Hi,

Do you know how I can ask to Excel with a VBA code to find the Cosinus of
the active cell value when the cell value is in Degree?

Thanks
Catherine

's Computer Specifications

MsgBox Cos(ActiveCell.Value * 180 / WorksheetFunction.Pi())

Sam

"catherine" wrote:

> Hi,
>
> Do you know how I can ask to Excel with a VBA code to find the Cosinus of
> the active cell value when the cell value is in Degree?
>
> Thanks
> Catherine

's Computer Specifications

You can ignore the msgbox bit, I just put it there when I tested the code!

All you need is multiply by 180, divide by pi [worksheetfunction.pi()]

"Sam Wilson" wrote:

> MsgBox Cos(ActiveCell.Value * 180 / WorksheetFunction.Pi())
>
>
> Sam
>
> "catherine" wrote:
>
> > Hi,
> >
> > Do you know how I can ask to Excel with a VBA code to find the Cosinus of
> > the active cell value when the cell value is in Degree?
> >
> > Thanks
> > Catherine

's Computer Specifications

Your title says convert radians to degrees, but your post says degreed to
radians!

Degrees --> Radians:
activecell.value * worksheetfunction.pi() / 180

Radians --> Degrees:
activecell.value * 180 /worksheetfunction.pi()

"Sam Wilson" wrote:

> MsgBox Cos(ActiveCell.Value * 180 / WorksheetFunction.Pi())
>
>
> Sam
>
> "catherine" wrote:
>
> > Hi,
> >
> > Do you know how I can ask to Excel with a VBA code to find the Cosinus of
> > the active cell value when the cell value is in Degree?
> >
> > Thanks
> > Catherine

's Computer Specifications

"Sam Wilson" wrote in message

> Your title says convert radians to degrees, but your post says degreed to
> radians!

:-)

Presumably the OP wants to convert degrees to radians for use in Excel's
trig functions

Note Excel also has worksheet functions Radians(deg) and Degrees(rad)

Regards,
Peter T

's Computer Specifications

I felt it was important to share the maths behind it, and to stage the answer
in three parts.

"Peter T" wrote:

> "Sam Wilson" wrote in message
>
> > Your title says convert radians to degrees, but your post says degreed to
> > radians!
>
> :-)
>
> Presumably the OP wants to convert degrees to radians for use in Excel's
> trig functions
>
> Note Excel also has worksheet functions Radians(deg) and Degrees(rad)
>
> Regards,
> Peter T
>
>
>
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how make an angle to show in degree, minute,second instead of degree	EXCEL$B!!(BNEWS	Microsoft Excel Programming	4	28th Apr 2008 07:02 AM
degree or angle	=?Utf-8?B?ZWtrZWluZG9oYQ==?=	Microsoft Excel Worksheet Functions	3	29th Jan 2007 01:54 PM
Imputting an angle degree. Degree, minute, second	=?Utf-8?B?R3JhaGFt?=	Microsoft Excel Misc	6	19th Oct 2006 03:07 PM
Imputting an angle degree. Degree, minute, second	=?Utf-8?B?R3JhaGFt?=	Microsoft Excel Worksheet Functions	1	13th Oct 2006 07:58 PM
desktop at a 90 degree angle	D	Microsoft Powerpoint	1	8th Nov 2004 06:02 AM