radians

One way:

B1: =RADIANS(A1)/PI()

Format B1 with

Format/Cells/Number/Custom ?\?/?

In article <[email protected]>,
"mb" <[email protected]> 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 <[email protected]>,
"mb" <[email protected]> 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 <[email protected]>,
> "mb" <[email protected]> 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 <[email protected]>,
"mb" <[email protected]> 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:
>
> ?\Ï€/##?
>
>
>

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 <[email protected]>,
"mb" <[email protected]> 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 <[email protected]>,
"mb" <[email protected]> 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 <[email protected]>,
> "mb" <[email protected]> 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 <[email protected]>,
"mb" <[email protected]> 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:
>
> ?\Ï€/##?
>
>
>