|
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
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 |
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) 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 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 |
Better example I hope how can I show radians in symbolic forma
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 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 |
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 |
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 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. |
| All times are GMT +1. The time now is 07:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com