How to Use Pi in Excel

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.

pi in Excel insert greek pi letter

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).

format number fifteen digits pi

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


pi in Excel area of circle pi