How to Multiply Pi in Excel (with 3 Practical Cases)

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.

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)

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.

Related Articles

Sourav Kundu

Bio: Hi, I am Sourav Kundu. I live in Adabor, Dhaka. I graduated in Naval Architecture and Marine Engineering from BUET. I am really excited to be a part of SOFTEKO family. I want to develop my research skill and find innovative solutions for the given problems.

We will be happy to hear your thoughts

5 Excel Hacks You Never Knew