Home |
Search |
Today's Posts |
#1
|
|||
|
|||
radians
I would like to convert degrees to radians, but Excel displays a decimal
answer. I want tjhe aswer to be in some form of pi (i.e 270 degrees==3π/2) Is there a way to force Excel to display the answer like this? Thanks, mb |
#2
|
|||
|
|||
One way:
B1: =RADIANS(A1)/PI() Format B1 with Format/Cells/Number/Custom ?\π/? In article , "mb" wrote: I would like to convert degrees to radians, but Excel displays a decimal answer. I want tjhe aswer to be in some form of pi (i.e 270 degrees==3π/2) Is there a way to force Excel to display the answer like this? Thanks, mb |
#3
|
|||
|
|||
The best you can do is to convert it to something in terms of PI
if A1=270 B1= RADIANS(A1)/PI() "mb" wrote: I would like to convert degrees to radians, but Excel displays a decimal answer. I want tjhe aswer to be in some form of pi (i.e 270 degrees==3π/2) Is there a way to force Excel to display the answer like this? Thanks, mb |
#4
|
|||
|
|||
I can't seem to get it to work right. I typed in what both of you said and
did return a value with the pi symbol, but the wrong number. "Barb R." wrote: The best you can do is to convert it to something in terms of PI if A1=270 B1= RADIANS(A1)/PI() |
#5
|
|||
|
|||
It might save some guessing if you said what the original number(s) and
the "wrong" number(s) were. For me: A1: 270 B1: =RADIANS(A1)/PI() === 3π/2 when formatted as ?\π/? In article , "mb" wrote: I can't seem to get it to work right. I typed in what both of you said and did return a value with the pi symbol, but the wrong number. |
#6
|
|||
|
|||
Sorry about that. I want to go from 1 to 360. For 1 thru 18 degrees it
returns... oÏ/1 1 degree is pi/180 "JE McGimpsey" wrote: It might save some guessing if you said what the original number(s) and the "wrong" number(s) were. For me: A1: 270 B1: =RADIANS(A1)/PI() === 3Ï/2 when formatted as ?\Ï/? In article , "mb" wrote: I can't seem to get it to work right. I typed in what both of you said and did return a value with the pi symbol, but the wrong number. |
#7
|
|||
|
|||
Try:
?\π/##? In article , "mb" wrote: Sorry about that. I want to go from 1 to 360. For 1 thru 18 degrees it returns... oÏ/1 1 degree is pi/180 |
#8
|
|||
|
|||
That got it!! THANK YOU SO MUCH :)
mb "JE McGimpsey" wrote: Try: ?\Ï/##? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change radians - degrees setting | Excel Discussion (Misc queries) | |||
how to change radians to degrees in Excel 2003? | Excel Discussion (Misc queries) | |||
Trigonometric functions | Excel Worksheet Functions |