What is PI function in Excel?
The PI function is one of the math functions of Excel.
It Returns the value of pi =3.14159265358979 accurate to 15 digits.
We can find this function in the Math&trig category of the insert function Tab.
How to use PI function in excel
- Click on an empty cell (like F5 )
2. Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select PI function
6. Then select ok
7. You will see PI Value in the formula result at the end of function arguments Tab
8. You will see results in the formula result section
Things to Remember
- This function is available for all of excel types (2007-2019)
Examples of PI function in excel
Example 1:
How to use PI function in excel
You can see examples of PI function below:
How can calculate the circumference of a circle in excel
How can calculate the area of a circle in excel
How can calculate the volume of a cone in excel
How can calculate the volume of a cylinder in excel
How can calculate the Surface area of a sphere in excel
How can calculate the Surface area of a cylinder in excel
How can calculate the volume of a sphere in excel
Purpose of PI function
It Returns the value of pi =3.14159265358979 accurate to 15 digits.
Return value of PI function
It returns a number.
Arguments of PI function
This function has just 1 Argument.
The argument of PI function is number.
You will see PI Value in the formula result at the end of function arguments Tab
The argument of PI function is required and not optional.
PI(number) = number
Version of excel supports PI function
This function is available for all excel versions (2003-2019)
