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 |
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 |
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