## 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)

### Download 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 […]

Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set. Windows ANSI […]

Excel function syntax TEXT(value, format_text) Converts a value to text in a specific number format. Arguments value - The string […]

The PI function returns the number pi (¶). Formula in cell B3: =PI() Excel Function Syntax PI() Arguments PI function […]

How to use the DEGREES function

The DEGREES function calculates degrees from radians. Formula in cell C3: =DEGREES(B3) Excel Function Syntax DEGREES(angle) Arguments angle Required. The […]

The PI function returns the number pi (¶). Formula in cell B3: =PI() Excel Function Syntax PI() Arguments PI function […]

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 […]

Shannon asks:I need a formula that if I enter a start date in field B1 such as 6/8/11 it will […]

Count a specific weekday in a date range

NETWORKDAYS function returns the number of whole workdays between two dates. The array formula in this blog post counts for […]

I will demonstrate three different techniques to build monthly date ranges in this article. Two of these techniques are easy because they […]

### 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

Use the img tag, like this: <img src="Insert pic link here">

**Contact Oscar**

You can contact me through this contact form