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

The RADIANS function converts degrees to radians. Formula in cell C3: =RADIANS(B3) Excel Function Syntax RADIANS(angle) Arguments angle Required. 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

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

## Functions in this article

More than 1300 Excel formulas

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

**Contact Oscar**

You can contact me through this contact form

Very good source of information on converting radians to the fractions of pi. Thanks to the writer for sharing this very important information.