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 the formula in cell D3
Step 1 - Divide radian by pi
The first operation is the division between the radian number and pi.
C3/PI()
becomes
6.28318530717959/PI()
The PI function returns the number pi (¶).
Function syntax: PI()
6.28318530717959/PI()
becomes
6.28318530717959/3.14159265358979
and returns 2
Step 2 - Calculate fractions
The TEXT function converts a value to text in a specific number format.
Function syntax: TEXT(value, format_text)
TEXT(C3/PI(),"?/?")
becomes
TEXT(2,"?/?")
and returns "2/1".
Step 3 - Display the PI character
The CHAR function converts a number to the corresponding ANSI character determined by your computers character set.
Function syntax: CHAR(text)
The CHAR function inserts the pi symbol using ANSI code 182.
CHAR(182)
returns ¶
Step 4 - Join values
Lastly, the ampersands concatenate the values.
TEXT(C3/PI(),"?/?")&"*"&CHAR(182)
becomes
"2/1"&"*"&¶
and returns "2/1*¶".
Get Excel *.xlsx file
Convert radians to fractions of pi.xlsx
Read more about the Excel Functions
Recommended articles
What is the RADIANS function? The RADIANS function converts degrees to radians. What is radian? Radians measure angles by the […]
Recommended articles
Use the CHAR function to convert a number to the corresponding character. This is determined by your computer's character set. […]
Recommended articles
This article demonstrates how to use the TEXT function in great detail. The formula in cell D3 formats the number […]
Recommended articles
What is the PI function? The PI function returns the number pi (¶). What is the number pi? Pi is […]
Excel categories
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.