What is the value of Pi? I know itâ€™s a difficult question. Excel has an inbuilt **PI function** which is accurate up to 15 decimal points and can be used in calculating geometrical properties. This article will help you to multiply Pi in different equations in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download and practice this workbook.

## 3 Practical Cases to Multiply Pi in Excel

In the Excel sheet, Pi is quite easy to multiply. We have shown 3 cases where we multiplied Pi in different equations.

### 1. Multiply Pi to Find Out Circle Properties

We have a dataset of radius from different circles. We will find out the Circumference and Area of those individual circles using a simple formula where Pi will be multiplied.

**Step 1:**

âž¤ Write the following formula in** C5** and press** ENTER**.

`=2*PI()*B5`

So, we get the Circumference for the first circle.

âž¤ Now,** Hold** and **Drag** the **C5 **cell downwards.

Doing so, all cells will be populated with Circumference values.

**Step 2:**

Now, we will calculate the Area of the individual circles.

âž¤ Write the following formula in **D5** and press **ENTER**.

`=PI*B5*B5`

So, we get Area for the first circle.

âž¤ Now, **Hold** and **Drag** the **D5** cell downwards.

Thus, we get the Area values for all other circles

**Read More: How to Write Pi in Excel (5 Suitable Ways)**

### 2. Multiply Pi to Find Out Sphere Volumes

Letâ€™s have a dataset consisting of radius Values of different spheres. We are going to calculate their volumes which we have to multiply by Pi.

âž¤ Write the following formula in** the C5** cell and press** ENTER**.

`=(4/3)*PI()*B5*B5*B5`

So, we have got the volume for the first sphere.

âž¤ Now, **Hold** and **Drag** the **C5 **cell downwards.

Thus, we have got Volumes for all other Spheres.

### 3. Multiply Pi to Convert Degree Values to Radian Values

We have a dataset consisting of degree values in **Column** **B**. And, we will convert them to radian Values.

âž¤ Write the following formula in **C5** and press **ENTER**.

`=(PI()/180)*B5`

So, we have got the radian value for the first degree value.

âž¤ Now,** Hold** and **Drag C5** downward.

Thus, all the other degree values are also converted into radian values

Note: *Make sure you add parenthesis () after PI i.e. PI() or pi().Â *

**Read More: How to Put Pi by Using Formula in Excel (4 Suitable Examples)**

## How to Multiply Pi Using Cell Reference in Excel

We can multiply pi using cell reference in Excel.

We have the same dataset for converting degree values to radians.

In **E6**, we will set the cell reference.

âž¤ Write the following equation in cell **E6** and press **ENTER**.

`=PI()`

We will get the value of pi in the** E6** cell.

âž¤ Then, write the following formula in **C5 **and press **ENTER**.

`=($E$6/180)*B5`

Doing so, we get the radian value for the first cell.

âž¤ Now, **Hold** and **Drag** cell **C5** downward.

Thus, we get the radian values for all other cells.

**Read More: How to Use PI(Ï€) in Excel VBA (4 Easy Examples)**

## Practice Section

You can download the practice workbook and practice these methods yourself.

## Conclusion

Thank you for making it this far. Now you can multiply Pi in Excel. If there are any queries or suggestions regarding these methods feel free to use the comment section.