How to Put Pi by Using Formula in Excel (4 Suitable Examples)

In mathematics, the constant Pi is utilized in calculations. In short, PI is the ratio of a circle’s diameter to its circumference. While in mathematics, we can use up to two decimal places to represent values. When our company needs to perform geometric calculations, we frequently employ Excel’s PI Function. These calculations include figuring out the size of a new factory, office space, etc. However, Excel comes with a built-in PI() function that can record the precise result down to 15 decimal places. For additional calculations, this function is incorporated into several other formulas. Today, in this tutorial, we will learn how to put Pi using the formula in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Introduction to PI Function to Excel

→ Syntax

The syntax of the PI function is,

=PI()

→ Arguments Explanation

There are no arguments in the PI function syntax.

→ Return Value

The PI function returns a constant value. The constant value is  3.141592654 .

Notes
The PI function is available in Excel XP, Excel 2003 and later versions, and Office 365.

4 Suitable Examples to Put Pi by Using Formula in Excel

Consider the following dataset. Let’s use this dataset to calculate the arc length, area of a circle, volume of a cylinder, and time period of a pendulum. We will use the Pi value to calculate those parameters in Excel. Here’s an overview of the dataset for today’s task.

how to put pi in excel formula


Example 1: Calculating Arc Length Using Pi in Excel

In this example, we will calculate the arc length using the PI function in Excel. The formula of the arc length is,

S = rθ

Calculating Arc Length Using Pi in Excel

Where,

S = The length of an arc

R = Radius

θ = Central angle (in Radians)

Using the above formula along with the PI function, we will calculate the arc length. Let’s follow the instructions below to learn!

Steps:

  • First of all, select cell C5 and write down the following formula with the PI function in that cell. The formula is,
=PI()*0
  • Hence, press Enter on your keyboard. As a result, you will get 0 radians which is the return of the formula.

 

  • Further, you take the angles as you want.

Calculating Arc Length Using Pi in Excel

  • After that, type the below formula in cell D5.
=B5*C5
  • Where B5 is the radius and C5 is the angle.
  • Afterward, again, press Enter to get the output of the formula. The output is 0 cm.

  • Now, AutoFill the formula to the rest of the cells in column Finally, you will get your desired output in column D.

Calculating Arc Length Using Pi in Excel


Example 2: Calculating the Area of a Circle Using Pi in Excel

Now, we will use the formula of the area of a circle along with the PI function to calculate the area of a circle. The formula of the area of a circle is,

A = πr2

Calculating Area of a Circle Using Pi in Excel

Where,

A = Area of a circle

Π = Pi constant

r = Radius of the circle

Applying the above formula along with the PI function, we will calculate the area of a circle. Let’s follow the instructions below to learn!

Steps:

  • Type the following formula in cell D5,
=$C$5*B5*B5
  • Where B5 is the radius and C5 is the value of Pi.
  • Hence, press Enter on your keyboard. As a result, you will get 159 sq. cm which is the area of the circle.

  • Now, AutoFill the formula to the rest of the cells in column D.

Calculating Area of a Circle Using Pi in Excel


Example 3: Calculating Volume of Cylinder Applying Pi in Excel

Another example is to calculate the volume of a cylinder. We know that the formula of a cylinder, and the formula is,

V = πr2h

Calculating Volume of Cylinder Applying Pi in Excel

Where,

V = Volume of a cylinder

r = radius

h = height of the cylinder

Now, let’s follow the instructions below to calculate the volume of a cylinder!

Steps:

  • Firstly, write down the following formula in cell E5,
=$D$5*B5*B5*C5
  • Where B5 is the radius, C5 is the height, and $D$5 is the value of Pi.
  • Further, press Enter on your keyboard. As a result, you will get 4712.389 cubic cm which is the volume of a cylinder.

  • Hence, AutoFill the formula to the rest of the cells in column E.

Calculating Volume of Cylinder Applying Pi in Excel


Example 4: Calculating the Period of a Pendulum Using Pi and Square Root

Last but not least, this is the most interesting example, here, we will figure out the time period of a pendulum. The formula for the time period of a pendulum is,

T = 2π√(L/g)

Calculating Period of a Pendulum Using Pi and Square Root

Where,

T = Time period

Π = Constant

L = Effective length

g = Gravitational acceleration

Afterward, let’s follow the instructions below to figure out the time period of a pendulum!

Steps:

  • Insert the following formula in cell E5,
=2*$D$5*SQRT(B5/$C$5)
  • Where B5 is the effective length, C5 is the gravitational acceleration, and $D$5 is the value of Pi.
  • After that, press Enter on your keyboard. As a result, you will get 7.769 sec which is the time period of a pendulum.

  • Further, AutoFill the formula to the rest of the cells in column E.

Calculating Period of a Pendulum Using Pi and Square Root

Notes
You can enter the Pi symbol (π) in Excel by holding the  Alt  key and pressing  227  from the number keypad.

 


Conclusion

I hope all the suitable examples mentioned above to put Pi with formula will provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to comment if you have any questions or queries.

Tags:

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

ExcelDemy
Logo