Buzz
Pi is a mathematical constant with an approximate value of 3.1415926535897…
Pi can be found in many trigonometric and geometric formulas, especially those related to circles, ellipses, and spheres:
- The circumference of a circle equals the product of Pi and the diameter.
- The area of a circle equals the product of Pi and the square of the radius.
Excel introduces the Pi function to help users apply trigonometric formulas when using the software. This article provides software tips to guide you on the syntax and usage of the Pi constant in Excel.
Function syntax: =PI().
The Pi function does not take any arguments.
Example 1: In a cell A1, you enter the formula =PI(), the result returned is: 3.141593.
Example 2: You have the diameter of a circle in cell B2 and need to calculate the circumference of the circle in cell B4 and the area of the circle in cell B5. You apply geometric formulas as follows:
B4 =PI()2B2,
B5 =PI()*B2^2.
And you get the results as follows:
Above, Software Tips has guided readers on the syntax of the function and how to use Pi function in Excel. Wish you all success.
