View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default How can I show radians in symbolic format in excel? like 90degrees would show (Symbol Pi/2) tia sal2

temp wrote...
...
20 degrees ---- 0.34906585 Radians ---- I want to convert it to show
up as Pi/9 in excel in another column
40 degrees ---- 0.698131701Radians---- I want to convert it to show
up as 2Pi/9 in excel in another column

...

If cell A1 contained the angle in degrees, the following formula will
convert it to a TEXT REPRESENTATION in radians.

=TRIM(SUBSTITUTE(SUBSTITUTE(TEXT(A1/180," ?\p/??")," 1p","p"),"/1
",""))

But you'd need to change the font's typeface to Symbol for the cells
containing such formulas. Doing so produces the following results.

0 0ð
15 ð/12
20 ð/9
30 ð/6
45 ð/4
60 ð/3
75 5ð/12
90 ð/2
180 ð
270 3ð/2

where ð is the symbol for pi in Google Groups reply box.