Sourav Kundu
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.
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.
