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. The formula for the functions are shown in the spreadsheet on the left, and the results are shown in the spreadsheet on the right.

  A B
1 =PI( )  
2 =SIN( PI( ) / 2 )  
3 =2 * PI( ) * 5 - circumference of a circle with radius 5
1 3.141592654
2 1
3 31.41592654

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

Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions