The constant pi (π) number is one of the most important numbers in mathematics and is present in many important numerical calculations. In two-dimensional geometry, pi represents the ratio of the perimeter of a circle to its diameter.
PI Function in Excel
In Microsoft Excel, the PI function returns the value of pi number accurate to 14 decimal places. The PI function takes no arguments. The syntax to use pi in Excel is as below:
You may not need the pi number with 14 decimals. In this case, you can define the accuracy of pi number by using the following procedure
1) Right-click on your worksheet cells
2) Select format cells. The format cells dialogue will appear,
3) Choose the number under the category, and write the desired decimals in the “decimal places” box.
Even though the PI function requires no arguments, you still need to include the open and close parentheses because if you don’t, Excel will return the NAME error.
PI in Excel formula examples
Here are some examples of using the PI function in Excel formulas in some mathematical calculations.
To convert an angle measured in degrees to radians and vice versa, we can use the PI function using the formulas below:
A (radian) = B(degree)×180/π
A (degree) = B (radian)× π/180
These formulas are similar to the RADIANS and DEGREES functions, respectively.
To calculate the area of a sphere from its radius using the PI function, we can use this formula:
The way to use the PI function in Excel cells for the above formulas is shown in the following image:
There are a lot of other applications and equations containing pi.
You can connect with us and ask our experts for your inquiries and get more Excel Support Service.
Reduce cost, accelerate tasks, and improve quality with Excel Automation Service.