radians

[mb]

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

 

[JE McGimpsey]

One way:

B1: =RADIANS(A1)/PI()

Format B1 with

Format/Cells/Number/Custom ?\Ï€/?

 

[Barb R.]

The best you can do is to convert it to something in terms of PI

if A1=270
B1= RADIANS(A1)/PI()

 

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

 

[JE McGimpsey]

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 ?\Ï€/?

 

[mb]

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]

Try:

?\Ï€/##?

 

[mb]

That got it!! THANK YOU SO MUCH

mb