Better example I hope How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2

Greets All
I have one column that has the angles in 20 degrees increments up to 720 degrees
Is thier a way for excel to show them in Radian in symbolic format? I've already converted them to radians by
multipling angle*PI()/180 but how do I get it to look it symbolicly?

Example:
180 degrees would look like (symbol Pi)
90 degrees would look like (Symbol Pi/2)

Better Example
I have three columns in Excel

20 degrees ---> 0.34906585 Radians ---> I would like the next column in excel to compute and show Pi/9
40 degrees ---> 0.698131701 Radians ---> I would like the next column in excel to compute and show 2Pi/9
60 degrees ---> 1.047197551 Radians ---> I would like the next column in excel to compute and show Pi/3
etc....

Tia sal2

Sal,

You could do this with one whomping big formula, but I'm lazy, and will use three columns of
formulas:

With your degrees in cell A1, put this formula in B1
=IF(C1<>"1",C1 &$E$1,$E$1) & IF(AND(D1<>"1",C1<>D1), "/" & D1,"")

And this formula in C1
=IF(INT(A1/180)<> (A1/180),LEFT(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))-1),TEXT(A1/180,"0"))

And this formula in D1
=IF(INT(A1/180)<>
(A1/180),MID(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))+1,LEN(TEXT(A1/180,$F$1))),TEXT(A1/180,"0"))

And insert the Pi symbol into cell E1

And insert a formatting string into cell F1, with the accuracy you want: like
#/## or #/# or ##/###

Then copy cells B11 down to match your list of degrees in column A.

You can convert to a single formula by replacing the three instances of C1 and D1 in the formula in
cell B1 with the formula in C1 and D1 (without the = sign)- it just gets really long and
complicated....

HTH,
Bernie
MS Excel MVP


"temp" <(E-Mail Removed)> wrote in message news:hIz8j.156617$(E-Mail Removed)...
> Better example I hope How can I show radians in symbolic format in excel? like 90 degrees would
> show (Symbol Pi/2) tia sal2
>
> Greets All
> I have one column that has the angles in 20 degrees increments up to 720 degrees
> Is thier a way for excel to show them in Radian in symbolic format? I've already converted them
> to radians by
> multipling angle*PI()/180 but how do I get it to look it symbolicly?
>
> Example:
> 180 degrees would look like (symbol Pi)
> 90 degrees would look like (Symbol Pi/2)
>
> Better Example
> I have three columns in Excel
>
> 20 degrees ---> 0.34906585 Radians ---> I would like the next column in excel to compute and show
> Pi/9
> 40 degrees ---> 0.698131701 Radians ---> I would like the next column in excel to compute and show
> 2Pi/9
> 60 degrees ---> 1.047197551 Radians ---> I would like the next column in excel to compute and show
> Pi/3
> etc....
>
> Tia sal2
>

As a less ideal solution, but a shorter formula, try this.

With the number of degrees in cell A1,
B2 =A1/180
Insert a Pi symbol in any cell, and copy it.
Format B2 with the custom number format of ##"P"/##
but instead of the P, paste in the Pi symbol you copied.

(To vary the accuracy of the fraction, change the number of #'s in the
number format.)

The only disadvantage I see is that it shows ones. (1Pi/2 and 2Pi/1 instead
of Pi/2 and 2Pi)

Tim C

"Bernie Deitrick" wrote:

> Sal,
>
> You could do this with one whomping big formula, but I'm lazy, and will use three columns of
> formulas:
>
> With your degrees in cell A1, put this formula in B1
> =IF(C1<>"1",C1 &$E$1,$E$1) & IF(AND(D1<>"1",C1<>D1), "/" & D1,"")
>
> And this formula in C1
> =IF(INT(A1/180)<> (A1/180),LEFT(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))-1),TEXT(A1/180,"0"))
>
> And this formula in D1
> =IF(INT(A1/180)<>
> (A1/180),MID(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))+1,LEN(TEXT(A1/180,$F$1))),TEXT(A1/180,"0"))
>
> And insert the Pi symbol into cell E1
>
> And insert a formatting string into cell F1, with the accuracy you want: like
> #/## or #/# or ##/###
>
> Then copy cells B11 down to match your list of degrees in column A.
>
> You can convert to a single formula by replacing the three instances of C1 and D1 in the formula in
> cell B1 with the formula in C1 and D1 (without the = sign)- it just gets really long and
> complicated....
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "temp" <(E-Mail Removed)> wrote in message news:hIz8j.156617$(E-Mail Removed)...
> > Better example I hope How can I show radians in symbolic format in excel? like 90 degrees would
> > show (Symbol Pi/2) tia sal2
> >
> > Greets All
> > I have one column that has the angles in 20 degrees increments up to 720 degrees
> > Is thier a way for excel to show them in Radian in symbolic format? I've already converted them
> > to radians by
> > multipling angle*PI()/180 but how do I get it to look it symbolicly?
> >
> > Example:
> > 180 degrees would look like (symbol Pi)
> > 90 degrees would look like (Symbol Pi/2)
> >
> > Better Example
> > I have three columns in Excel
> >
> > 20 degrees ---> 0.34906585 Radians ---> I would like the next column in excel to compute and show
> > Pi/9
> > 40 degrees ---> 0.698131701 Radians ---> I would like the next column in excel to compute and show
> > 2Pi/9
> > 60 degrees ---> 1.047197551 Radians ---> I would like the next column in excel to compute and show
> > Pi/3
> > etc....
> >
> > Tia sal2
> >
>
>
>

On Fri, 14 Dec 2007 14:13:13 -0500, Bernie Deitrick wrote:

> Sal,
>
> You could do this with one whomping big formula, but I'm lazy, and will
> use three columns of formulas:
>
> With your degrees in cell A1, put this formula in B1 =IF(C1<>"1",C1
> &$E$1,$E$1) & IF(AND(D1<>"1",C1<>D1), "/" & D1,"")
>
> And this formula in C1
> =IF(INT(A1/180)<>
> (A1/180),LEFT(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))-1),TEXT
(A1/180,"0"))
>
> And this formula in D1
> =IF(INT(A1/180)<>
> (A1/180),MID(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))+1,LEN(TEXT
(A1/180,$F$1))),TEXT(A1/180,"0"))
>
> And insert the Pi symbol into cell E1
>
> And insert a formatting string into cell F1, with the accuracy you want:
> like
> #/## or #/# or ##/###
>
> Then copy cells B11 down to match your list of degrees in column A.
>
> You can convert to a single formula by replacing the three instances of
> C1 and D1 in the formula in cell B1 with the formula in C1 and D1
> (without the = sign)- it just gets really long and complicated....
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "temp" <(E-Mail Removed)> wrote in message
> news:hIz8j.156617$(E-Mail Removed)...
>> Better example I hope How can I show radians in symbolic format in
>> excel? like 90 degrees would show (Symbol Pi/2) tia sal2
>>
>> Greets All
>> I have one column that has the angles in 20 degrees increments up to
>> 720 degrees Is thier a way for excel to show them in Radian in symbolic
>> format? I've already converted them to radians by
>> multipling angle*PI()/180 but how do I get it to look it symbolicly?
>>
>> Example:
>> 180 degrees would look like (symbol Pi) 90 degrees would look like
>> (Symbol Pi/2)
>>
>> Better Example
>> I have three columns in Excel
>>
>> 20 degrees ---> 0.34906585 Radians ---> I would like the next column
>> in excel to compute and show Pi/9
>> 40 degrees ---> 0.698131701 Radians ---> I would like the next column
>> in excel to compute and show 2Pi/9
>> 60 degrees ---> 1.047197551 Radians ---> I would like the next column
>> in excel to compute and show Pi/3
>> etc....
>>
>> Tia sal2
>>

Thanks so much for your help I'll give it a try

On Fri, 14 Dec 2007 14:13:13 -0500, Bernie Deitrick wrote:

> Sal,
>
> You could do this with one whomping big formula, but I'm lazy, and will
> use three columns of formulas:
>
> With your degrees in cell A1, put this formula in B1 =IF(C1<>"1",C1
> &$E$1,$E$1) & IF(AND(D1<>"1",C1<>D1), "/" & D1,"")
>
> And this formula in C1
> =IF(INT(A1/180)<>
> (A1/180),LEFT(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))-1),TEXT
(A1/180,"0"))
>
> And this formula in D1
> =IF(INT(A1/180)<>
> (A1/180),MID(TEXT(A1/180,$F$1),FIND("/",TEXT(A1/180,$F$1))+1,LEN(TEXT
(A1/180,$F$1))),TEXT(A1/180,"0"))
>
> And insert the Pi symbol into cell E1
>
> And insert a formatting string into cell F1, with the accuracy you want:
> like
> #/## or #/# or ##/###
>
> Then copy cells B11 down to match your list of degrees in column A.
>
> You can convert to a single formula by replacing the three instances of
> C1 and D1 in the formula in cell B1 with the formula in C1 and D1
> (without the = sign)- it just gets really long and complicated....
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "temp" <(E-Mail Removed)> wrote in message
> news:hIz8j.156617$(E-Mail Removed)...
>> Better example I hope How can I show radians in symbolic format in
>> excel? like 90 degrees would show (Symbol Pi/2) tia sal2
>>
>> Greets All
>> I have one column that has the angles in 20 degrees increments up to
>> 720 degrees Is thier a way for excel to show them in Radian in symbolic
>> format? I've already converted them to radians by
>> multipling angle*PI()/180 but how do I get it to look it symbolicly?
>>
>> Example:
>> 180 degrees would look like (symbol Pi) 90 degrees would look like
>> (Symbol Pi/2)
>>
>> Better Example
>> I have three columns in Excel
>>
>> 20 degrees ---> 0.34906585 Radians ---> I would like the next column
>> in excel to compute and show Pi/9
>> 40 degrees ---> 0.698131701 Radians ---> I would like the next column
>> in excel to compute and show 2Pi/9
>> 60 degrees ---> 1.047197551 Radians ---> I would like the next column
>> in excel to compute and show Pi/3
>> etc....
>>
>> Tia sal2
>>
I tried this and an error message popped up when I ran a tracer on it it
said " The Error Tracer encountered existing arrows or a circular
reference. Delete all tracer arrows or resolve the circular reference,
and then choose tracer again" The arrow is going from C1 to B1. I'm not
sure why though.