# 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Â in Excel.

## 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.

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

Î¸ = 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 = Ï€r``2`

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 = Ï€r``2``h`

Where,

V = Volume of a cylinder

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.

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.

#### 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.

5 Excel Hacks You Never Knew