In this Excel article, you will teach yourself how to use Pi in Excel.
The π is a special value known since ancient times. The pi value represents a half-rotation in the radian angle system.
In Excel you can use pi value for geometric calculations.
Pi function in Excel
Let's start from using pi in Excel. Syntax of PI function is very easy. There are no arguments of pi function.
Excel PI formula is just =PI()
Excel Pi function returns pi value up to 15 digits.
π in Excel equals exactly 3.14159265358979 which is the exact value of this constant.
How to type pi in Excel?
You can insert π symbol in Excel. To do that go to Insert tab and click Symbol button.
Greek capital letter Pi you can find in Greek and Coptic subset.
How to display an exact value of Pi?
To show every fifteen digits of the Pi right-click a cell and select Format Cells option.
You can also use a keyboard shortcut of Alt + 1.
From the Format Cells menu pick Number and increase decimal places to 14. The Pi equals to fifteen digits which is three plus fourteen digits (exactly 3.14159265358979).
In the same cell type =PI() and press Enter keyboard button.
Probably, instead of Pi value you will see just ### in the cell. This is because your cell to narrow. You need to increase the size of the cell. Just drag the header of the spreadsheet drag to enlarge the column. Now, you can see the every fifteen digits of Pi.
The Pi in VBA
To call in the VBA Pi function use below Excel VBA code.
Example of using pi in Excel
You can use pi function to calculate area of the circle. Use this pi Excel formula