## What Is PI In Excel?

PIis a constant value in arithmetic that is used for calculations. Whereas in arithmetic, we have the value of up to two decimals. But in Excel, we have a built-inPI() functionwhich stores the exact value up to 15 decimals. This function is used in different other formulas for further calculation.

For example, consider the below table showing garland material and cost.

Using PI in Excel, we can find the value as shown in the below image.

In this article, let us learn how to obtain results using PI in Excel with detailed examples.

##### Table of contents

### Key Takeaways

- PI is a constant value in arithmetic used for calculations, with a maximum of two decimals. In Excel, the built-in PI() function stores the exact value up to 15 decimals, which is used in various formulas for further calculations.
- To insert the PI symbol “π” in Excel, one should hold the ‘ALT’ key and type 227 from the number keypad.
- The PI function in VBA can be utilized under Application.Worksheet functions, with the radius always being half of the diameter.

### PI Excel Formula

When you apply the PI function, it will return the value of approximately 15 digits, 3.141592653589790.

**Excel VBA – All in One Courses Bundle (35+ Hours of Video Tuto**rials)

**–>>** **If you want to learn Excel and VBA professionally**, then Excel VBA All in One Courses Bundle (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from **Basic Excel to Advanced Excel, Macros, Power Query, and VBA.**

### How To Insert PI Formula In Excel?

Since PI has no arguments, let us show you how to insert the PI formula in Excel.

In any of the cells in the Excel worksheet, open the function PI and close the brackets. We would have PI value here.

PI value is an irrational number, so there is no limit for decimal points. For example, Excel can show up to 30 decimal points, but any digit after 14 decimal points will be shown as zero.

### How To Use PI In Excel?

As already discussed, PI value is an irrational number, so there is no limit for decimal points. Let us learn how to use PI function in Excel with the following examples.

### Examples

#### Example #1

Now, take an example of finding the cake’s cost per inch. We got two quotes from the store when we enquired about the cake for a New Year party.

- 2kg cake, 10 cm, cost ₹500.
- 5kg cake, 15 cm, cost ₹600.

**Now, we want to find out the cost per inch of the cake and order the cheapest cake for the party.****The cake size is nothing but the diameter of the circle. So, the circle’s radius is always the exact half of the diameter. So, we can arrive at the radius of the cake by dividing the diameter by 2.****So, we got the radius as 5 for 10 inches of cake.****Drag the formula to cell C3.**

We need to calculate the Area Of the Circle (AOC). A formula to calculate the AOC is as follows:**AOC = PI * R**^{2}**R = Radius of the circle.****Let us 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. The formula is Cost / AOC.****The cost per inch for both cakes is as follows:**

From the above calculation, buying a cake that is 15 inches costs ₹4.53 rupees per inch is better.

Like this, we can use the PI to calculate the cost and make a decision.

#### Example #2

Now, take an example of finding the material’s cost per inch. We got two quotes from the store when we enquired about the material.

Now, we want to find out the cost per inch of the material.

We can arrive at the radius by dividing the diameter by 2.

So, we got the radius.

Drag the formula to cell C3.

We need to calculate the Area Of the Circle (AOC). A formula to calculate the AOC is as follows:

**AOC = PI * R ^{2}**

**R = Radius of the circle.**

**Let us apply the formula to find the AOC. AOC is PI times radius squared.**

**So, we got the AOC.**

**Drag the formula to cell D3.**

**AOC of both the material is given below.**

**Now, calculate the cost per inch. The formula is Cost / AOC.**

**Press Enter. We will get the result as shown in the below image.**

**Drag the formula to cell D3.**

**The cost per inch for both the values is obtained.**

From the above calculation, buying a cake that is 15 inches costs ₹4.53 rupees per inch is better.

Like this, we can use the PI to calculate the cost and make a decision.

### Important Things To Note

- To insert the PI symbol
**“π”**in Excel, we must hold the ALT key and type 227 from the number keypad. - We can also use the PI function 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.read more.
- The radius is always half of the diameter.

### Frequently Asked Questions

**1. Why does PI have parentheses in Excel?**

Parentheses are crucial in spreadsheets as they are essential for specific formulas, such as Viete’s approximation of pi, which require thinking in parentheses and creating formulas that naturally build a series.

For example, consider the below table showing garland material and cost.

Using PI in Excel, we can find the value as shown in the below image.

**2. How accurate is PI in Excel?**

The mathematical constant PI in Excel is accurate to 15 digits and is returned by the function.

**3. What is PI invalid name error in Excel?**

To rectify a syntax issue and retry a calculation, amend the misspelling, and utilize Excel’s automated function to add specified names to formulae. Go to Formulas – Defined Names – Use in Formula, then choose the required name, which Excel will immediately add.

### Recommended Articles

This article is a guide to PI in Excel. We discuss using the PI formula in Excel, practical examples, and a downloadable template. You may also learn more about Excel from the following articles: –

- RANK Excel FunctionRANK Excel FunctionExcel Rank formula gives rank of a given data set of numbers. The rank function was an inbuilt function in Excel 2007 and older versions; we now have Rank.Avg and Rank.Eq functions in subsequent versions above 2007.read more
- SQRT in ExcelSQRT In ExcelThe Square Root function is an arithmetic function built into Excel that is used to determine the square root of a given number. To use this function, type the term =SQRT and hit the tab key, which will bring up the SQRT function. Moreover, this function accepts a single argument.read more
- INT Function in ExcelINT Function In ExcelINT or integer function in excel returns the nearest integer of a given number and is used when we have many data sets and each data in a different format.read more
- SIGN Function in ExcelSIGN Function In ExcelThe sign function in excel is a Math/Trig function that returns the sign (-1, 0 or +1) of the numerical argument supplied to it.read more
- Excel TranslateExcel TranslateThe Excel Translate function translates any statement or word into another language. It can be found in the language section of the review tab.read more