Author: Oscar Cronquist Article last 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)

Convert radians to fractions of pi.xlsx

How to use the RADIANS function

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