Skip to content

How to Use Excel PI Function?

Listen to this article
PI SymbolPin
PI Symbol

Excel PI Function: The term PI (π) is a mathematical constant value. During our school days, we use many formulas with the PI value in Math and Physics. The approximate value of PI is 3.14159. This PI value is derived from the ratio of a circle’s circumference to its diameter. In decimal form, we can mention its value as 3.14.

As we all know, Excel has more number of built-in functions and formulas, it also includes the PI function. If you want to use this function on your Excel workbook, then keep reading this page. We will offer you clear-cut instructions to know how to use the PI function on your Excel workbook with its brief explanations, syntax, and examples. Get an official version of MS Excel from the following link

Excel PI FunctionPin
Excel PI Function

PI Function – Description

  • This function returns the value of the constant π (3.14159265358979).
  • As we already said, the value of PI is calculated by dividing a circumference of a circle by its diameter.
  • You need to know that, Excel stores the value of PI accurately to 15 digits and up to 14 decimal places (3.14159265358979), so we can get more accurate results when we use it in Excel.


  • This is the syntax of the PI function in Excel. To get the PI value on your spreadsheet, just copy and paste the below-given formula on any cell, and press the Enter button.
  • At the instance, you will get the PI value on the selected cell.
  • This function cannot have any arguments.


Note: If any argument is a non-numeric value (letters and special characters) and then it returns #VALUE! Error.


Here, we come up with some examples to try out this PI function on the Excel worksheet. The given examples might be enough for you to understand the working concept of the PI function.

  • Initially, you have to open your Excel workbook on your PC and launch a new worksheet.
  • If you want to get the PI value on the active cell, then you need to use the PI function.
  • Once you enter the formula in the selected cell, click on the Enter button to get the result, as shown below.
Use PI FunctionPin
Use PI Function

Let’s see another example to know how to use the PI function with operators. For instance, we try to divide and multiply certain values with PI.

  • To do so, you need to enter the formulas as shown in the following screenshot.
  • You can see that we have calculated the value of  π\2, π\5, and π*2.
PI functionPin
PI function


So far, we have learned how to use Excel PI Function with its syntax, description, and examples. We hope that the provided example might be helpful to you.

If you have any queries regarding this Excel PI function, kindly comment to us in the below section. If you want to learn more Excel formulas, then visit our webpage

Read Also:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...