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

Get FREE Advanced Excel Exercises with Solutions!

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.


Multiply Pi in Excel: 3 Practical Cases

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.

How to Multiply Pi in Excel

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.

Multiply Pi in Excel

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

Multiply Pi in Excel

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


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.

Multiply Pi in Excel

➤ 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

Multiply Pi in Excel

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(). 


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.

Multiply Pi in Excel

➤ Write the following equation in cell E6 and press ENTER.

=PI()

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

Multiply Pi in Excel

➤ Then, write the following formula in C5 and press ENTER.

=($E$6/180)*B5

By doing so, we get the radian value for the first cell.

➤ Now, Hold and Drag cell C5 downward.

Multiply Pi in Excel

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

Multiply Pi in Excel


Practice Section

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

Multiply Pi in Excel


Download Practice Workbook

You can download and practice this workbook.


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


<< Go Back to Excel PI Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sourav Kundu
Sourav Kundu

Sourav Kundu, BSc, Naval Architecture & Marine Engineering, Bangladesh University of Engineering and Technology, is a dedicated technical content creator of the ExcelDemy project. He has a keen interest in Excel and he leverages his problem-solving skills to provide solutions on user interface with Excel. In his position as an Excel & VBA Content Developer at ExcelDemy, Sourav Kundu not only adeptly addresses challenging issues but also demonstrates enthusiasm and expertise in navigating complex situations. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo