How to convert radians to fractions of pi
The formula in cell D3 converts the radian decimal value to fractions of pi.
Formula in cell D3:
Explaining formula in cell D3
The first operation is the division between the radian number and pi.
C3/PI()
The TEXT function then calculates the fraction.
TEXT(C3/PI(),"?/?")
The CHAR function inserts the pi symbol using ANSI code 182.
CHAR(182)
Lastly, the ampersands concatenate the values.
TEXT(C3/PI(),"?/?")&"*"&CHAR(182)
Get Excel *.xlsx file
Convert radians to fractions of pi.xlsx
Read more about the Excel Functions
How to use the RADIANS function
The RADIANS function converts degrees to radians. Formula in cell C3: =RADIANS(B3) Excel Function Syntax RADIANS(angle) Arguments angle Required. The […]
How to use the RADIANS function
Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set. Windows ANSI […]
This article demonstrates how to use the TEXT function in great detail. The formula in cell D3 formats the number […]
The PI function returns the number pi (¶). Formula in cell B3: =PI() Excel Function Syntax PI() Arguments PI function […]
One Response to “How to convert radians to fractions of pi”
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Very good source of information on converting radians to the fractions of pi. Thanks to the writer for sharing this very important information.