PI function
PI returns the value of pi, 3.14159265358979, accurate to about 15 digits. Use it with RADIANS and in area and circumference formulas. It needs the empty parentheses.
Example
A
B
C
D
1
3.141592654
2
3
Syntax
PI()
PI takes no arguments.
Returns: 3.14159265358979, the value of pi.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=PI() | 3.141592654 | PI() |
=2*PI() | 6.283185307 | In arithmetic |
Watch out for
- Needs the empty parentheses.
Where it works
- Excel
- PI is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .