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 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
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
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.
>
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
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
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.
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()
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks