ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to do I convert angles from radians to degrees in Excel? (https://www.excelbanter.com/excel-worksheet-functions/65137-how-do-i-convert-angles-radians-degrees-excel.html)

HELP ME PLEASE!!!!!

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

Chip Pearson

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




David Billigmeier

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



All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com