The PI function is a Math and Trigonometry formula that returns the equivalent value for the mathematical constant pi (π), which is commonly used in finding the diameter or volume of circles and spherical objects. In this guide, we’re going to show you how to use the PI formula and also go over some tips and error handling methods.

Supported versions

  • Excel 2003 and newer

Syntax of the PI Function


PI Function Examples

This is a very straightforward function which actually doesn’t need any arguments. All you need to do is to use the function wherever you would like, and use with empty parentheses.


Excel PI Function 01

Circle-or-sphere-based calculations are common usage scenarios for the number π. Here are some examples:

Download Workbook