Pi number is a mathematical constant with an approximate value of 3,1415926535897 .
Pi numbers can be found in many trigonometric and geometric formulas. Especially the formulas related to circles, ellipses, and spheres:
- The circumference of a circle is equal to the product of Pi and the diameter.
- The area of a circle is equal to the product of Pi and the square of the radius.
Excel developed the Pi function to help users apply trigonometric formulas when using software. This article software tips will guide you the syntax and usage of Pi constants in Excel.
Function syntax: = PI () .
Pi function has no arguments.
Example 1: In a cell A1, type the formula = PI () , the result is: 3.141593 .
Example 2: You have the diameter of the circle in cell B2 and need to calculate the circumference of the circle in cell B4 and the area of the circle in that B5. You apply the following geometric formula:
B4 = PI () * 2 * B2,
B5 = PI () * B2 ^ 2.
And you get the following result:
Above Dexterity software has guided you to read the function syntax and how to use the Pi function in Excel. Good luck.