PI (PI Function) in Excel - How to use PI numbers in Excel
PI (PI Function) in Excel - How to use PI numbers in Excel Picture 1
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 .
PI (PI Function) in Excel - How to use PI numbers in Excel Picture 2
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:
PI (PI Function) in Excel - How to use PI numbers in Excel Picture 3
Above Dexterity software has guided you to read the function syntax and how to use the Pi function in Excel. Good luck.
You should read it
- Do not round numbers in Excel, turn off rounding in Excel
- Instructions to stamp negative numbers in Excel
- Ways to round numbers in Excel
- Basic Excel functions that anyone must know
- How to use ISEVEN and ISODD functions in Excel
- How to fix the SUM function doesn't add up in Excel
- How to use Hlookup function on Excel
- How to use the LEN function in Excel
- How to use the SUM function to calculate totals in Excel
- Instructions on how to count words in cells in Excel
- How to use the MOD function and QUOTIENT function in Excel
- How to use subtraction in Excel
May be interested
How to blur images in Word
Synthetic wallpaper for the most beautiful Word
How to hide the Sheet Tabs (sheet bar) in Excel
How to adjust line spacing and line spacing in Excel
How to use Conditional Formatting to conditional formatting in Excel
Filter data that doesn't overlap in Excel - Filter for unique values in Excel