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.
- 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.
Circle-or-sphere-based calculations are common usage scenarios for the number π. Here are some examples:
- The PI function actually returns the number 3.14159265358979, which is equivalent to pi, with a 15 decimals precision. This 15-digit limit is a restriction imposed by Excel.
- Also see how to calculate the volume of a sphere in Excel