Exceljet

Quick, clean, and to the point

Excel PI Function

Excel PI function
Summary 

The Excel PI function returns the value of the geometric constant π (pi). The value represents a half-rotation in the radian angle system. The constant appears in many formulas relating the the circle such as the area of a circle.

Purpose 
Get the value of π
Return value 
3.14159265358979
Syntax 
=PI ()
Arguments 
Usage notes 

The PI function returns the value of π (pi) accurate to 15 digits. The value of π represents a half-turn in radians and appears in many formulas relating to the circle.

=PI() // Returns 3.14159265358979

Examples

To convert an angle measured in radians that is in terms of π, the DEGREES function can be used to get the corresponding angle in degrees:

=DEGREES(PI()) // Returns 180°
=DEGREES(2*PI()) // Returns 360°

The constant π appears in many math formulas relating to the circle. For example, the formula shown below, returns the circumference of a circle with a radius of 3:

=2*PI()*3 // Circumference of circle r=3

See wumbo.net for a more detailed explanations of key math concepts and formulas.