Md. Abdur Rahim Rasel
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 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 .
Read More: [Solved!] Name Error of PI Function in Excel
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.
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θ
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.
- 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.
Read More: How to Multiply Pi in Excel (with 3 Practical Cases)
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
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.
Read More: How to Use PI(Ï€) in Excel VBA (4 Easy Examples)
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
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.
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)
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.
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.
