close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()