PI Formula in Excel

Syntax

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

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 Formula in Excel? (with 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.

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

  • 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 * R2R = 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:

We need to calculate the Area Of the Circle (AOC). A formula to calculate the AOC is as follows:AOC = PI * R2R = Radius of the circle.

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

Things to Remember

  • 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.

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 moreSQRT 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 moreINT 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 moreSIGN 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 moreExcel 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