Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HELP ME PLEASE!!!!!
 
Posts: n/a
Default How to do I convert angles from radians to degrees in Excel?

I am trying to obtain the measure of an angle in degree format in EXCEL. I
found how to convert the angle using another funnction but that doesn't give
me the right answer for some reason. It gives me the right answer in radian
format but when I try to convert it to degrees it gives me a off the wall
answer. I know it is wrong because it doesn't not work out the same way on
my calculator when it is in degree format.

Thanks for you help.

-Matt
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default How to do I convert angles from radians to degrees in Excel?

Just use the DEGREES function. E.g.,

=DEGREES(PI()/2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"HELP ME PLEASE!!!!!" <HELP ME
wrote in message
...
I am trying to obtain the measure of an angle in degree format
in EXCEL. I
found how to convert the angle using another funnction but that
doesn't give
me the right answer for some reason. It gives me the right
answer in radian
format but when I try to convert it to degrees it gives me a
off the wall
answer. I know it is wrong because it doesn't not work out the
same way on
my calculator when it is in degree format.

Thanks for you help.

-Matt



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default How to do I convert angles from radians to degrees in Excel?

Assuming A1 is in radians,

=DEGREES(A1)

Will return the corresponding degree
--
Regards,
Dave


"HELP ME PLEASE!!!!!" wrote:

I am trying to obtain the measure of an angle in degree format in EXCEL. I
found how to convert the angle using another funnction but that doesn't give
me the right answer for some reason. It gives me the right answer in radian
format but when I try to convert it to degrees it gives me a off the wall
answer. I know it is wrong because it doesn't not work out the same way on
my calculator when it is in degree format.

Thanks for you help.

-Matt

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert excel file to executable file sparx Excel Discussion (Misc queries) 1 September 24th 05 01:36 PM
How can I convert an Excel file to an Adobe .pdf file by using Ex. pammoore2000 Excel Discussion (Misc queries) 5 March 15th 05 03:51 AM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM
How to convert Word table with paragraphing to Excel? phoenix Excel Discussion (Misc queries) 6 February 19th 05 12:01 AM
How to convert the table in word to excel sheet? Santhosh Excel Discussion (Misc queries) 1 December 2nd 04 10:15 AM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"