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

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

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

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

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.

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.

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

That got it!! THANK YOU SO MUCH :)

mb

"JE McGimpsey" wrote:

Try:

?\Ã�‚¬/##?