Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Worksheet Functions 2 December 24th 07 11:45 PM
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Discussion (Misc queries) 4 December 24th 07 03:21 AM
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Discussion (Misc queries) 2 December 14th 07 08:36 PM
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Worksheet Functions 2 December 14th 07 08:36 PM
how to change radians to degrees in Excel 2003? sfgsdg Excel Discussion (Misc queries) 3 January 21st 05 08:53 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"