Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show

[temp]

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

 

[Bernie Deitrick]

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

 

[Tim C]

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

 

[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

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

 

[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

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.