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

**Table of Contents**hide

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

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

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

** **

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

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

**Notes****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.