The Excel PI Function

The Excel PI function simply returns the value of the mathematical constant π (pi), accurate to 15 digits (14 decimal places).

ie. the function returns the value 3.14159265358979

The Pi function takes no arguments and therefore has the simple format :

PI( )

Pi Function Examples

The spreadsheets below show an example of the Excel Pi function.

 Formulas:
 AB
1=PI( ) 
2=SIN( PI( ) / 2 ) 
3=2 * PI( ) * 5- circumference of a circle with radius 5
 Results:
 A
13.141592654
21
331.41592654

An overview of the mathematical constant, π is provided on the Wikipedia Pi page