Better example I hope how can I show radians in symbolic formatin excel? like 90 degrees would show (Symbol Pi/2) 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 B1:D1 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" wrote in message
...
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
|