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
Just use the DEGREES function. E.g.,
=DEGREES(PI()/2)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;HELP ME PLEASE!!!!!quot; lt;HELP ME
gt; wrote in message
...
gt;I am trying to obtain the measure of an angle in degree format
gt;in EXCEL. I
gt; found how to convert the angle using another funnction but that
gt; doesn't give
gt; me the right answer for some reason. It gives me the right
gt; answer in radian
gt; format but when I try to convert it to degrees it gives me a
gt; off the wall
gt; answer. I know it is wrong because it doesn't not work out the
gt; same way on
gt; my calculator when it is in degree format.
gt;
gt; Thanks for you help.
gt;
gt; -Matt
Assuming A1 is in radians,
=DEGREES(A1)
Will return the corresponding degree
--
Regards,
Davequot;HELP ME PLEASE!!!!!quot; wrote:
gt; I am trying to obtain the measure of an angle in degree format in EXCEL. I
gt; found how to convert the angle using another funnction but that doesn't give
gt; me the right answer for some reason. It gives me the right answer in radian
gt; format but when I try to convert it to degrees it gives me a off the wall
gt; answer. I know it is wrong because it doesn't not work out the same way on
gt; my calculator when it is in degree format.
gt;
gt; Thanks for you help.
gt;
gt; -Matt
- Jun 22 Fri 2007 20:38
How to do I convert angles from radians to degrees in Excel?
close
全站熱搜
留言列表
發表留言