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

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