## How to convert radians to fractions of pi

*Article updated on March 19, 2018*

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

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

## Share this article