PI function in Excel

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

  1. Click on an empty cell (like F5 )
empty cell excel

2. Click on the fx icon (or press shift+F3)

 fx icon excel

3. In the insert function tab you will see all functions

 insert function tab excel

4. Select math and trig category

5. Select PI function

6. Then select ok

pi function excel

7. You will see PI Value in the formula result at the end of function arguments Tab

 PI Value formula excel

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:

Examples of PI function in excel

How can calculate the circumference of a circle in excel

how can calculate circumference of circle in excel

How can calculate the area 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 cone in excel

How can calculate the volume of a cylinder 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 sphere in excel

How can calculate the Surface area of a cylinder in excel

how can calculate the Surface area of a cylinder in excel

How can calculate the volume of a sphere 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)

Errors in PI function

PI related function

Leave a Reply

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