Article updated on March 19, 2018

The formula in cell D3 converts the radian decimal value to fractions of pi.

Formula in cell D3:

=TEXT(C3/PI(),"?/?")&"*"&CHAR(182)

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

How to use the CHAR function

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

How to use the TEXT function

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

How to use the PI function

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