PI Formula in Excel
Pi is a constant value in arithmetic which is used for calculations, where in arithmetic we have the value up to two decimals but in excel we have an inbuilt PI() function which stores the exact value up to 15 decimals, this function is used in different other formulas to for further calculation.
The moment you apply the PI function, it will return the value approximate to 15 digits, i.e., 3.141592653589790
How to Insert PI Formula in Excel?
Since PI does not have any arguments, let me show you how to insert the PI formula in excel.
In any of the cell, your excel worksheet open the function PI and simply close the brackets; we would have PI value here.
PI value is an irrational number, so no limit for decimal points. Excel can show up to 30 decimal points, but any digit after 14 decimal points will be shown as zero.
How to Use PI Formula in Excel? (with Examples)
Now take an example of finding the cake’s cost per Inch. When I enquired about the cake for a New Year party, I got two quotes from the store.
- Two kg of Cake, which is 10 CM, will cost me 500 rupees.
- Five kg Cake, which is 15 CM, will cost me 600 rupees.
- Now I want to find out the cost per inch of the cake and order the cheapest cake for the party.
- Cake size is nothing but the diameter of the circle. The radius of the circle is always the exact half of the diameter. So arrive at the Radius of the cake by dividing the diameter by 2.
- So we got the radius as 5 for 10 inches cake.
- Drag the formula to cell C3.
Now we need to calculate the area of the circle (AOC). A formula to calculate the AOC is as follows.
AOC = PI * R2
R = Radius of the circle.
- Let’s apply the formula to find the AOC. AOC is PI times radius squared.
- AOC of both the cakes is given below.
- Now calculate the cost per inch. A formula is Cost / AOC.
- The cost per inch for both the cakes are as follows.
From the above calculation, it is better to buy a cake that is 15 inches costs 4.53 rupees per inch.
Like this, we can use the PI to calculate the cost and make a decision.
Things to Remember
- In order to insert PI symbol π in excel, you need to hold the ALT key and type 227 from the number keypad.
- The PI function can also be used in VBA under Application.Worksheet functionsWorksheet FunctionsThe worksheet function in VBA is used when we need to refer to a specific worksheet. When we create a module, the code runs in the currently active sheet of the workbook, but we can use the worksheet function to run the code in a particular worksheet..
- Radius is always half of the diameter.
This has been a guide to PI in Excel. Here we discuss how to use PI Formula in excel along with practical examples and a downloadable template. You may learn more about excel from the following articles –