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:
We believe this content can enhance our services. Yet, it's awaiting comprehensive review. Your suggestions for improvement are invaluable. Kindly report any issue or suggestion using the "Report an issue" button below. We value your input.
Contact us today at – and speak with our specialist.
BSUPERIOR SYSTEM LTD. provides custom software and technology solutions to small and medium sized businesses. We have been helping businesses to operate more efficiently, reduce money and time spend on redundant repetitive daily tasks.